Help with AutoNumber Data Type - Microsoft Access / VBA

Kissi

I would like the Auto Number field to have 7 digits and the first character
"E" eg ; E0000001, E0000002...,E00000120. Can someone help please?

Sep 6 '08 #1

Subscribe Post Reply

1763

Allen Browne

"Kissi" <ki*******@aol.comwrote in message
news:E_****************@fe18.usenetserver.com...

>I would like the Auto Number field to have 7 digits and the first character
"E" eg ; E0000001, E0000002...,E00000120. Can someone help please?

An Auto Number is a number, so you can't have an E in it.

Could you just print an E on your forms/reports, as a table, or as a
concatenated field:
="E" & [YourAutoNumberFieldNameHere]

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Sep 6 '08 #2

Rick Brandt

Kissi wrote:

I would like the Auto Number field to have 7 digits and the first
character "E" eg ; E0000001, E0000002...,E00000120. Can someone help
please?

You can *display* all such values with a format property of...

"\E0000000"

It is not possible with an AutoNumber to (nor necessary) that the values be
saved with that format.

Of course AutoNumbers will naturally develop gaps in most cases so if you
don't want that then you have to use a numering system other than
AutoNumber. Even in those cases I would still not save the data as you
indicate, but only display it that way on forms and reports.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Sep 6 '08 #3

Similar topics

Help with corrupt table

by: Dan | last post by:

Hi, just ran into my first instance of a backend Access97 database not compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on compact. I've narrowed it down to the largest...

Microsoft Access / VBA

Table w/ Autonumber AND Cascade update

by: Lee C. | last post by:

I'm finding this to be extremely difficult to set up. I understand that Access won't manage the primary key and the cascade updates for a table. Fine. I tried changing the PK type to number and...

Microsoft Access / VBA

Restart Autonumber

by: Traci | last post by:

If I have a table with an autonumber primary key and 100 records and I delete the last 50 records, the next record added would have a primary key of 101. Is there any way to have the primary key...

Microsoft Access / VBA

Will "Random AutoNumber" reuse deleted values?

by: yf | last post by:

A KB article "http://support.microsoft.com/default.aspx?scid=kb;en-us;209599" tells that the maximum number of records that a table may hold if the PRIMARY key data type is set to AUTONUMBER is...

Microsoft Access / VBA

Simple Basic Access Form Solution Please HELP!

by: alwayshouston | last post by:

Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...

Microsoft Access / VBA

Need help displaying text data for foriegn Key in form

by: Susan Bricker | last post by:

Greetings. I am having trouble populating text data that represents data in my table. Here's the setup: There is a People Table (name, address, phone, ...) peopleID = autonumber key There...

Microsoft Access / VBA

Help with school assessment database design please

by: sylviams | last post by:

I need a database to record students names etc and also to record their levels at six times during the year for a range of subjects. Obviously there can only be one entry per student subject per...

Microsoft Access / VBA

Duplicate numbers in "Autonumber" field -- help!

by: Tom_F | last post by:

To comp.databases.ms-access -- I just discovered, to my more than mild dismay, that some tables in my Microsoft Access 2003 database have duplicate numbers in the "AutoNumber" field. (Field...

Microsoft Access / VBA

Very Rusty Former Beginner/Intermediate Access Guy Needs a Little Help

by: Jack B | last post by:

I'm using Access 2002 to create a database for a small opera company that my wife is involved in, and I'm more than a bit rusty because I haven't created a new Access database since about 1999. ...

Microsoft Access / VBA

AutoNumber

by: raaman rai | last post by:

Guys, recently i have transferred by Access database to sql server 2000 n in a process of upgrading the application too. i m using VB6. well i had tables whose id was an "AutoNumber" in ms access....

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++