Changing OLE Picture on Report Form at runtime

[csr]

I have a report on which I have dropped an OLE Picture. However, I would like to allow the users to periodically (Not often) change the FILE that is associated with that picture. They may need to do this once each 6 months. I would like to give them a place in the software to designate the filename of the file that should appear on that report. However, I see no means of getting that into the properties of the OLE Picture on my report form during runtime.

Any ideas ?


Don

 

[Mike Gagnon]

How about storing the file name and path in a public variable and using the variable in the OLE Picture control.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[csr]

Well, that is what I would like to do but I do not know how to use a variable name in an OLE control property.
This is a report form with an OLE control on it.


Don

 

[Mike Gagnon]

In the OLE control "filename" area put the name of the variable instead of pointin to an actual file. (Call it lpFilename for example). Declare the variable public somewhere prior to issuing your report command and store the fullpath and file name you want to use for the report.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.