Well I finished my Incident Report DB and I thought it covered all that we had planned for. Ha!!! Now the gnomes have said that's pretty good but can we have;
There are 5 users covering 30 locations. What they want is the users to view and input only for their own location but also to have admin log in to view ALL for certain people. (all using runtime)
I'm not sure I have the right concept of it all and there seems to be little on the internet about Runtime
So my locations are stored in a query. I 'm thinking now I need a switchboard (I think i'll do my own) to be the default open form and now I need help.
So a combo box maybe of locations including admin (or similar) and some code to run the query according to the input (oh yes and the password for each user. Am I on the right track?
Funny how this Access thing sort of grows on you
The more I know about Access the more I know the more I don't know