Modify API that calls the standard windows file/open dialog

[EricB]

I have examined an API that calls the standard windows
file/opem save dialog on the following web site:
http://www.mvps.org/access/api/api0001.htm.
I would like to be able after having selected a file to
write the full path of the selected file into a table,
when the path information has been written to the table I
will call an outlook automation routine that will send
the attachment(s) to a predifined recipient using
outlook. What I'm really trying to figure out is on how
to write the selected file into a table.
If someone has experience with that I appreciate any
guidance or directions you could provide. MANY THANKS.

 

[Douglas J. Steele]

The API isn't capable of writing to a table: all it can do is return a
string to you containing the file name. You'll have to store the returned
file name in the table yourself.

You can create an INSERT TO SQL string and run it, or you can open a
recordset and use the .AddNew method of the recordset to add the new record.