Browse and Open Folder Based on Matching Form Field - tomlam

[tomlam]

Hi All



My situation is that the access form field name is "Number" , there is a folder named "member" in
desktop C:\Users\Tom\Desktop

for example If i press the command button (Field name "Number" is 123) in form , then automatic open named "123" folder inside named "member" folder

What is the Command button Code ?

Thanks for your help

Tomlam

[June7]

You want to open the file browser? Review http://www.cpearson.com/excel/browsefolder.aspx

[tomlam]

thanks for your great help for introduce website for my learing. after see the website, i still dont understand how to write the command button code for my questions. if can give me more tips how to write, it will be appreciated. thanks you

[June7]

What don't you understand? Do you not know how to create VBA event code behind a command button?

Here is another reference showing code for a button click event. Just copy/paste it behind a form and create a button with the same name as the procedure. http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[tomlam]

Hi Super Moderator

Thanks for your help and i can make it . This help me in my job
Thanks for yr great help

Bye...
TomLam