Opening file 'browser' from access form

[addy]

Hi

I am sure I saw this done some years ago and cannot remember how it was done.

What I would like to be able to do is browse the files and folders on my computer, from my form.

I remember seeing a 'My Computer' browser embedded in a form before but can't find anything on Google to help me and ama bit stumped.

Thanks.

 

[PHV]

Depending of your version of access you may play with the FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[addy]

Cheers mate - looking at that plus related help links will do the trick I think.

 

[addy]

PHV - quick question please.

I read up on the FileDialog and it looks like it is what I need but I cannot get it to work. The example I looked at says I need to declare a variable as a FileDialog object whcih is just:

Dim fd As FileDialog

but I then get an error saying "User defined type not defined".

Any ideas?

Thanks.

 

[ZmrAbdulla]

You need to set the reference to
(I think it is) "Microsoft Office Object xx.x library"

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[addy]

Thanks very much.

However, I feel a bit stupid as I noticed this reference on the Microsoft website and when I looked at my references, I thought I already had it selected and that is why I was confused as to why it wouldn't work.

Turns out I thought 'Microsoft Access 11.0 Object Library' said 'Microsoft Office 11.0 Object Library'

What a fool.