Creating a registration form

[CP611]

Hello! I have very little experience with access but I am looking to create a registration database to register peoples arrival on an event, whereby anyone can use a form, search for someones name, it brings up a list of all the possible options of people with that name (from a list in a table of all people we are expecting) then a tick box to say arrived? Ideally it would then remove that person from being able to search for it again so no one is registered twice. Is this possible for a novice to make? Thank you!

[Bob Fitz]

..... Is this possible for a novice to make?.....

I suppose that depends on the aptitude of the novice. Shouldn't be too difficult with some help.
I would be willing to help you.
Will this be a "one off" event or might you need the database for future events as well?

[CP611]

Hi there, I will be the one making it, I've made one data transformation with it, using tables and a query. However I've not really used forms much. The people using the tool just need to be able to put a name or a person in, search in a list and press arrived. It will need to be used for the future but I can put in new sets of data when required if that makes sense!

[Bob Fitz]

Hi there, I will be the one making it, I've made one data transformation with it, using tables and a query. However I've not really used forms much. The people using the tool just need to be able to put a name or a person in, search in a list and press arrived. It will need to be used for the future but I can put in new sets of data when required if that makes sense!

Can you post a copy of what you have so far.

[CP611]

Hi there, I haven't started it as I'm not sure where to start....

[Welshgasman]

Hi there, I haven't started it as I'm not sure where to start....

Perhaps start here then? https://www.google.com/search?q=acce...hrome&ie=UTF-8

[Bob Fitz]

Here's something for you.

The db has 3 tables:
tblPersons: Details of persons
tblEvents: Details of events
tblAttend:Stores the PK of tblPersons and the PK of tblEvents (records who attended which event)

The db has 3 forms:
frmMain: Has three buttons:
Persons(Add/Edit): Eables you to open a form to enter/edit details of persons
Quit: To Close the app
Events/Attending:Enables you to enter edit details of Events but also has 2 list boxes showing who is in attendance and who is not. Persons can be moved between the lists by double clicking a name in the list.

Post back i you need more help or clarification