Solved Image control for printing photos from an sql table (1 Viewer)

Bæla

New member
Local time
Today, 11:02
Joined
Oct 5, 2019
Messages
9
Hi, strangely enough there is no control in Access for printing photos stored in an sql table.
I have tried Dbpix and Bukrek's, where Bukreks has worked fine until now.
I suddenly get problems when trying to print more than 5 photos in one report.

What is the solution for this problem?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:02
Joined
May 7, 2009
Messages
19,169
maybe download a local copy of the image to a folder
and set the picture property of the image control to
the local image file.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:02
Joined
Oct 29, 2018
Messages
21,358
Hi. Just curious, what is the data type of your photo stored in SQL Server?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 14:02
Joined
Feb 19, 2002
Messages
42,971
Can't you bind the field to an image control?
 

Bæla

New member
Local time
Today, 11:02
Joined
Oct 5, 2019
Messages
9
I have got the answer. I can not bind the field to an image control. I use the Bukrek control, and it works fine. This problem is a memory problem that Bukrek can not solve. The options are
1. print one photo at the time
2. export the report to pdf.

But it is a shame that no such control exist ifor Access report.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:02
Joined
Oct 29, 2018
Messages
21,358
But it is a shame that no such control exist ifor Access report.
I could be wrong, but I think that would depend on what data type the image column is in SQL Server. Can you tell us what that is? (Sorry if you already told us and I missed it.)
 

Bæla

New member
Local time
Today, 11:02
Joined
Oct 5, 2019
Messages
9
The photos were taken with a Canon SX 740 camera. More resolution than mobil phone cause the problem.
I could be wrong, but I think that would depend on what data type the image column is in SQL Server. Can you tell us what that is? (Sorry if you already told us and I missed it.)
Ole/db
 

Bæla

New member
Local time
Today, 11:02
Joined
Oct 5, 2019
Messages
9
The datatype in SQL Server 2019 is image, displays OLE-object from Access.
 

Users who are viewing this thread

Top Bottom