#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Posts
    2
    Rep Power
    0

    VB Database Problems also MSChart


    I have been searching all over microsoft's pages, on google, yahoo, even did a search in the forum and any place I can think of for a tutorial on this.

    I have an access database that is something like this:
    ___________________________
    |Salesman | Total Sales |
    |--------------------|-------------------- |
    | some data | data |
    | data | data |
    | data | data |
    | data | data |
    |--------------------|-------------------- |

    (please forgive my bad ascii skills)

    Could someone please explain how I can access this database, add data to this table and display the data on a graph with MSChart?

    Thanks in advance.
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    How to access the data is easy enough depending on how technical you want to get.
    You have several built in components that will allow you to easily interact with an access database. You have a DAO data control and an ADO data control. There are example with these links on how to use each of them.

    You will find info for the mschart control here.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Posts
    2
    Rep Power
    0
    Thank you very much, I will look into that.

IMN logo majestic logo threadwatch logo seochat tools logo