UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Autotext Primary Key, Access 2010    
 
   
RexAbandon
post Dec 26 2016, 10:40 AM
Post#1



Posts: 56
Joined: 18-May 05
From: Chatham, Ontario


I wanted a primary key that would restart a counter for each year. I also wanted it to have some text. The format I wanted is similar to:

Q16-001RMA or 16-001R or MR2016-001

All the work is done in the table DataMacro in the Before Change Event. There are a couple of examples in the attachment.

Let me know what you think.

Enjoy.

Rex

Attached File  AutoText_v00.03.zip ( 346.52K )Number of downloads: 32
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th October 2018 - 11:56 AM