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