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
cnn.Open
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
rst.Close
cnn.Close

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

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

    Scholar:

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

  • Expert
  • 70 Answers

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

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

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Reasons / Answers to why schools need a Database


Hi
A database is like a super advanced excel where you easy can store and retrieve data using SQL. You might need to get access to a hosted database so you do not need the have the fysical server and manage that including backing it up. A hosted solution would be cheaper.

Mar 26, 2011 | Computers & Internet

1 Answer

School management system


you can download it from


http://download.cnet.com/School-Management-System/3000-2065_4-10606088.html

Jan 30, 2010 | Microsoft Windows XP Professional

1 Answer

DAO in vb


Nice try. Find an upper-class student to give you one-on-one tutoring with your homework.

Apr 16, 2009 | Computers & Internet

1 Answer

How to add columns(Vertical) only in Msflexgrid from database table using VB.


you have to open your current project in VB then go to "add references" (its somewhere in the menu bar) then go find microsoft acess and add it as a reference. then go to object browser and you'll find all the functions you need to interface between your project in VB and MS Access.

good luck !!!

Dec 30, 2008 | Computers & Internet

1 Answer

1. A software company has the following information about its cl


Shouldn't you be doing your own school homework?

Nov 18, 2008 | Computers & Internet

2 Answers

C programing


Try working on Management Software - School Management/ Library Management - These are a few ones where you can test you knowledge to limits - Like creating your own database file,naintaining indices etc.

Oct 31, 2008 | Computers & Internet

1 Answer

To dispaly row without duplication


mini-05,

Try something like this:
SELECT DISTINCTROW Serial.SerialNumber, Serial.ID
FROM Serial
WHERE (((Serial.ItemID)=[CurrentItem]) AND ((Serial.Sold)=False))
ORDER BY Serial.SerialNumber;

Good luck!

Jul 27, 2008 | Microsoft Windows XP Professional

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

2 Answers

Cache memory


A cache is a temporary storage area where frequently accessed data can be stored for rapid access. Once the data is stored in the cache, future use can be made by accessing the cached copy rather than re-fetching or recomputing the original data, so that the average access time is shorter. Cache, therefore, helps expedite data access that the CPU would otherwise need to fetch from main memory.

A cache is a block of memory for temporary storage of data likely to be used again. The CPU and hard drive frequently use a cache, as do web browsers and web servers.

A cache is made up of a pool of entries. Each entry has a datum (a nugget of data) which is a copy of the datum in some backing store. Each entry also has a tag, which specifies the identity of the datum in the backing store of which the entry is a copy.

When the cache client (a CPU, web browser, operating system) wishes to access a datum presumably in the backing store, it first checks the cache. If an entry can be found with a tag matching that of the desired datum, the datum in the entry is used instead. This situation is known as a cache hit. So, for example, a web browser program might check its local cache on disk to see if it has a local copy of the contents of a web page at a particular URL. In this example, the URL is the tag, and the contents of the web page is the datum. The percentage of accesses that result in cache hits is known as the hit rate or hit ratio of the cache.

The advantage of cache memory is that the CPU does not have to use the motherboard’s system bus for data transfer. Whenever data must be passed through the system bus, the data transfer speed slows to the motherboard’s capability. The CPU can process data much faster by avoiding the bottleneck created by the system bus

Jul 17, 2008 | Microsoft Windows Server Standard 2003 for...

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

479 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...