avoiding multiple users modifying the same record via a form

Hi
I just joined this forum and hope that its going to be usefull to help me develope my skills in Access. I can do a lot with objects such as queries, forms and reports, but don't really know so much about VBA....

Well here is my first problem:

I am building a database that will be used by several people at the same time (less than 10). They will use it to record outbound calls that they are making, basically they view the information in a record, make the call and record to result of the call in the database.

How do I ensure that 2 or more people do not try to call the same person at the same time? The form only provides an error message about the conflict once the user closes the form - or moves to the next record - in which case the call attempt would have already been made.

One solution could be to assign users certain records, but this can not be a permantant assignment as the people need to be called 3 times (or until they are contacted) and the database users will change from day to day.

How would I go about doing this, or how else could I solve this problem?

Thanks for your time
Helena

OPtion

When a Caller begins the process of calling a person tag that record as being in process (check it in). then not let anyone else touch a record that is inprocess. I would also include the time the record was put into process. If the current time is more then 3 hours from the time the record was put into process, the odds are that the system didn't release it or the person doing the calling didn't check it out when do. And you can program in lots of rules and data capture to monitor all this and so on

To do this well you will need to become farmilar with VBA.

S-

This sounds interesting, do you have any advice on ways to become more familliar with VBA? websites / help topics I could refer to specifically to do with this possible solution?

There are lots of books out there, Most are good for beginners. I would looke for a good book on VB (as the syntax is almost the same)

This forum and other a good for asking questions and a lot of people will even take you DB and get you going in the right direction

The following thread has a sample database of mine that you can download to look at ADO and DAO being used in VBA

http://forums.aspfree.com/showthrea...=52690#poststop


S-