Recent content by JPRENG

How do I view this database so I can edit for example the departments, so they suit my needs better?

I am creating a Employee Holiday Database, I want to be able to select an Employee, then select the data range they are on holiday for (could be one day could be several) and I want the databse to warn the user when the employee has used all their alloted days. Can aybody help or point me to a...

What I am trying to do is, for example, I have 2 combo boxes, you can select a value in the first one and search and your results match the criteria, or you can select a value in the first AND second one and the records dispalyed will match the first AND second combo box criteria. Any Ideas?

Query by Form it stands for.

I have a text box and a QBF running the code is [Forms]![frmQualificationSearch]![whatQualification] Or [Forms]![frmQualificationSearch]![whatQualification] is null I know want to add another text box and have it so, if their is only a value in 1 text box it the results match that, as above...

What should i use? If the user is to enter the value theirselves they may get it wrong I want to ensure this doesnt happen

I want to send out my database to a client so they can add records into it via the forms i've created, but I don't want them to be able to change the coding etc. But I also want to be able to update my database and send it back out to them but obviously the records they've entered need to...

Is there any way to use a lookup field as the control in a QBF as opposed to a text box?

I have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and...

Will this allow for multiple Qualification selections?

How would I create the lookup on the ID_Qualifications field?

I have set my database up as follows, and would just like some adive before I proceed with it. tblEmployee Employee ID Surname Forename Grade tblQualification ID Qualification Now I want a form that shows the Employee Details, but I then want to be able to select (multpiple) qualifications...

Thank you.

Do you have any tutorials on how to do this?

I have a list box which contains all the qualifications which are stored in the table Qualifications. (Gas Safe, Asbestos etc) On my form I want the user to select from the list box all the qualifications an employee has, then add them to that employee's record and then also dispaly the...