Search results

  1. S

    Opening an Excel file in Access 97

    I created an Excel file using: DoCmd.OutputTo acOutputQuery, _ "Compile_Query", acFormatXLS, _ "G:\ServiceCompany\SanDiego\Warehouse\LCDLine_Summaries\Daily\" _ & DateMonth & DateDay & DateYear & ".XLS", False However, after creating this excel file, i want it to automatically...
  2. S

    Using Visual Basic together with Internet Explorer

    There is an online form which we need to fill out for each of our inventory units. This form has several dozen fields though. We have to fill each one out for every unit that we ship (which is about a hundred a day). But the good news is, about 25 of these 30 fields are always filled in with...
  3. S

    How to change the criteria of a Query from the VBA?

    I have a database consisting of one table with 5 columns, called Name, Zip Code, Model, Serial #, and Reference # I made a form with 5 text boxes (generically named Field 1 through 5), and then I built a query. I put all five of the table's fields in the query. In the criteria fields of those...
Back
Top Bottom