Question about Microsoft Windows XP Professional

1 Answer

Am not able to add/ retrive data

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
With rst
.AddNew("Name") = TXTNAME.Text
.AddNew("fname") = TXTFNAME.Text
.AddNew("area") = TXTAREA.Text
.AddNew("class") = txtclass.Text
.AddNew("root") = txtrootno.Text
.AddNew("bus") = txtbusno.Text
End With

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 70 Answers

Proper syntax is:
With rstTemp
!FirstName = strFirst
!LastName = strLast
End With

Do you have the ADODB library loaded?

While in "Code" ... 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


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

How can I restore my SQL database from .frm files?

You just copy the .frm files to the to the databse folder but you also need to copy the ib_logfiles and ibdata file into your data folder. I have just copy the .frm files and copy those files and just restart the server and my database is restored.

Best Professional Resume Writing Service Online from Washington USA...

Oct 22, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...

1 Answer

School management system

you can download it from

Jan 30, 2010 | Microsoft Windows XP Professional

1 Answer

Hello to i need defination of microsoft access now.thanx

A database is a collection of information (or data) that is organized to make retrieving specific information easy. Access isa software application used to create and manage a computerized database.
Microsoft Access is database software that tracks information for business or individuals. It's included in the Microsoft Office suite or as a stand alone program. Access is a relational database management system that links tables through common fields such as a part number, invoice number, or social security number. Relational database management systems can eliminate duplication of data and enhance validity by specifying relationships between tables.

Jan 11, 2009 | Microsoft Access 2002 for PC

1 Answer

I'd like to know how to retrive the trailers that i've downloaded

Depending on what files you want to burn to CD. If it is just Data then insert a blank CD and open with nero, choose burn data cd. In the window that comes up next browse your computer for the files that you want to burn, then click on add, once you have added all of the files that you want to burn click finished. Another window will come up with the option to name the cd and for you to decide on whether this cd will be for use with your computer only or with all/most cd players you should also be given the choice as to whether or not you want to make the cd a multi session cd (meaning that you can add more data to it at a later time, please note though that if you do add more data to the cd at a later date do not rename the cd otherwise it will not work.) Once you have chosen your desired options then click on burn to burn the cd.

If you are not sure where your downloaded files have been saved then run a search in windows for the files and make a note of where they are.

I hope this helps

Dec 15, 2008 | Ahead Software Nero 6.0 (60045) for PC

1 Answer

In visual basic , how to store data or retrive data in or from a various tables

You must not be referencing the second table properly, the reason your first one works is because it is automatically referenced, what I mean is that Me.dataTable and dataTable will both work in the same scope.

Jul 19, 2008 | Computers & Internet

1 Answer

Use and access

Imports System
Imports System.IO
Imports System.Data
Public Class SaveImage
Shared Sub main()
Dim o As System.IO.FileStream
Dim r As StreamReader
Dim gifFile As String
Console.Write("Enter a Valid .Gif file path")
gifFile = Console.ReadLine
If Dir(gifFile) = "" Then
Console.Write("Invalid File Path")
Exit Sub
End If
o = New FileStream(gifFile, FileMode.Open, FileAccess.Read, FileShare.Read)
r = New StreamReader(o)
Dim FileByteArray(o.Length - 1) As Byte
o.Read(FileByteArray, 0, o.Length)
Dim Con As New _ System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data
Dim Sql As String = "INSERT INTO images (Pic,FileSize) VALUES (?,?)"
Dim Cmd As New System.Data.OleDb.OleDbCommand(Sql, Con)
Cmd.Parameters.Add("@Pic", System.Data.OleDb.OleDbType.Binary, o.Length).Value = FileByteArray
Cmd.Parameters.Add("@FileSize", System.Data.OleDb.OleDbType.VarChar, 100).Value = o.Length
Catch ex As Exception
End Try
End Sub
End Class

Jul 08, 2008 | Microsoft Computers & Internet

1 Answer

Vb project

One of three ways:
1 make the table using vb creating a Bload screen.
2 using the visual data manager.
3 import a windows access or excel data base table.

Try the data wizard, easiest to use and U can program the program to manipulate the data in the tables.

May 29, 2008 | Computers & Internet

1 Answer

Flash drive problem

may e data is corrupt. use some data recovery software for data retrival

May 15, 2008 | Kingston Technologies 512MB DataTraveler I...

2 Answers

Budgets in excel

Dear Madiha35,


I would recommend the use of the Table Function in Excel.


Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.


Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.


Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.


Step 1:  Enter your data into the worksheet.


Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table


Step 3:  Verify Table range is correct, Click OK


Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.


Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above


Step 6:  Enter new data in row


Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

Related Topics:

480 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides