9 Years
Discussion Span
Last Post by QVeen72

First try to understand the Data-bound controls. There is no DBGrid in that. There are DataList, DataCombo and DataGrid controls. Which one You are refering, I am yet understand. And please, while formulating questions try to keep as far as possible the correct spelling and grammar. You are not on a personal chat. You are on a thread that is viewed by many. Remember that.


you cannot use dbgrid without datacontrol because to make dbgrid contain all records from the table you need to first connect the dbgrid with the database and that you cannot do without a control in case of dbgrid.in this case you may face a problem when the database which was set in the control's properties not found in the speicfied location in the system.to overcome this problem you can use this code to dynamically connect the dbgrid with the your database.

data1.databasename=app.path & "\yourdbname.mdb"

use the above code after doing the following things:-
1.take a dbgrid and a datacontrol
2.set the databasepath and recordsource in datacontrol's properties
3.now set datasource in dbgrid's properties to the name of the datacontrol
4.rightclick dbgrid->select retrieve fields
5.now open datacontrol's properties and delete the values from both databasename and recordsource properties
6.now open code editor and paste the above code in a suitable event



DBGrid Cannot be used without datacontrol.

If u want to Set Dynamically, then use DataGrid, U can Set DataSource of a DataGrid To a RecordSet.


This article has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.