[AccessD] Automatic Tracking Number

Liz Doering ldoering at symphonyinfo.com
Wed Jul 27 10:20:22 CDT 2005


Mike,

I've worked around this by saving the record to actually generate the
ID, then querying on some other known parameters to retrieve it.  Then
you will get back the ID you are looking for.

If there is a better method, I would like to know!

Liz



 

-----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 10:16 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








More information about the AccessD mailing list