rogerdjr
asked on
Combo box to select file names
Looking for a way to have a combo box act like explorer searcing directories and when I identify a file to link to the record, click on it and it saves the link / file & path name
aikimark: Is the combo in Access?
Sid
Sid
But when I replied there was only "Microsoft Applications"?
Sid
Sid
Maybe OP added 'Access' Later?
Sid
Sid
Ah! How dumb of me? lolzzz
Yes I missed that. Thanks.
Sid
Yes I missed that. Thanks.
Sid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The sample DB from this site should give you a good start:
http://www.lebans.com/callbackbrowser.htm
http://www.lebans.com/callbackbrowser.htm
ASKER
Public Function SelectFile() As String
Works great - is there a way to "preset" the function so it starts at a selected path?
Thanks
Works great - is there a way to "preset" the function so it starts at a selected path?
Thanks
Add a static string variable that contains the path.
Near the top of the routine check the length of the variable. If = 0 then initialize it with a default path.
Near the top of the routine check the length of the variable. If = 0 then initialize it with a default path.
Sid