increment the field in ms access

Question

1.00/5 (1 vote)

See more:

hello all

i have a table named as "tblDBUser"
that having fields

intDBUserId,strLogin,strName,strPassword,intDBRoleType

in which i want that intDBUserId should be incremented automatically when i enter the records,

i write a query which is as followa...........................

SQL

INSERT INTO tblDBUser (intDBUserId,strLogin,strName,strPassword,intDBRoleType)
values((select MAX(intDBUserId)+1 from tblDBUser
 ,strLogin,strName,strPassword,intDBRoleType));

the problem is it is shows the error

"number of query values is not same the destination fields" can u please help me out where i made a mistake

thanks and regards
subiya

Posted 14-Apr-11 23:42pm

ahsan.subiya

Add a Solution

Comments

Prerak Patel 15-Apr-11 5:44am

Get your answer here: http://www.codeproject.com/Questions/181987/how-to-generate-auto-number-in-msaccess.aspx

Don't repost your question. You can modify the question if you wish.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wild-Programmer · Answer 1 · 2011-04-14T23:44:00

Solution 1

Select datatype for that column to AutoNumber.

Posted 14-Apr-11 23:44pm

Wild-Programmer

Prerak Patel · Answer 2 · 2011-04-14T23:47:00

Solution 2

REPOST: how to generate auto number in msaccess[^]

First of all I would say, use AutoNumber datatype for your ID field.

For this question, you had closed it wrong.

INSERT INTO tblDBUser (intDBUserId,                                strLogin,strName,strPassword,intDBRoleType)
                values((select MAX(intDBUserId)+1 from tblDBUser), strLogin,strName,strPassword,intDBRoleType);

If you use AutoNumber, you have to use following only. intDBUserId will automatically be generated.

INSERT INTO tblDBUser (strLogin,strName,strPassword,intDBRoleType)
                values(strLogin,strName,strPassword,intDBRoleType);

Posted 14-Apr-11 23:47pm

Prerak Patel

Updated 15-Apr-11 0:24am

v2

Comments

ahsan.subiya 15-Apr-11 6:13am

code still not working sir,
i dont want to use the autonumber.

Prerak Patel 15-Apr-11 6:18am

Why not? What is the problem with that?

ahsan.subiya 15-Apr-11 6:21am

sir it display error
which is not define

Prerak Patel 15-Apr-11 6:24am

If you use AutoNumber, you have to use following only. intDBUserId will automatically be generated.

INSERT INTO tblDBUser (strLogin,strName,strPassword,intDBRoleType)
values(strLogin,strName,strPassword,intDBRoleType);

ahsan.subiya 15-Apr-11 6:28am

thats i know bt my senior is not allowing me to use that

can you give me another code for the same thing please