Recent content by lguelcher

I can follow that and it does make sense. The reason for the abbreviation is that it is used across a number of platforms and reports, so they want to keep it. But, I can certainly separate it into two parts. Thanks.

Thanks MarkK- But I don't follow what you're suggesting. I'm relatively new to writing macros and borrowed the code I have from a co-worker (and changed the references) who had it working with a different table (SBT instead of CLT). To use the code you suggest, where would I enter the code...

I am trying to add a button to a form that will automatically create a new entry with sequential numbering. Currently the numbering function is on the table "Client TP Tracker" in the field TPID. Once the button is clicked, a new form should be created and the new TPID number should be the next...

I'm new to Access World. I've been using Access for years but am just getting into advanced functions like Macros and VBAs. Thus my presence here!