Using a form to work Admin Accounts with multiple users

[Tyzerx]

Hi All,

I am sure there will be a relevant guide somewhere - hopefully you guys can help.

I work in a team with about 20 of us who would work from a list of accounts. We need to answer 4 questions on what we would normally use an excel sheet however so many issues with sharing and splitting etc.



Ideally in Column A - i would have a list of 2000 accounts. I would like to set up an Access so that a form pops up with an account number say A1-A2000 and gives ability to answer 4 questions and for example account in A1, it would put the answers in A2, A3, A4 and A5. while another user would be doing the same for the next line...

Is this possible to set up in access so work is not duplicated etc?

Many thanks for your help,

[andy49]

If the database was split then I can't see an issue.


Sent from my iPhone using Tapatalk

[Bulzie]

Bringing up an account and 4 question/answer fields is fairly simple. Are you asking if there is a way to prevent 2 people from selecting the same account to work on?

[Micron]

Probably simple enough for those who know how
I detect a overt Excel mentality being applied to a database. Maybe not, just sayin'...
@Tyerx - you have to pretty much forget what you know about workbooks. Their design just doesn't apply here if you want to succeed without a lot of head banging.