Link to home
Start Free TrialLog in
Avatar of triphen
triphen

asked on

VB6 MS Chart and Access Database

Hello Experts,

I have an Access database that is being updated every 30 seconds with a new record in the "DATA" table. The record that is inserted contains (Timestamp, Sales, Voids, Coupons).

I want to use MSChart to graph the 3 values (Sales, Voids, Coupons) on the Y axis and use the Timestap as the X axis.

I am having a hell of a time getting this to work. My programming skills are crappy at best :)

Any help is appreciated.
Avatar of triphen
triphen

ASKER

The input into the chart will be a constant 4 columns. The application will be similar to a stock market graph updating constantly from an Access database.
ASKER CERTIFIED SOLUTION
Avatar of BrianVSoft
BrianVSoft
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of triphen

ASKER

Brain,

Thank you for your response. I am having trouble getting this thing to work like I want it to. If I send you my access database, can you help me write the code that goes in the timer to refresh the graph?
I could give you an example - but not write the full code..
I would need to know which database "method set" you prefer to work with..
There are about 6 method sets you can use that are like language sub-sets..
You would need to be familiar with at least one of them.
If you are not familiar with ADO or DAO, you might try looking at common examples using Data-Controls. They are fairly easy to use.