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:

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


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

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

3 Answers

Payroll system in DBMS. I don't know what data is to be taken.


Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space. 
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.

Dec 25, 2008 | Computers & Internet

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 vb.net 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)
Try
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
Source=Test.mdb")
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
Con.Open()
Cmd.ExecuteNonQuery()
Con.Close()
Catch ex As Exception
Console.Write(ex.ToString)
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:

479 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 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...