Recent content by Mick3911

Afternoon isladogs, Thanks for your response. It is not the Power Apps that I am having a problem with but the Access form not displaying the signatures. But saying that we do have some Windows 10 tablets which I could use your utility as well (As these Windows tablets are no longer supported...

I am nearing completion of a DB that records employees training that is linked to SQL tables (just a couple of more stages to go). Currently an employee signs a training document stating that they have understood the training received and the trainer signs stating that they are satisfied that...

Yes, but you can only close the form by a command button which checks if relevant fields are completed.

I have got this to work how I want by setting the visible properties for the ‘DateCompleted’ and ‘TrainedBy’ textboxes on the main form to No and then used this code in ‘StartTime’ After Update property on the subform Private Sub StartTime_AfterUpdate() If Not IsNull([StartTime]) Then...

When I have completed the StartTime textbox I get a Run-time error '438', Object doesn't support this property or method. Is this because the subform is a continuous form?

But training won't be completed until the trainer is satisfied that the trainee have grasped the training which could take just one training session or more.

My code should have read If IsNull(Me.StartTime) Then Me.([frmUpdateTraining]![DateCompleted]).Visible = False Me.([frmUpdateTraining]![TrainedBy]).Visible = False Else Me.([frmUpdateTraining]![DateCompleted]).Visible = True Me.([frmUpdateTraining]![TrainedBy]).Visible = True End If

The training times relate to one training item/course. So an employee could receive just one training session say on the 1st or could receive multiple training sessions say on the 3rd, 10th, 11th and 21st.

I have a main form ‘frmUpdateTraining’ and a sub form ‘subfrmTrainingTimes’ which is a continuous form. On the main form there are (amongst others) 2 fields ‘DateCompleted’ and ‘TrainedBy’ On the sub form there a 3 text fields ‘TrainingDate’, ‘StartTime’ and ‘EndTime’. When a user enters a...

Thank you arnelgp and theDBguy, bot work a treat, much appreciated.

I am getting myself confused having spent too much time on an IIF statement I have a query where I want to create a column named TrainingStatus and have it filled with either 'Not Trained' or 'In Progress' or 'Trained'. I have used the following but get an error message saying that I have the...

Hi isladogs, Thanks for your reply. Is the code to be entered in the 'On load' for both forms?

I have a DB where various users create records. Before they can do that they need to log into the DB. What I would like to happen is that the person’s name who is actually logged onto the DB to be displayed on a form in a field named ‘SubmittedBy’. I have seen how to display a user who is...

I would be interested in the 'Send Message' options.

Hi isladogs, Works fine now after adding that line of VBA. Many thanks for your time and patience.