I currently have a table with an OLE object where I store pictures or documents. These items are embedded in the table. I would like to change this and just store the path&file name in the table. Questions:
1) do I change the picture field in the table from OLE object to text or do I leave it as OLE???
2).Currently, I use the following code to find and load the picture:
Private Sub picins_Click()
On Error GoTo Err_undo_Click
Dim OLEInsertObjDlg As Integer
OLEInsertObjDlg = 14
OLEBound499.Action = OLEInsertObjDlg
If Me![picture].OLEType = acOLEEmbedded Then
Dim OLEUpdate As Integer
OLEUpdate = 6
OLEBound499.Action = OLEUpdate
Forms![registrant].Refresh
End If
Err_undo_Click:
Exit Sub
End Sub
How do I change the code to just save the path and file name instead of the picture. I would like to keep the 'browse' option that comes up to find the picture, so that the user can find the picture, but once the user selects the picture, i would like to save that path/file name and not the actual picture.
As usual all help is appreciated.
Thanks
Sarah
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar