Entry

how to connet to aceess in vb

Jul 10th, 2004 01:06
amal k m, Abdel Wahab Salah, Deepak Bansal, Rachit Bagda, Pavan Kumar, prasad chavan, http://www.rtnaustralia.com http://www.keywords.com.ru

Add a textbox and DAO control to your form.
Open the properties of DAO control.
In the property DatabaseName specify the access .mdb file name along 
with the path. You can type directly the path & the mdb file name or 
you can use the browse button provided for the pupose.
In the Record Source property of the DAO control specify the table 
name 
by selecting from the pull down.
Leave all the other properties of the DAO control as is.
Now select the text Box.
Open the properties of TextBox
Select the DataSource proprty and give the DAO control's name. You can 
select this from the pull down.
In the datafiled property select the column name to be associated with 
the textbox from the pull down.
Run the Form and the first record's selected column data will be 
displayed in the text box.
As u click the next button on the DAO control the data in the txtbox 
alos changes.
http://www.rachit.com http://www.nsdsolutions.biz