Question about Microsoft Windows XP Professional
Am making project on school bus managment system but am not able to access data frm the table or insert in to table
am using following code kindly guide me if thr is any error in code
If cnn.State = adStateOpen Then cnn.Close
Set rst = New ADODB.Recordset
rst.Open "studrec", cnn, adOpenDynamic, adLockOptimistic, adCmdTable
.AddNew("Name") = TXTNAME.Text
.AddNew("fname") = TXTFNAME.Text
.AddNew("area") = TXTAREA.Text
.AddNew("class") = txtclass.Text
.AddNew("root") = txtrootno.Text
.AddNew("bus") = txtbusno.Text
Proper syntax is:
!FirstName = strFirst
!LastName = strLast
Do you have the ADODB library loaded?
While in "Code" view...menu/tools/references ... look for a check by "Microsoft ActiveX Data Objects x.xx..."
If you don't have ADO reference library then setting ADODB recordset won't work no matter what syntax you use.
Hint: try using Ctrl+J while you code. The library will show you available syntax as you type.
Posted on Jul 21, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 26, 2011 | Computers & Internet
Dec 30, 2008 | Computers & Internet
Nov 18, 2008 | Computers & Internet
Jul 19, 2008 | Computers & Internet
Jul 17, 2008 | Microsoft Windows Server Standard 2003 for...
479 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: