Search results

Arnelgp Thank you for your excellent solution and prompt reply. sorry i was a bit slow to understand :{ Best Regards Pete

Thanks for prompt reply The query works and the records are filtered with Qualification value 1 or 2. all fine. what i would like is if main form 1 filter 1 what i would like is if main form 2 filter 2 OR 1 . hope this makes sense?

Hello Folks I have a form that shows open tasks with date and qualification. There is a sub form showing available staff and their qualifications. Staff that are assigned to a task by adding to a many to many table. The sub form checks that staff are available on that date by checking the...

Minty Thank you for your prompt and helpful reply. i can understand were i went wrong. Its all working fine thank you. plog Thank you Yes it is a date JunTblStaffTraining is a junction table Its great that you guys help so much. i learn so much from this site. Regards Pete

Hi I have a staff form and a training details subform. The training subform is bound to a junction table that contain staffIID , trainingID, passdate, expDate. in the after update event of the subform ExpDate i have this code. Private Sub ExpDate_AfterUpdate() 'saves changes and updates...

Thanks for the help you have all given to me. I have put the pieces together and understand how and why it works. This is a truly great recourse and i appreciate that you each took the time to help with this. Best Regards Pete

MarkK Tried this Function TrainingCheck() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("qryStaffTraining") With rst Do While Not .EOF Debug.Print !tblTrCourseName, !tblJoinDatePassed, .MoveNext Loop .Close End With End Function This fails with the set...

MarkK, Thanks for this helpful reply, i will have a go at this and let you know how i get on Best Regards Nick

plog Thanks for the starter and prompt reply i will have a look. Regards Pete

Hi, I have a staff form with a linked subform that lists training course details as Course Date Passed First Aid 01/01/2015 Manual Handing 02/02/2016. ect. I would like to use the docmd send object to send Staff an email for their review of training I can send a query or report as a...

JANR thanks for that its working fine now. Great forum this is Pete

Minty Thanks for the prompt reply. You code works fine thank you. i can see the logic in building the statement this way. That is very useful advice as well. Best regards Pete

Hi This code works fine and inserts the 3 values into the table. DoCmd.RunSQL "INSERT INTO JobsStaffAvail ( tblJobsID, tblStaffAvailID, bookedBy )" _ & "VALUES(Forms!frmbookstafftojob.JobsID ,Forms!frmbookstafftojob.subfrmStaffAvail.Form.staffid ,'TestData')" However i need to replace...

Thanks Pbaldy Just looking at 3NF. I seem to making a lot of tables. lets see how it works out. Best Regards Pete

Hello Everybody, I have just made the jump from power excel to access and wished i had done it years ago. Access for me is a bit like learning to drive a car. I can now work the controls(a bit anyway) and the next stage is to look up and plan were i am going and use all the controls to get...