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    
post Dec 26 2016, 10:40 AM

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.



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

Custom Search

RSSSearch   Top   Lo-Fi    18th January 2019 - 07:33 AM