Read only access based on drop down box....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I have a table Calls in our contacts database. The table contains the
following fields:

CallDateTime (txtbox)
CallType (combobox)
Initials (txtbox):

I have two departments that want to use the same Contacts database. However,
each department wants to enter Calls in the calls table and have read only
access to the other departments data in the table based on a drop down value
in one of the fields. Each department has their own CallTypes that they are
responsible for.

Is it possible to have them enter in the same subform but have write and
read access to the call types they are supposed to have?

Sorry, it was difficult to explain the problem, I hope it makes sense.
 
Hello. I have a table Calls in our contacts database. The table contains the
following fields:

CallDateTime (txtbox)
CallType (combobox)
Initials (txtbox):

I have two departments that want to use the same Contacts database. However,
each department wants to enter Calls in the calls table and have read only
access to the other departments data in the table based on a drop down value
in one of the fields. Each department has their own CallTypes that they are
responsible for.

Is it possible to have them enter in the same subform but have write and
read access to the call types they are supposed to have?

Sorry, it was difficult to explain the problem, I hope it makes sense.
Click to expand...

If 1) the two departments are sharing the same computer, then the
computer doesn't know who is running the program unless you have a
sign-on screen. You would also need an automatic time-out in case
they forget to log out.
or 2) If the departments each have their own computer, then you could
make the same form work differently on separate computers by checking
for an ID file on the harddrive that identifies the computer.
 
Back
Top