Answer Questions

• JHD VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• kwilder xp style to vba forms

  hi, i would like to apply the xp theme to my msforms in (excel) vba.  i have not been able to find any information on doing this.  i saw this done in a stand alone xla so i know it works.  any help would be greatly appreciated. -b Per one of our support engineers: From the email, my understanding of the problem is as follows. If there is misunderstanding, please correct me. You want to ...Show All

• c01dfire MODI Port

  I have some questions: 1.- How to distribute MODI Port with my application 2.- Found MSM (module merge) 3.- How to install "Microsoft Document Imaging Writer Port", without CD office 4.- That files use the MODI 5.- The files .MDI is better of PDF ! Tks a lot, i have problem in using MODI namespace. my target is how to let the output of my program as .mdi file. in at ...Show All

• Bineon MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• Silkflour Word Automation; documents and templates

  Using VBA I want to open a blank, new Word document 1) How do I declare which template is to be used 2) How do I manage to save the document (after filling it by manually typing) without affecting the underlying template (for instance, Normal.dot). The system gets to ask to save first the document, the template afterwards, but I would like to save just the document, and leave the template untouched thanks Documents.Add method can be ...Show All

• PrasannaGPKBE VB Script Crashes Access When Exporting to Excel

  I am trying to solve a minor problem for a small school running Access 2000 on a network. The program runs well with several forms and reports. The problem is that one of the reports is exported to Excel. This works fine except when the database is moved off the network, the export process either produces an error message or crashes Access. The database filename is AA92603.MDB. When it is copied to the C: drive on a computer off th ...Show All

• xurfie Using VBA to send an MSN instant message

  Hi I have written some VBA in Access 2003 to bring up an MSN instant message window and send a message to that contact. The only problem is, I seem to be able to do everything except actually send the message! I think this feature may have been removed from the API. Anyway, here's the code: - Private Sub SendIM()      Dim header As String Dim objmsgr As MessengerAPI.Messenger Dim contact As MessengerAPI.IMessengerContac ...Show All

• Chrutil No Database Type

  I want to use VBA to program to get data from an Access database. Do i need to install VBA besides installing Access (VBA and Access are 2 separated sofwares ) or i need to install Access only . Please help. Thanks.  Per one of our support engineers: In Access 2003, it is very strong support for development program on the access database (almost like a dev software). For other Access versions, the de ...Show All

• Yomi Redistribution of SQL Server Management Studio Express?

  Hi, We are a registered partner and have registered for redistribution rights to SQL2005 Express. We would like to know if SSMSE will fall into the redistributable category, or can we publish a link to the download from our support site, (troublesome link maintenance) We do not think we want to give this tool to all of our Express users, but it certainly would be handy for Power Users or in particular support cases. Thanks in advance J ...Show All

• Mighty-O VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. No problem. Thanks alot for your help:)) ...Show All

• Iago Problem With Code That Writes a Change To Itself

  I have written a sub that modifies the code in the if statement of a functon in a different module. Trouble is that during runtime, I haven't found a way to get the equivalent of a Compile VBAProject to occur so that the behavior of the function actually changes on the fly. Even though the code is changed by the technique, the behavior when called always stays v1 > v2. Isn't there a way via the VBIDE classes or something to get the recompile ...Show All

• LAZARUS Serial Port Communication Using MS Access VBA

  Need help using MSComm.ocx in MS Access 2000. I have successfully registered the file and have gotten passed licensing issue. However, I am not sure how to use the control to read the data. My code reads: mscomm1.comport = 2 mscomm1.settings = "9600,N,8,1" mscomm1.portopen = true mscomm1.inputlen = 0 buffer = buffer & mscomm1.input (this line of code returns nothing) Any help is greatly appreciated. ...Show All

• Randal Greene Runtime error '-2147467259(80004005)';

  Hi, Iam using vb6.0 and database is PostgreSQL,when iam trying to connect database using Connection String iam getting error like this Runtime Error '-2147467259(80004005)'; Could not connect to the server Could not reslove hostname. ********************************************************************************* can anybody slove this Per the support engineer: Is there a native OLEDB provider for PostgreSQ ...Show All

• Lokka Sharepoint 2007 Site Template

  Hello, I'm probably just missing it but where/how do you create a site template in beta 2 of sharepoint 2007 I don't see it anywhere in site settings. Is creating a site template even available in the beta Any feedback would be greatly appreciated. Thank you! Hi Mark, The best resource for your question is probably the Office beta newsgroup or one of the main SharePoint newgroups on http://www.microsoft.com/sharepoint/community.msp ...Show All

• MSKarsin Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD Hello, Try calling the method dir ...Show All