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