VB 6.0 - Access Database

Create DataGrid from Dataset connected to Access DB

Page 1 of 1

2 Replies - 2830 Views - Last Post: 21 October 2009 - 09:49 PM Rate Topic: -----

#1 David Berlinsky  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 15-October 09

VB 6.0 - Access Database

Post icon  Posted 21 October 2009 - 12:26 PM

[quote]I am working on an existing project using VB 6.0. I have researched some of the existing documents and found some data. I am trying to utilize an existing dataset that is attacheed to an access 97 Database. I want to create a new Form that will display a Datagrid of the Register Table from the Database. I have to run Two (2) queries one reguires parametrs for the start and end dates and the second is an update query. I am trying to understand the process so I can write the code.

Is This A Good Question/Topic? 0
  • +

Replies To: VB 6.0 - Access Database

#2 vb5prgrmr  Icon User is offline

  • D.I.C Lover

Reputation: 109
  • View blog
  • Posts: 1,016
  • Joined: 21-March 09

Re: VB 6.0 - Access Database

Posted 21 October 2009 - 06:23 PM

Use the data form wizard that you will find under add-ins>add-in manager...



Good Luck
Was This Post Helpful? 0
  • +
  • -

#3 bytelogik  Icon User is offline

  • D.I.C Head

Reputation: 22
  • View blog
  • Posts: 212
  • Joined: 06-October 09

Re: VB 6.0 - Access Database

Posted 21 October 2009 - 09:49 PM

If you just want to display the records, all you need is a data control and a datagrid.

Attach the data control to the Access 97 MDB using it's DatabaseName property.
Attach the datagrid to the data control using it's DataSource property.

Whenever you manipulate / query the database table using the data control, the datagrid automatically displays the records.

Your question is still incomplete about your specific results you want.

Let me know the exact problem you are facing.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1