in ms access reports, i have an olebound object. how can i dynamically via vba change source doc.
K ken Oct 5, 2009 #1 in ms access reports, i have an olebound object. how can i dynamically via vba change source doc.
A Alex Dybenko Oct 5, 2009 #2 Hi, if you have bound OLE field - than it get changed based on bound field. You can change unbound ole field using VBA -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
Hi, if you have bound OLE field - than it get changed based on bound field. You can change unbound ole field using VBA -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
K ken Oct 5, 2009 #3 thks for reply but i currently have the following triggered by the open event. it does not seem to work..any idea what i am doing wrong If x = 1 Then Me.OLEUnbound1.Object.SourceDoc = "C:\Disclosure_30.rtf" Else Me.OLEUnbound1.Object.SourceDoc= "C:\Disclosure_50.rtf" End If
thks for reply but i currently have the following triggered by the open event. it does not seem to work..any idea what i am doing wrong If x = 1 Then Me.OLEUnbound1.Object.SourceDoc = "C:\Disclosure_30.rtf" Else Me.OLEUnbound1.Object.SourceDoc= "C:\Disclosure_50.rtf" End If
A Alex Dybenko Oct 5, 2009 #4 Hi, try to run these lines afterwards: Me.OLEUnbound1.Verb = acOLEVerbShow Me.OLEUnbound1.Action = acOLEUpdate You can also consider using this control: http://www.lebans.com/richtext.htm -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
Hi, try to run these lines afterwards: Me.OLEUnbound1.Verb = acOLEVerbShow Me.OLEUnbound1.Action = acOLEUpdate You can also consider using this control: http://www.lebans.com/richtext.htm -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
