By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Locking a record

P: 19
Ok. Here's my setup:

I display a list of records of customers to be called in a continuous form. Our callers click on a button to open the record (in a form using the Openform macro) to see more details before making a call.

I need a way to "lock" the "openform" (or similar function) from opening the detail form of a record that is currently opened in the detail form to keep callers from calling someone on the list.

Even a method which will highlight the record row in the call list form when it is open so others can immediately see that the record has been opened (without refreshing/reloading the call list).

Another possible method would be to disable the button when it has already been clicked until the detail form has been closed. This is would have to be a vb type check for a flag of some sort it think.

Any thoughts would be appreciated.
Jul 25 '07 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
You have posted your question in the Articles section rather than the Forum section.

I have moved it across for you.

Linq ;0)>
Jul 25 '07 #2

P: 19
You have posted your question in the Articles section rather than the Forum section.

I have moved it across for you.

Linq ;0)>
Thanks a bunch!!!!...............
Jul 25 '07 #3

P: 19
Work Around:
if record had a null field [reclocked] then I set open the record in the edit form and onload use a sql update (no warnings) to set the field to 1. when any of the various "done' type buttons are pressed in the edit form, I setvalue in this field back to null.
Jul 26 '07 #4

nico5038
Expert 2.5K+
P: 3,072
I would use a DateTimefield: DateTimeLastCall that's filled with the Now() function when the detail form is closed with the [OK] button and not set when the [Cancel] button is used.
Thus you get a recording of the actual time the call has been made and is besides an optional test (Now()-/-DateTimeLastCall > 60 seconds) even the hourly productivity measurable :-)

Nic;o)
Jul 27 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.