Search results

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.

Where do I add this line; Public strProc As String? “In my example, that was in the declarations section of modFunctions”. Don’t you mean modLockedOut? I do have the ‘Microsoft 14.0 Object Library’ in the References ticked, albeit it is in a different location (C:\Prgram Files(x86)\Common...

Good morning isladogs, I have debugged and fixed a couple of compilation errors that were detected and have attached an .xlsx file containing a screenshot of the ‘References’ and a screenshot of the screen I get when I open my startup page (frmLogin). (This was the only way I could attached...

Hi isladogs, Access Version: 2010 32bit Not too sure what you mean by Have attached screenshot here if easier.

Hi isladogs, I meant to say that this only happens when i 'lock' the database. The screenshot can viewed here; https://www.access-programmers.co.uk/forums/album.php?albumid=71 The link I downloaded the DB from is; https://www.access-programmers.co.uk/forums/showthread.php?t=295174

Hi isladogs, I came across this DB that you have created, (which is exactly what I was looking for, think it’s great) downloaded it (Version 3) and followed your instructions; imported the module into my database and added the Call LockedOut to my startup form. When I open my database I get...