File Location using call Windows

[Guest]

Hi
I want to click a button on a form for the file search dialog box to appear.
After selecting a JPEG or BITMAP image I want the file location transfered to
a field called 'PathToLogo' in the table 'tblLogo'. I can get the dialog box
to appear using the code from the website link mentioned in various threads
but cannot get the file location to save in the field.
http://www.mvps.org/access/api/api0001.htm

Please could I get a step by step guide.
Many thanks

Kevin.

 

[Guest]

Assuming that the variable you use as the return for the call to the common
dialog is varGetFileName
varGetFileName = ahtCommonFileOpenSave( _......
The you will need to assign the value in varGetFileName to your field.
Since I don't know how you are updating your table, I can't be sure how to
tell you to do that.
If you need more info, please post back with how you are handling the table
for other values.