Incrementing number field in access

dympna

HI I am trying to create a number field that will create a unique
incremented number each time a record is added to the database via a
form. but I want that number to be in sequence and start from my
specified number.
I have tried the help in access and used the autonumber and the append
query to assign a specific number for the autonumber to start from,
but the problem that i get is when I add more than one record, the
next auto number that I get is not in sequence to the previous one, it
should be plus one.
There is no data is this database currently...

Thanks in advance

Feb 12 '07 #1

Subscribe Post Reply

2433

Tom van Stiphout

On 12 Feb 2007 03:45:17 -0800, dy****@crosslandtankers.com wrote:

This is a FAQ. Search at groups.google.com, and you will get many
answers.

-Tom.

>HI I am trying to create a number field that will create a unique
incremented number each time a record is added to the database via a
form. but I want that number to be in sequence and start from my
specified number.
I have tried the help in access and used the autonumber and the append
query to assign a specific number for the autonumber to start from,
but the problem that i get is when I add more than one record, the
next auto number that I get is not in sequence to the previous one, it
should be plus one.
There is no data is this database currently...

Thanks in advance

Feb 12 '07 #2

by: Payson Books | last post by:

Where can I find some info on grabbing the recordID of the last record, incrementing it by one, and using the new number in a new record.

Microsoft Access / VBA

Auto Incrementing

by: JD via AccessMonster.com | last post by:

I am trying to create a field where the primary key field will produce JDP- 001; where the three letters come from the first name, middle intial and last name of my table. I want to auto increment...

Microsoft Access / VBA

Incrementing a maximum value of a field when adding a record

by: K. Davis | last post by:

I need to increment the maximum value of a field of a table by 1 when a form opens a blank record. (e.g. =max(!![trip_number}) so the logic and references are working at the form level. I've...

Microsoft Access / VBA

field incrementing in a PL/pgSQL trigger

by: Tim Vadnais | last post by:

Hi, My boss wants to add some logging functionality to some of our tables on update/delete/insert. I need to log who, when, table_name, field name, original value and new value for each record,...

PostgreSQL Database

Incrementing Number/Leading Zeros

by: brad.goldberg | last post by:

Hey All, I know this has been addressed in a few different conversations but none are exactly what I am trying to do, bear with me I am an access Newbie. Basically I have a form that assigns...

Microsoft Access / VBA

Incrementing number field manually

by: icezcube | last post by:

I am not a programmer and a newbie with MS Access. I hope you guys can help me with my problem. I'm creating an IT hardware inventory database for my company. We have a few branches and each...

Microsoft Access / VBA

Incrementing counter based on results

by: senger.kim | last post by:

Hello World, I'm relatively new to MS Access (2003) and am trying to implement something that I feel should be simple but cannot find a solution. Hoping that you can help me or point me where to...

Microsoft Access / VBA

incrementing number in a subform

by: asandiego | last post by:

Hey guys, this is my first post here but have been checking this site a lot for anything I need. I hope someone can lead me to what I should do or just an idea to what can be done. What I'm...

Microsoft Access / VBA

Incrementing Question Revisited

by: troy_lee | last post by:

A while ago I posted this for help. "I have a table that has a PK field with the following format: Dyymm123. So that, a typical number might look like this D0806270. The first character is...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Similar topics