ACCESS 2003: Linking form specifications to import a specific file

Joined
Jun 9, 2011
Messages
2
Reaction score
0
Hi there,

I was hoping someone could help me with the following problem:

I have a form (formImport) where there are many options & combo boxes such as:
-cbSelectCompany
-cbMonth
-cbYear
option group: Select File Type: Invoice, Cheque, etc.

What I would like to do is:
Once the user has selected the file they would like to import into the database by using the browse button (code by Ken Getz) is instead of automatically importing, the user must describe the file by the above options and then the file will be uploaded into the database.

More or less like when you upload your resume on a recruiting website, you must identify if its a resume, cover letter etc. then they are imported and you can see in a table what you have loaded & their descriptions.

The descriptions that the user selects should be stored in a separate table to help identify which files have been imported & for further functions that the database must perform on those imported tables.

I hope this makes sense.
Any help will be much appreciated. Thanks :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top