Access 2000

[Robert Painter]

Hi all
Am struggling to create a database for a friend. The db is for a recruitment agency. So far have managed to do the employee record bit and query for driver licence expiry between 2 dates. What I am struggling on now is how to do a search on a work experience check sheet for from 1 to say five criteria. Say some one is looking to recruit a person who has experience on bookkeeping, end of year returns, invoicing, payroll, sage but other items on sheet may be bugets, general banking, purchase ledger, sales ledger etc. Thought of search with custom form but really out of my comfort zone here. Any help or ideas very much appreciated.

[Access Guy]

Hi Robert

Your work experience should be in a table related to the persons record. This allows you to add as many work experience records as needed.

If you want the result on a form, think about a continuous form with criteria options in the header. These could be drop-down lists they can select from or text boxes they enter criteria or checkboxes etc. In the After Update event requery the form.

In the form query add criteria that checks the controls for criteria options in the header. If a option is left blank then it fails and is ignored. I would make it so some criteria has to be entered or it will initially open showing everyone.

The form would show whatever you want, but probably just that persons details. You could have a button to the side that if clicked shows all details for the selected person.

Hope that helps.

[Robert Painter]

Hi Guy, Thanks for reply so soon. I have been working on this and have had input from elsewhere but am struggling. The only things i require from this db is to be able to inform drivers their licence is due for renewal and search for person to fulfill requirement to fill vacancy with relevant experience. As can be seen i can manage to do the driver licence bit but am completely in the dark for the other. Have filled in tables with all relevant data and tried to do relationships but when i create form with subform am unable to a. see what experience is apart from in number form and b. input experience from form. It was suggested to create a combo-box but struggling.
Any help will be very much received.
uploaded file is rdh.mdb

[Access Guy]

Hi Robert

Upload the MDB in your next comment so I can have a look.

Jeff

[Robert Painter]

Ok Jeff I thought i had sent it last msg. assume i just attach file and then send so here goes again

Robert

[Access Guy]

No file so I just tried a test file to check if the upload is working.

[Access Guy]

Robert, can you see my est file and if so can you see your own file?

Did you use the Upload Files link below the Reply box?

[Robert Painter]

Hi Guy,
No, do not see any uploaded files at all either yours nor mine
and yes did use upload files link, browsed to mdb and pressed add reply, did notice it took time to go thru so assumed it had gone, will enclose with this again

/robert

[Access Guy]

This is interesting as I can still see my file at the bottom of my reply above started 'No file...'. Just below there is a small page like icon with a link called 'testfile.txt'.

I will put a ticket into the techs to get them to have a look.

[Robert Painter]

Hi Guy, I too now have testfile.text but still no sign of my mdb
robert

[Robert Painter]

Hi Guy, Have sent file again and now see it on my last reply

Robert

[Access Guy]

Hi Robert

I have sent back your database with a couple of changes.

Always set relationships fully in your databases. A relationship that does not enforce integrity is of no use. Always set these properties or you will have orphan record which you did have. Orphan records are records left lying around in a related table when the parent record is deleted.

So I have set the relationships for you.

Have also changed your sub form for experiences. you were on the right track, just need a little more. Have a look at the record source for the subform and that for the combo and I think you will get the idea.

Hope this helps.

[Robert Painter]

Guy, Thank alot that has helped a great deal, Have now managed to incorporate it into the db i have constructed alongside the one i sent.
again thanks alot
Robert