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