[AccessD] Automatic Tracking Number

Nicholson, Karen cyx5 at cdc.gov
Wed Jul 27 10:28:44 CDT 2005


I am doing the exact same thing right now.  What I have done is to put a
field on the form (and in its datasource) with a time stamp.  As it is
being written to the new table, I am taking that time stamp right along
with it.  Then I am returning that value to my form based on time =
time.  Does that make sense?  Once I get it coded, I will post it. 

-----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 11:24 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Automatic Tracking Number

Yeah that wouldn't work for me, I really don't have any other parameter
that I could query on to get the ID.  There could be upwards of 10
people entering data at the same time and on the same person.

I hope someone has a way to do this.

Thanks, 


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

-----Original Message-----
From: Liz Doering [mailto:ldoering at symphonyinfo.com]
Sent: Wednesday, July 27, 2005 9:20 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Automatic Tracking Number

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





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