This handles the server error, however it creates a new error that I am not so sure of. It seems that the first table information gets lost.
[code=setupWordApp.Selection.Tables(1).Select[/code]
Selects the second table in the document, and if I put it before the creation of the second table...
The intention was to have the dialog form open the search form (standard MS Access Search Box). My work around for this was to have the Sub call a form open and then end. On closing of the form that would call the next Sub to continue the processing. This eliminated any continuation of...
here is the portion of code that builds the word document. All of the variables are declared properly in the declarations section. There is a note in the code indicating where it crashes the lower half of the code was commented out for debugging purposes. Feel free to criticize the code, this...
I have my Access database create a word document and add a series of tables and other text data to it. This works perfectly for the first run of the code. On the second run I get an error with a remote machine server is unavailable or busy. I have done some investigation on this and found...
It has been awhile since I have used Access and I am trying to add a combo box for a field in a form that will update the remaining boxes when a record is selected from a table. Any help would be greatly appreciated.
This code worked great for one instance of the application. At a similar step it is required that I be able to open a search box. Because this method opens the form as a dialog it locks control to that form only. I need to stop the processing and still be able to open additional boxes from the...
I am developing a module that will generate a MSWord Document from either Database information or user input information that will be run from a switchboard. I am stuck on getting the code to pause while one of the data input forms is open. I have tried locking the code into a loop until the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.