OLE problem

K

Kjell Harnesk

I have an unbound OLE control on a report. How do I by code change the
path/filename that is the source for the control?
 
W

Wayne-I-M

Hi

Ther are a few methods
Prompt (from the report's base query) for the user to input path
Base report on a form with a set of paths in a listbox
You can set some vba to select the path based on user input
etc

Can you give a little more information about what you are trying to do
ie.
Are the paths taken from the same folder
Are they stored in your DB
Are they linking to an external application (outside office)
etc



Have a look at this
http://support.microsoft.com/kb/170531
 
Top