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

    Insert (Append) query only adding first field

    Solved. It was a VBA problem, not a query problem.
  2. FabricMan

    Insert (Append) query only adding first field

    I'm trying to write procedures in my desktop app to import data from a flat text file (upwards of 800,000 rows) and append it to a table. I am doing this by creating a linked table with the exact same field structure and running an append query. I'm doing all of this in VBA. The procedure is...
  3. FabricMan

    Return last record inserted into table

    I don't know enough about your structure, but you might try timestamping users who enter records.
  4. FabricMan

    Save As FileDialog Workaround?

    I can't seem to find any of the methods you used in your example. Are there any special libraries I need to include?
  5. FabricMan

    Save As FileDialog Workaround?

    I'm writing a procedure to export a table to a flat data file on disk, but I can't create a FileDialog of type msoSaveAs. Microsoft's website says this feature isn't supported in Access 02. Does anyone have a good workaround for this problem? Dim objDialog As FileDialog 'Run-time error 445...
  6. FabricMan

    Reference form from another form's module

    I've been using Access forms as menus in a small app I'm developing. My main menu has a couple of text boxes (locked) to display certain statistics, and I want to be able to change their values from outside the module (i.e. a submenu/different form). Me works fine if I'm within the main menu...

Part and Inventory Search

Back
Top