Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBGrid & MSAccess

Status
Not open for further replies.

poipoi828

Technical User
Jan 15, 2003
1
0
0
MY
hi, i'm new in VB i have problem about
how to use DBGrid to display field from multiple table from Access, at the same time one of column(DBGrid)will used to enter data and update Access database.
 
Hi, to do that I think the best is to create a temporary table with the results of the query and then display data in the dbgrid. To update the table, you must set the property allowupdate to true. If you want one field to be modified, just lock the others like this:

DbGrid.Columns(1).Locked = True

The problem is thet before the update (in the temporal table), you´ll have to update the real tables.

Claudia

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top