Susan Harkins
harkinsss at bellsouth.net
Wed Feb 22 08:00:24 CST 2006
You can have both. :) Give the insisting client a counter for display that doesn't really do anything. Useless, yes, except that it makes the client feel better. Susan H. That's my plan but the client is insisting on a counter type display as mentioned. Hi Joe For what it's worth I would add a totally new column make it an autonumber Call it something Like IncidentID And make it the PK for the table And use that resulting IncidentID for all things like searches, building strings etc Darren ------------------------------ T: 0424 696 433 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Wednesday, 22 February 2006 12:48 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Some vba help please Charlotte I am trying to make a new field. Their current key system 1. Will cause duplicate values in 2010 2. Does not allow proper numerical sort now. Current system is first and last digit of year + next sequence number 19-01 19-02 20-01 20-112 20-02 And so on I want to build 2000-001 2000-002 2000-003 Etc Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, February 21, 2006 5:39 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Some vba help please It looks to me like you're trying to use the same NewAccidentID for all the records. Surely that isn't what you wanted is it? Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, February 21, 2006 5:12 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Some vba help please Private Sub Accident_Date_AfterUpdate() Me.txtNewAccidentID = Right(txtAccidentDate, 4) & " - " & DMax(NewAccidentID, [20_tblAccidentmaster]) End Sub I am trying to build a new key for each record in a table. Right(txtAccidentDate, 4) gets the year. " & right(DMax(NewAccidentID, [20_tblAccidentmaster]),3)+1 gets the next sequential number. 1. The code is not firing. I am getting no error or value. 2. Does this code look correct to my purpose. Joe Hecht jmhecht at earthlink.net -- 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.12/265 - Release Date: 2/20/2006