07-07-2003, 08:49 PM
Hi Guys,
I couldn't find a sensible forum on the net for VB so I though I could post here. I have kinda forgotten VB(Havent used it in agies!). So I was trying to brush up on it.
Heres my prob:
I am trying to make a prog which uses a MsAccess database. Now, I want to access the contents of this DB using the DBGrid. How do I do this?
I dont want to use the DAO for this purpose. The interface is simple.
The fields in the database would be:
Item Name | Rate | Quantity | Total
The user will enter the info in 3 text boxes and when he presses enter on the last text box the item would be added in the database and the 'Total' would be calculated automatically. This table will be in the DBGrid and the text boxes would be below this table. Whenever the user adds an item and presses enter on the last text box it should get added in the DB and the DBGrid should be refreshed.
Any help would be appreciated.
I couldn't find a sensible forum on the net for VB so I though I could post here. I have kinda forgotten VB(Havent used it in agies!). So I was trying to brush up on it.
Heres my prob:
I am trying to make a prog which uses a MsAccess database. Now, I want to access the contents of this DB using the DBGrid. How do I do this?
I dont want to use the DAO for this purpose. The interface is simple.
The fields in the database would be:
Item Name | Rate | Quantity | Total
The user will enter the info in 3 text boxes and when he presses enter on the last text box the item would be added in the database and the 'Total' would be calculated automatically. This table will be in the DBGrid and the text boxes would be below this table. Whenever the user adds an item and presses enter on the last text box it should get added in the DB and the DBGrid should be refreshed.
Any help would be appreciated.
