Scroll through records?

[jeffro]

Hi everyone! I have a data entry form in my program and I would like to be able to scroll through the records from the Access Table. Well I'm using the ADO Data Control 6.0 (SP3)(OLEDB), but looks like it is unenabled on the form and will not doing anything when I click on the arrows. Am I using the wrong component or is it something else? Thanks for any help.

[Shafee]

Click the link below. This might be of help.

http://msdn.microsoft.com/library/de...atacontrol.htm

[jeffro]

Shafee

Do you think the reason the ADO control is not working is because the form a child form off of a MDI Form? Just wondering.

[Shafee]

You will have to bind a control to the ADO data control. Then only it will be enabled. If the data control and the other controls are in different forms you cannot do this.

[Shafee]

You will have to bind a control to the ADO data control. If the data control and the other controls are in different forms you cannot do this.

[jeffro]

ok be patient with me Shafee, but I don't understand what you mean by bind other controls??

[Shafee]

Here is what you have to do.

1. Draw an ADO data control on the form.
2. Draw a text box.
3. Right click ADO data control and click ADODC Properties.
4. In the resulting dialog box, select Use Connection String and then click Build.
5. Another dialog box appears. Click the Provider tab.
6. Select Microsoft Jet 4.0 OLE DB Provider from the list which appears and then click next.
7. Enter the path and filename of the database you want to access and then click Test Connection. A message appears telling you that the test connection succeeded.
8. Click OK.

Now the data control is ready. The next thing you have to do is to bind the text box to the data control. To do this:

1. Set the Data Source property to the name of the ADO data control.
2. Set the Data Field property.

Now you will be able to navigate through the database.

[jeffro]

I tried going to the data source for the textbox but when I click on it the program flickers through all the forms and does not allow me to enter a data source.
sorry!!

[Shafee]

For that both the ADO data control and the textbox should be on the same form.

[jeffro]

They are on the same form. I don't understand it seems to be an easy tasked but for some reason it's not working!

[Shafee]

I forgot one step in setting up the data control. You must set the RecordSource property. To do this, right click the ADO data control and click ADODC Properties. In the dialog box which appears, click the Recordsource tab. Select adCmdTable as the command type, and select the table in the next drop down box. Click ok and then try to change the Data Source property of the text box. It should work now.

Ok do not data bind your controls...called early binding by the way.....it will lead to tears honest. Use code to populate your controls, if need an example will email you a small training app we have which uses DAO, but is not too hard to modify to ADO.

Why shouldn't you use early data binding, post as a question and get ready for a fire storm.

[jeffro]

Hey Jethro,

sorry our names look the same. I would appreciate it you would email the training app. Thanks alot!

Only problem is our office is packed up at the moment for a move, so don't have PCs etc....will be setup on Monday/Tuesday next week, (bloody olympics), and will send to you then.

[jeffro]

Hey thanks a lot Jethro I appreciate the offer!!!

It has been a b****h of a move but am almost setup so we email in the next few days.

[jeffro]

Hey Jethro,

That is ok take your time. I'm kind of working on a problem with Crystal Reports.

Thanks again!