charliemopps
Registered User.
- Local time
- Today, 02:10
- Joined
- Feb 24, 2009
- Messages
- 40
So I'm building a database that gives users tickets to work.
When they open a record, I want to stamp it with a "So and so is working this" and not let anyone else pull that record for 30min
If the user clicks complete, it puts a second time stamp that closes it.
I can do all this so far. I have a querry that figures out which ticket numbers to use. I use this on a main form and then have 2 subforms (1 for the tickets and 1 for the Status) I've taken away the record selectors so the user is just working on the next one in the list and can't move arround. My control buttons will properly stamp the records depending on if they finish it or not.
My Problem: When they open the DB, it starts them on a ticket right a way.
I would like my form to start blank. No record.
How can I do this?
I thought of hiding the subforms. And then have the "Give me a ticket" button make the forms visible and stamp the records with the "I'm working this" timestamp. The problem is, if anyone else opened the ticket in a similar time period, they will still be on the same ticket. I supposed I could requery. Anyone got a simpler meathod?
When they open a record, I want to stamp it with a "So and so is working this" and not let anyone else pull that record for 30min
If the user clicks complete, it puts a second time stamp that closes it.
I can do all this so far. I have a querry that figures out which ticket numbers to use. I use this on a main form and then have 2 subforms (1 for the tickets and 1 for the Status) I've taken away the record selectors so the user is just working on the next one in the list and can't move arround. My control buttons will properly stamp the records depending on if they finish it or not.
My Problem: When they open the DB, it starts them on a ticket right a way.
I would like my form to start blank. No record.
How can I do this?
I thought of hiding the subforms. And then have the "Give me a ticket" button make the forms visible and stamp the records with the "I'm working this" timestamp. The problem is, if anyone else opened the ticket in a similar time period, they will still be on the same ticket. I supposed I could requery. Anyone got a simpler meathod?
