UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Set Unbound OLE Control Content To Value Of An OLE Field., Access 2003    
 
   
javert
post Aug 9 2018, 12:54 PM
Post#1



Posts: 79
Joined: 18-January 16



Hope this is quick.

I have a small number of equations of the type Microsoft Equation Editor 3.0 embedded on an OLE field in an Equations table.

I want to display the proper equation in a form according to the value selected in a combobox (its source is the id field in the Equations table), but I'm not sure how to do it since OLE unbound controls don't have a Value field.

I want something like this to work:

Me.OLEEquation = DLookup("equation","Equations","id = " & Me.EquationCombobox.value)

Which property of the unbound control should I use? Can the DLookup function return the appropiate embedded OLE object that resides in the field?
Go to the top of the page
 
theDBguy
post Aug 9 2018, 01:04 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,500
Joined: 19-June 07
From: SunnySandyEggo


Hi,

It's probably still possible to do it the way you want but I am thinking it might be easier to use a subform instead.

Just a thought...
Go to the top of the page
 
javert
post Aug 9 2018, 01:22 PM
Post#3



Posts: 79
Joined: 18-January 16



A subform with a bound frame whose filter change according to the combobox?

hmm... that's quite easy. I'll go for it since I don't want to keep bumping my head into sourcedoc / sourceitem and other properties. Thanks for the lead.
Go to the top of the page
 
theDBguy
post Aug 9 2018, 01:39 PM
Post#4


Access Wiki and Forums Moderator
Posts: 73,500
Joined: 19-June 07
From: SunnySandyEggo


Hi,

You don't even need to filter the subform. Simply link it to the combobox using the Link Master/Child Fields.

Hope it helps...
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th October 2018 - 06:52 AM