Displaying OLE Object

[mick3911]

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)

[Minty]

Crossposted here https://www.access-programmers.co.uk...object.319194/ with some suggestions

@Mick have a read here Cross Posting Etiquette: https://www.excelguru.ca/content.php?184

[mick3911]

Hi Minty,

Yes I do realise it is a crosspost but grateful as I am for the replies and help given out by the members it didn't really solve my issue so was hoping that members on here might be able to help.

Point taken though and in future will post a link to original post after some thought of the people trying to help me out.

[Micron]

It would seem you're not the only one who's had this issue. Here's one that might help.
https://stackoverflow.com/questions/...tore-ole-image

[Gicu]

Have you tried to download the signature file locally using Stream or AppendChunk and (with a fixed name such as Signature.jpg) and display that?

Cheers,

[Minty]

It would seem you're not the only one who's had this issue. Here's one that might help.
https://stackoverflow.com/questions/...tore-ole-image

I remember trying to do this and having a nightmare trying to display the signature after capture.
I know I eventually made it work, but unfortunately I don't seem to have the database it was in to see what the solution was. Not much help - but it did work eventually.

@mick - I'll keep looking through as it's something I may have a requirement for in a current project.

I'm wondering if Gicu's solution is what I ended up doing. Old age and forgetfulness is a wonderful thing...

[mick3911]

Hi Gicu,

Unfortunately, I cannot save the signatures elsewhere

[mick3911]

@mick - I'll keep looking through as it's something I may have a requirement for in a current project.

That would be appreciated.

Old age and forgetfulness is a wonderful thing...

I know where you are coming from

[Gicu]

It is only temporary, you save it in the same location as the front-end (which you know it is a folder where the user has full permissions) and you delete it in the unload event of the main switchboard form (or whatever form needs to display the signature).

Cheers,