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

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.
 
O

OldPro

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top