How to pass a value to AN ACtiveX

[gilmckee]

I am new to true coding in MS Access. I am trying to get an activeX control to display a value from a field in a query. I am not sure at all how to do this. I have the activeX control on my form.

Can someone tell me how to do this with the following variables?

Form Name = form1
Table Name = table1
Query Name = query1
ActiveX Name = gauge1
Database Name = OT1.mdb

I am creating a dashboard, so it will need to update each time a record is added to the table that underlies the query, so that the value shown on the gauge is accurate.

The update to the table will be every 15 minutes and the gauge will need to reflect the new records after that.

 

[boblarson]

What ActiveX control are you using? Each one can be different in the properties it has and how you set things. So, where did you get it? What does it do? It looks like it is some sort of gauge but what exactly is the name of the control (in the ActiveX list)?

 

[gilmckee]

I got it from dragonflydas.com. It is part of their ActiveX Windows component package.

They have several gauges. I am using the circle gauge -DAS_CircleGauge3.

I appreciate your help.

Gil

 

[gilmckee]

The gauge will be reading a tank level stored in a table in my Access database. The table is getting its readings from an OPC connection to an Emerson Wireless Gateway that is remotely monitoring the tanks via wirelss thumbs.

 

[boblarson]

Okay, since you purchased this from them, they are the ones you need to contact for support in how to use the control. But the first place I would start is at their samples page which shows how to use VB6 with this control (look for the Gauge ActiveX Control VB6 Sample).

 

[boblarson]

You may have to modify the code slightly to work with VBA. VBA in Access (since Access 2000) is BASED off of VB6.

 

[gilmckee]

Thanks for the insight. I tried reading that, but maybe I didn'y state clearly enough that I am new to coding. I have built many visual dbases, but not coded. So I din't understand the 4 pages of code they ahd written. I need help so I came here. I appreciate your thoughts, but as I am not really a dumb person I DID start there and then came here.

 

[boblarson]

So, can you tell me how to change the filter for my airconditioning on my Kia? I am not trying to be mean or anything but you are asking alot for a specific piece of "hardware" which we haven't ever used or even seen. How are we to know how to code it unless we were to go download it all, and then search through it and such.

If you don't understand their samples, then what's to say we'll do any better?

You should contact them via their email address: support@dragonflydas.com

and ask your questions and see if they can help you with their specific control. If you tell them that you are having trouble understanding the samples because you don't have a lot of coding experience, I'm sure they can help. But they can help you more than us who have not seen it.

 

[gilmckee]

So coding an ActiveX control is not a standard deal? They do not all have a common coding form? I guess is what i am asking. I would think passing a value would happen the same way no matter the control. But apparently that is incorrect.

Actually I can tell you how to change the filter, but that is just coincidence!

What I am saying i sthat I need a base understanding of how to pass a value. Ia ssumed a forum of programmers was a place to start. I wasn't asking you to write my program. That is why I gave you generic names so I could get an understanding and learn the basics

 

[boblarson]

Most controls have a .Value which you can set. ActiveX controls can have myriad ways of doing things. They don't have a standard way, and depending on who wrote it and what they included it can require you to do things in whatever way they wrote it.

Usually they add some functionality which is not available in the standard controls that are included in whatever program (be it Access, VB6, VB.NET, Visual C#.NET, etc.). The key is knowing what methods, events, and properties are available to you and that is where the people who developed it come in. If you purchased it from someone they usually provide support for using it. All you have to do is ask them.