Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking a Form 1
- Thread starter Maquis
- Start date
-
1
- #2
LonnieJohnson
Programmer
Just a thought. I haven't actually tried it.
1. Create a table with a Yes/No field.
2. Place an invisible field on the form with the Yes/No field as it's ControlSource.
3. In the form's On Load event check the value of the field.
4. If it is No then proceed as normal and set the value to Yes.
5. If Yes, then MSGBOX and CLOSE.
6. When you close it set the value back to No.
Just a thought...
B-) ljprodev@yahoo.com
ProDev, MS Access Applications
1. Create a table with a Yes/No field.
2. Place an invisible field on the form with the Yes/No field as it's ControlSource.
3. In the form's On Load event check the value of the field.
4. If it is No then proceed as normal and set the value to Yes.
5. If Yes, then MSGBOX and CLOSE.
6. When you close it set the value back to No.
Just a thought...
B-) ljprodev@yahoo.com
ProDev, MS Access Applications
- Thread starter
- #3
Thanks, Lonnie.
I think I'll go with that idea. I was already toying with the idea of creating a "lock" table, but instead I had gone off on a tangent of putting a user name in the table and it was just getting too messy.
I like having a simple yes/no boolean though. Short and to the point.
I think I'll go with that idea. I was already toying with the idea of creating a "lock" table, but instead I had gone off on a tangent of putting a user name in the table and it was just getting too messy.
I like having a simple yes/no boolean though. Short and to the point.
LonnieJohnson
Programmer
An added thought. You may want to do the checking and setting of the Yes/No at the point the user clicks the button to open the form. This way you don't get into a mess when closing and resetting the value.
For example, if you open the form the flag is Yes.
Next person opens it and the form automatically closes, but this closing also sets the flag to No, now another attempt at opening the form will get a user in.
Just another thougth.
B-) ljprodev@yahoo.com
ProDev, MS Access Applications
For example, if you open the form the flag is Yes.
Next person opens it and the form automatically closes, but this closing also sets the flag to No, now another attempt at opening the form will get a user in.
Just another thougth.
B-) ljprodev@yahoo.com
ProDev, MS Access Applications
- Thread starter
- #5
Yep, that's just what I was thinking. (GMTA)
I plan on checking the flag on the click event of the button calling the form and actually flipping the flag in the open/close events of the form.
But, knowing my users, 2 of them will try to open the stupid thing at the exact same second. X-)
I plan on checking the flag on the click event of the button calling the form and actually flipping the flag in the open/close events of the form.
But, knowing my users, 2 of them will try to open the stupid thing at the exact same second. X-)
LonnieJohnson
Programmer
Good luck. ljprodev@yahoo.com
ProDev, MS Access Applications
ProDev, MS Access Applications
- Status
