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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.