Search results for query: *

This is the complete function operated by a clicking a button on the screen. The program uses a dat file (bomb.dat)to store the name of the file and directory or you could just omit this and enter the name and path within the code. All the best Donald Lane Private Sub PrintCmd_Click() On...

Thanks Andy, you have saved me headbutting the monitor a few more times

Hi, Thanks for the reply, I will add the DoEvents and see what happens. If the loop is removed then it appears that Word is closed to quickly and an error message appears, saying that closing Word will stop all printing and the option to click yes, no or cancel. Adding the loop stops this...

Hi All, I am using the following code to print out a word document from a VB Program. All machines tested on have the same setup (Windows 2000 and Office 2000) and administrator rights. On some machines this works okay and on others the document gets opened an spooled to the printer, but never...

Hi Adoozer, The second solution to my problem has worked great, many thanks. Just a question about the first solution, the line Dim withevents wrd as object is not accepted on my system. Also Object is not in the drop down list when I enter the line. Any comments? Regards Dongal

Many thanks for the information, I shall trundle away to my little pit and put it to good use. Dongal

Hi all, I have written the following code to open up a word document and then save it with a time stamp. This works fine. ( Path and File are variants storing the Path and file name of the document) Set wrd = CreateObject("Word.Application") Set docBomb = wrd.Documents.Open(Path...

You can perminently stop warnings in Access by going to the Tools menu and selecting options. On the Edit/Find tab you will find a box called confirm. Unchecking actions queries will remove all messages for queries. Unchecking record changes removes messages for appending or deleting any...

Hi, An alternative to setting up each ADODC to point to the database is to create a System DSN on the machine and then set this DSN to point to your database. The ADODC is then set up to use this DSN instead of the database directly. Then when transfering the program to a different machine...

I have created an Active X control to place inside the Data Repeater Control 6.0 on a form. When the form is resized all objects on the form are also resized including the Data Repeater, however, mo matter how hard I try the Active X control within the Data Repeater is only resized vertically...