G
Guest
I have a form to store pictures. The pictures are linked
to the db and not stored in it.
I have the following fields in a table
ImgID - PK
Pic - data type OLE Object
File_Path - data type text
I am able to bring up the InsertObject dialog box where I
can browse to select the picture from the directory where
it is stored using the commands below.
DoCmd.GoToControl "Pic"
DoCmd.RunCommand acCmdInsertObject
How can I store the directory where the file is located
in the db in the File_Path in the table. I would like to
automatically copy it from the InsertObject dialog box
and insert it in the File_Path field, or any method where
I do not have to type it manually?
to the db and not stored in it.
I have the following fields in a table
ImgID - PK
Pic - data type OLE Object
File_Path - data type text
I am able to bring up the InsertObject dialog box where I
can browse to select the picture from the directory where
it is stored using the commands below.
DoCmd.GoToControl "Pic"
DoCmd.RunCommand acCmdInsertObject
How can I store the directory where the file is located
in the db in the File_Path in the table. I would like to
automatically copy it from the InsertObject dialog box
and insert it in the File_Path field, or any method where
I do not have to type it manually?