Hi
Like most IT shops, we've got tonnes of user passwords, hardware info, IP's, etc, floating around in dozens of different spreadsheets. It's gotten to be completely insane, and also completely unreliable. I've decided it's time to start up a database to manage all our user info. After talking with the other people in my department (a mainframe analyst and a VB programmer), they asked for something I'm not sure can be done...
We're going to associate all user info (password, PC config, etc) with a user, and then associate the user with a specific cubicle #. Our users move around more because our office is also a working showroom, so we want our main interface to be graphical (a list of cubicle #'s wouldn't make much sense). So it was suggested we could make an image (line drawing) of our office and cubicles, and be able to click on a cubicle in the picture to open the info for that station. However, the kicker is, that they'd like a label containing the name of the user currently at that station, and if the user name changes, they'd like the label to change automatically as well! Considering we have over 100 stations, having to manually change the image isn't really an option.
This isn't coming out right, so I'll example: Jane is in station A1, Bob in A2, Zak in A3. A table is set up listing that info, with "User" and "Station" as fields. I need to set up a form that contains labels that look up "User" based on "Station", and shows the value of "User" in the label. The form will have many "User" labels on a single page, and the label should look up the "User" for "Station" A1 on the first label, A2, on the second, and A3 on the third, etc. That way, if Bob is hit by a bus and replaced by Jim, the table data can be changed, and the label for A2 on the form will now show "Jim". Clicking on the label (via an onclick event?), for "Jim", will open another form with all of his associated information from another table.
What I'm stuck on right now is how to get the label to lookup the user based on the station name (setting a label for Station A1, and having it lookup Jane). Every time I try to get started, someone comes in with something to distract me (isn't that always the case?). Does anyone have any suggestions on how to put this together, get this part of things working, and then make the User label clickable to pull up a new form?
Like most IT shops, we've got tonnes of user passwords, hardware info, IP's, etc, floating around in dozens of different spreadsheets. It's gotten to be completely insane, and also completely unreliable. I've decided it's time to start up a database to manage all our user info. After talking with the other people in my department (a mainframe analyst and a VB programmer), they asked for something I'm not sure can be done...
We're going to associate all user info (password, PC config, etc) with a user, and then associate the user with a specific cubicle #. Our users move around more because our office is also a working showroom, so we want our main interface to be graphical (a list of cubicle #'s wouldn't make much sense). So it was suggested we could make an image (line drawing) of our office and cubicles, and be able to click on a cubicle in the picture to open the info for that station. However, the kicker is, that they'd like a label containing the name of the user currently at that station, and if the user name changes, they'd like the label to change automatically as well! Considering we have over 100 stations, having to manually change the image isn't really an option.
This isn't coming out right, so I'll example: Jane is in station A1, Bob in A2, Zak in A3. A table is set up listing that info, with "User" and "Station" as fields. I need to set up a form that contains labels that look up "User" based on "Station", and shows the value of "User" in the label. The form will have many "User" labels on a single page, and the label should look up the "User" for "Station" A1 on the first label, A2, on the second, and A3 on the third, etc. That way, if Bob is hit by a bus and replaced by Jim, the table data can be changed, and the label for A2 on the form will now show "Jim". Clicking on the label (via an onclick event?), for "Jim", will open another form with all of his associated information from another table.
What I'm stuck on right now is how to get the label to lookup the user based on the station name (setting a label for Station A1, and having it lookup Jane). Every time I try to get started, someone comes in with something to distract me (isn't that always the case?). Does anyone have any suggestions on how to put this together, get this part of things working, and then make the User label clickable to pull up a new form?
