Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2009-02-16 : 21:52:02
|
| I have a data entry form that is called from a switchboard. One of the selections on the switchboard is 'Enter in Work Ticket'. When clicked I would like to have a box pop up to ask "What is your location". The user would then type in a location such as Dallas. I would then like for the database to search a UserLocation table to verify that the user is authorized to enter tickets for the location entered (we are told who is authorized to enter data for out locations and this info is in a table UserLocation). Could someone help me understand how this might work and possibly provide the simplest solution? I am for something short and sweet. Thanks for any help. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-17 : 08:30:46
|
| On the Enter Work Ticket form, I wouldn't use a popup, but use a dropdown list (I think it's a combo box in access). Two problems with a popup box, one they're annoying after a while and two, you can't validate free form text. It would be cleaner, less error prone and less keystrokes to use a dropdown becuase it's very simple for someone to type in "dalas" instead of "dallas" and then you get support calls telling you it doesn't work. You could then take this value after the on select event for the combo box and pass it to a query which will check permissions. If they have permissions for that area, you enable the rest of the form, if not you pop up a message or populate a label on the form that says "you don't have permissions to add tickets for this location".Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
user name