Ken,
Thanks for the tip. I'm just learning some of the basics of programming in Access and will give it a shot.
What is the best way to loop through all files in a directory? I know the number of files at any given time so I could change the variable with each run, but is there an easy way of...
I searched the posts so far on this subject and haven't been able to pull together all the pieces I need. I have a directory of about 50 txt files I want to import into an existing Access table. There is one extra field in the table (the last field in table, in doing manual importing I was...
DougP,
Thanks for your help on this post, it certainly sent me in the right direction. Sorry it's taken so long to get back.
I came up with the following because I am actually looking up values from an Oracle database.
'declare global Object variable
Dim OracleDB As Object
'I established a...
I'm fairly new at using forms in access and this seems like it should be a simple issue. I want to use a form to populate an underlying table after the user keys in a code number. I want to use this code to look up certain information from a lookup table containing info on this code. I only want...
A user compacted a database and
is now getting an error each time she tries to open the
database: Record(s) can't be read; no read permission
on 'MSysModules2' I tried to create a new database and
import tables from the corrupted database but only got an
error stating: You don't have...
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.