Search results

  1. P

    Select query is to complex

    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...
  2. P

    Dmin inconsistent results

    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...
  3. P

    Extract query results into txtblock.

    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...
  4. P

    Vba Insert into tbl

    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...
  5. P

    Hi From Hampshire England

    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...
Back
Top Bottom