Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mustardxhead

    MS Access Remote Server Connections

    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...
  2. mustardxhead

    Pause Code Execution While form is open

    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...
  3. mustardxhead

    MS Access Remote Server Connections

    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...
  4. mustardxhead

    MS Access Remote Server Connections

    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...
  5. mustardxhead

    Form Data Updates

    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.
  6. mustardxhead

    Pause Code Execution While form is open

    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...
  7. mustardxhead

    Pause Code Execution While form is open

    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...

Part and Inventory Search

Back
Top