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!

Register Log in
  • Congratulations Chris Miller 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. calalli

    Excel PageSetup call causes crash

    Richard and Skip, thank you for your replies. I tried to simplify the question and omitted to much information perhaps. This application has worked fine in production for over four years, it is the conversion to Access 2003 that is problematic. I cut out much code attempting to get the...
  2. calalli

    Excel PageSetup call causes crash

    I have an application written in Office 97 that is being converted to Office 2003. The application exports the results of a large query to Excel for formatting. Early in the code I set up the references Set MyXLApp = GetObject(, "Excel.Application") Set MyXL = GetObject(xlsBookName) later...
  3. calalli

    How to run Access modules unattended.

    I have an application which currently produces a large print job. The users would like to have this run early in the morning, before they arrive in the office. How can I set up Access to run at say 6:30 am and run a given database module ? I can leave the PC on, and Access open over night...
  4. calalli

    Pasting recordset to Excel

    I have an application which submits a request job to a mainframe and then retrieves a text file. I do a great deal of formatting depending on the request and then create a report in excel. Currently I am looping through a query recordset and writing the values to excel. At some point I saw...

Part and Inventory Search

Back
Top