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 the employee has understood the training given.
I have created a Power Apps app where instead of the training document being signed, individuals sign the app on a tablet which is stored as a varbinary(max) in the same SQL tables as the DB.
My problem is that when I create a from based on the table, the signatures are not being displayed (everything else pulls through fine).
When I open the relevant SQL table in Access the signature fields contain an OLE Object.
I have searched high & low trying to figure this out but with no joy so I am hoping that you guys & gals can help me.
Unfortunately, I cannot save the signatures elsewhere and then link the OLE Object (image) to the relevant path (oh how I wish).
The table is named tblTrainingHistory and has the following fields;
TrainingID – Autonumber
EmployeeNo – Number
TrainingCode – Text
DateCompleted – Date
TrainerSig – varbinary(max)
EmployeeSig – varbinary(max)
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 the employee has understood the training given.
I have created a Power Apps app where instead of the training document being signed, individuals sign the app on a tablet which is stored as a varbinary(max) in the same SQL tables as the DB.
My problem is that when I create a from based on the table, the signatures are not being displayed (everything else pulls through fine).
When I open the relevant SQL table in Access the signature fields contain an OLE Object.
I have searched high & low trying to figure this out but with no joy so I am hoping that you guys & gals can help me.
Unfortunately, I cannot save the signatures elsewhere and then link the OLE Object (image) to the relevant path (oh how I wish).
The table is named tblTrainingHistory and has the following fields;
TrainingID – Autonumber
EmployeeNo – Number
TrainingCode – Text
DateCompleted – Date
TrainerSig – varbinary(max)
EmployeeSig – varbinary(max)