Recent content by aclockworkgod

Hello, I've looked everywhere, but can't seem to find a solution. I have a logging database that immediately opens to a form that contains a field bound to a table. Form On Load Event includes: DoCmd.GoToRecord , , acNewRec I need the form to open to a new record to ensure no other records...

Thanks June! and thanks all! I will be reviewing the code I have implemented throughout the day and into tomorrow to see if it's what we'll need. I appreciate everyone's help on this and will look further into post 6 if I run into any trouble. Thanks again for the quick responses!

I think I may have found what I was looking for here: tek-tips.com/viewthread.cfm?qid=837296 Do we think it is a feasible way for a multi-user db to operate and have the range be reset daily?

Mark, It would be similar to the question posed in this thread: 'https://access-programmers.co.uk/forums/showthread.php?t=105462 I'm not sure if this can be accomplished using an auto-number. There's another more specific example thread that I'll need to find again.

Hello all! This is my first post and I want to preface this with noting that I am new to coding in VBA. With that said... I need some help. I am looking to create a sequential number generator/form field that: 1. Has a range (ex. 100-300) 2. Identifies if the number has already been used...