please help - autonumber problem - Microsoft Access / VBA

Lee-Anne Waters via AccessMonster.com

Hi,
i'm really hoping someone can help here..

i have just upsized my app to sql server and most of my forms use the autonumber field in access and everything worked fine. now with sql server i can not get everything to work as it used to as sql does not generate the autonumber until after i leave a form and go back in.

this is causing me no end of grief with subforms and alike.

is there anyway of getting this value shown? or if not is there another way to generate a unique number?

please bear in mind that i am new to this...
thanks so much
Lee-Anne

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #1

Subscribe Post Reply

1154

MGFoster

Lee-Anne Waters via AccessMonster.com wrote:

Hi,
i'm really hoping someone can help here..

i have just upsized my app to sql server and most of my forms use the autonumber field in access and everything worked fine. now with sql server i can not get everything to work as it used to as sql does not generate the autonumber until after i leave a form and go back in.

this is causing me no end of grief with subforms and alike.

is there anyway of getting this value shown? or if not is there another way to generate a unique number?

please bear in mind that i am new to this...

Why do you have to see the Identity number? It is usually used as an
internal value that the user should not see.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #2

Lee-Anne Waters via AccessMonster.com

i'm using the autonumber as a unique number for searching. nothing more

thanks

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #3

Similar topics

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

Autonumber problem

by: Ralph Birden | last post by:

Hi all, Here's my situation: I have 2 tables, let's call them TableA and TableB. TableA has a primary key called AffNo, TableB's primary key (--> foreign key in TableA) is called ID, and is...

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

AutoNumber Regeneration

by: jimfortune | last post by:

Sometimes I use Autonumber fields for ID fields. Furthermore, sometimes I use those same fields in orderdetail type tables. So it's important in that case that once an autonumber key value is...

Microsoft Access / VBA

Cascading Combo Boxes on continuous forms in Access 2000 - SOMEONE PLEASE HELP

by: Edwinah63 | last post by:

Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the...

Microsoft Access / VBA

VB6 app may need to generate its own ACCESS AUTONUMBER VALUES???

by: Alan Mailer | last post by:

A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...

Microsoft Access / VBA

XP professional SP2/MS Access 2003 Problem with Autonumber

by: Hiyella2 | last post by:

Hello, I have a problem with a table in my MS Access 2003 table. The primary key of this table is an autonumber field set to a Long Integer, Yes - no duplicates. The autonumber made it to 10252....

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

Autonumber in a form creating duplicate values

by: OxfordConsult | last post by:

Hello, I have created a form that links with a table with the autonumber feature as its primary key. Whenever i create a new record in the form (using a command button ... i have disabled the...

Microsoft Access / VBA

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

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

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

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++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware