[AccessD] Automatic Tracking Number

Charlotte Foust cfoust at infostatsystems.com
Wed Jul 27 14:57:09 CDT 2005


SELECT @@IDENTITY FROM MyTable

IDENTITY maps to autonumber in Access

Charlotte Foust


-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us] 
Sent: Wednesday, July 27, 2005 8:36 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Automatic Tracking Number


Charlotte,

How would I go about that? 


Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: Wednesday, July 27, 2005 9:30 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Automatic Tracking Number

Have you tried using an output parameter to return the identity value?

Charlotte Foust


-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Wednesday, July 27, 2005 8:07 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Automatic Tracking Number


I'm just using regular VB to save the record and store the ID number to
print the label, but SQL is not feeding me this number it just assigns
it automatically in the table and I don't know the number so that I can
requery for it.

I hope that makes sense. 


Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit

-----Original Message-----
From: Jim Lawrence [mailto:accessd at shaw.ca] 
Sent: Wednesday, July 27, 2005 9:00 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Automatic Tracking Number

Hi Mike:

If you are using a SP to save the data, capture the auto-generated id
number and return it, through the SP then you will have to manually
place the new record number on the form.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Wednesday, July 27, 2005 7:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Automatic Tracking Number

 
Hi Everyone, 

Quick question, I am currently converting all of my tables to SQL and
continuing to use Access as the front end.  Well I have run into one
snag that I can't seem to figure out.  When I enter a new record into
the main table the  tracking number that is automatically being assigned
to the record does not show on the form.  When I had the table on Access
it showed up immediately after I entered the first field of data.  I use
this tracking number to than print a label, but now I have no idea what
number is being assigned.  I look at the SQL table and the record is
there with a tracking number.

Does anyone know how to make the tracking number show on the form?

Thanks for any help that anyone can provide.


Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list