SQl Varbinary(max)/MA Access OLE Object (1 Viewer)

Mick3911

Registered User.
Local time
Today, 04:55
Joined
Jul 31, 2018
Messages
40
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)
 

Mick3911

Registered User.
Local time
Today, 04:55
Joined
Jul 31, 2018
Messages
40
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 by Microsoft, we are in the process of replacing them with Android).
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 11:55
Joined
May 7, 2009
Messages
14,113
i also have My own version.
 

Attachments

  • InkPictureControl.accdb
    608 KB · Views: 23

Users who are viewing this thread

Top Bottom