S
schasteen
On one of my first databases I used an OLE object in a table to store mostly
picture of defects, but sometimes our customers send word or excel documents
that we attach. The database is getting very large and slow. I want to
redesign it and take out the ole object and store the path string and then
just show the document in a form or report when they are loaded. I have
figured out how to do this for pictures in both and how to handle other
documents in forms, but I can't get them to show up on reports. I have tried
using bound and unbound object frames in the reports and the on format event
of the details to set the source doc but I get an error when on the action
method (code sample below). Is this possible and how, or am I going in the
wrong direction? I am using Access 2000.
Thanks
Private sub Detail_format (..)
Me![ole1].sourcedoc = Me![Path]
Me![ole1].action = acOLECreateLink
end sub
picture of defects, but sometimes our customers send word or excel documents
that we attach. The database is getting very large and slow. I want to
redesign it and take out the ole object and store the path string and then
just show the document in a form or report when they are loaded. I have
figured out how to do this for pictures in both and how to handle other
documents in forms, but I can't get them to show up on reports. I have tried
using bound and unbound object frames in the reports and the on format event
of the details to set the source doc but I get an error when on the action
method (code sample below). Is this possible and how, or am I going in the
wrong direction? I am using Access 2000.
Thanks
Private sub Detail_format (..)
Me![ole1].sourcedoc = Me![Path]
Me![ole1].action = acOLECreateLink
end sub