form

[lendbz]

Hi,

This is a simple thing? I am a beginner and not sure how i would go about doing it.. What i want to do is, I want to create a form in access that would

1) let you browse thru the file directory to select the file that you want
2) have a button that, after you select the file, when you hit the button it will import that file to a table in the database

what is the best way to go about doing that?? thanks

lenny

 

[LittleSmudge]

Actually lenny that's not such a 'simple' thing.

You'll need a less than common control on your form called a TreeView control.

It is available from the additional controls list in the standatd Access toolbox

You will then need to populate that toolbox with the folders on your drive ( from some pre-determined root ) and when each of them is opened you'll need to populate the next level down etc. until you get to the files that you want to display.



As an alternative you could just bring up the File-Open dialog box and allow the users to naviage using that to the file you want to load.
Then use the file name returned by that in an Update query run by the DoCmd.RunSQL command to populate the field in the table.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[lendbz]

thanks!

How do i bring up the file open dialog box?



lenny

 

[LittleSmudge]

Many times this has been covered on this site - but, as usual, its a matter of knowing what key words to search on.

Try these

http://www.tek-tips.com/viewthread.cfm?qid=879446

or

http://www.tek-tips.com/viewthread.cfm?qid=678648

Or have a search yourself.


G.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[lendbz]

thanks it work