Search results for query: *

I am trying to take a record from an Excel 2000 spread sheet and populate an online form (using IE6). I can easily transfer data between two Office applications (e.g Word and Excel) by using CreateObject etc, but I cannot figure out how to transfer data from Excel to an Internet form! Any tips...

I have a relatively simple Excel macro that runs extremely slowly when McAfee AV software is enabled. I want to be able to disable McAfee AV at the begining of the macro and then re-enable it at the end. Is there a Windows API or command line function that can perform these functions? The macro...

How do you use your Word form? Do you simply enter information into the form and then print it or save it? If this is the case, the easiest solution is to simply enter the information into the access database first, and then setup a Mail merge document in Word with a connection to the Access...

Hi, Just use the Dir command (works in a similar way to the DOS DIR command) e.g Sub PicCommandButton_Click() If Dir(Me![imagepath]) <> &quot;&quot; Then Me![imageframe].Picture = Me![imagepath] Else: Me![imageframe].Picture = &quot;c:\default picture.jpg&quot; End If ' If file exists...

I have a data access page with pictures that I want to email to many people as the body of an email (Not an attachment). I currently use the File; Send To; Mail Recipient option when the page is displayed, which seems to reformat the Data Access Page and sends all text and pictures perfectly...

I have a query subform called [Project subform] which is displayed in form view on a form called [Project]. The following code is located in the double click event of one of the controls on the subform and opens another form called [ProjectView]. The criteria sent to open form [ProjectView] is...

In a relational database, the best way to display information from multiple tables on one form is by using subforms.

I have found a solution - Just add objWord5.Application.DisplayAlerts = False before closing the document - seems to work ok. cscdesktop - Sorry, I can only guess reasons why this occurs - Is the mailmerge you are performing very large? (Lots of pages?). Have you monitored the CPU usage with...

The following code is a snapshot of a simple mailmerge from an access 2000 database called lord2.mdb. This routine works perfectly well if Word is NOT already open but if it is already open , I get a dialog box asking me if I wish to save the changes to the original mail merge document...

The body of an email I send simply contains one line of comma separated information which is then manually pasted into an Access database. Is there a way of making the email automatically update the database when it arrives at its destination (In a similar way that Outlook Net Folder emails...

I need to be able to find out the names of all open Word documents and close specific documents if they are open. Some of the documents may be hidden. The script would ideally work with both Word 97 and Word 2000 and be called from an Access 2000 database. Is there an easy way to do this ...

Is it possible to change the top margin of a combo box to allow vertical repositioning of the text? - Any info on this would be very much appreciated