Library tutorials & articles
ADO Data Control
- Introduction
- What is a Data Control?
- Creating a bound form
- Running the Project
- Conclusion
- Properties
Running the Project
At this point, you’re ready to run the project so click F5. The form (in Figure A) displays the first record in the bound table (from Nwind.mdb). Click the navigational controls to move from one record to another. Remember, if you change the data in a record and then move to another record, VB will save the change.
Try to add a new record by first clicking the Last button and then clicking the Next button. The first click will display the last record in the bound table. The second click will display a blank record--if you’ve set the data control’s properties accordingly--as shown in Figure B. If your form doesn’t display a blank record, return to Design View, select the ADO data control and change it’s EOFAction property to 2 - adDoAddNew.
Figure B
Once you view a blank (new) record, you may encounter a problem if you try to return to a previous record. If your form includes any required fields, VB won’t let you leave the new record until you enter something in the required fields. This behavior includes primary key fields and any required fields you may not have displayed on your form. You can however, exit your form by clicking the Exit command button.
Related articles
Related discussion
-
VB6 Runtime error 381 subsript out of range Error
by Uncle (2 replies)
-
passing and reading parameters from using Shell
by jigartoliya (0 replies)
-
Convert C++ code to VB6
by mawcot (4 replies)
-
listbox scrollbar
by Dennijr (10 replies)
-
Can you describe Above simple VB6 code?
by pramodmca09 (0 replies)
Related podcasts
-
Christian Beauclair
14 mai 2008 (�mission #0074) ::.Christian Beauclair: Stratégies de migration VB6 vers .NET Nous discutons avec Christian Beauclair des stratégies de migration VB6 vers .NET. Entre autres, nous discutons comment utiliser le "VB 6 Code Advisor" et le "Interop Forms Toolkit" pour ajouter la puiss...
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path & "\db1.mdb"
dcPekerja.RecordSource = "Select * From Table1;"
End Sub
All you have to add is a tiny little "\" and there you have it. I suppose that you already figured it out by now but if not hope it helps. Also make sure that the database is in the same directory as the ".exe" or ".vbp"
Have fun coding!
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path + "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub
You Should Have
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = "\\db1.mdb"
dcPekerja.RecordSource = "Select * From Table1;"
End Sub
Or not
Well i supose you do have the database in the same directory with the application on the other computer
i'm using adodc to connect to access
but i'm having problem when i use the application on other pc...
it say that it cant found the database file...
i use this coding... but still the error is there...
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path + "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub
i also try this code...but nothing happens...
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path & "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub
dcPekerja => adodc
Gave me insight, thanks
IMHO - The Data Control's sole usefullnes is when you literally want to scroll the data, one record at a time.javascript:smilie('
')
frown
I find it MUCH easier to roll my own ADO RS control that will search for the resocrd(s) I need...javascript:smilie('
stick out tongue javascript:smilie('
wink
This control should ONLY be used by total DB Newbies!!! (IMHO)javascript:smilie('
eek!
This thread is for discussions of ADO Data Control.