472,990 Members | 3,225 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,990 software developers and data experts.

Possible to link digital photo to OLE type field in bound frame in a form?

I have a form showing the records of different people.

I would like a photo to be displayed in the form, with each person's

My digital photo > *.jpg type file and I change each photo to *.bmp
format using SnagIt.

I created an OLE type field in the table to store either the embedded
photo or a link to the photo (I'll decide which method to use,
depending on how much each type, embedding or linking, increases the
*.mdb file size).

I created a "bound object frame" in the form, setting the Size mode
property to "zoom" to be able to resize easily.

I can either "embed" or "link" to the *.bmp file for each person's

This is the problem: what the user sees in the bound object frame is
mostly white space, with large text indicating the photo file's name
and a tiny, unrecognizable thumbnail sketch of the actual person's

I need the frame filled with the person's photo. I don't need the
name of the photo file to be shown.

Anyone know what to do?

Thanks in advance for any ideas.
Nov 13 '05 #1
1 2122
"Bill Strass" wrote
I would like a photo to be displayed in
the form, with each person's

The trouble about starting with a preconceived notion of _how_ to accomplish
something in Access is that there may be better ways to accomplish the same

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: CHIN | last post by:
Hi all.. here s my problem ( maybe some of you saw me on other groups, but i cant find the solution !! ) I have to upload a file to an external site, so, i made a .vbs file , that logins to...
by: Graham Drabble | last post by:
Hi, I have a table with a field "signiture" that is set with a data type of "OLE Object". If I view the table (in datasheet view) and right click on the relevent cell I can "insert object" which...
by: dvorett | last post by:
I know this topic has been discussed a lot but after going through the old posts, I'm still having trouble with the code. I have a photo name field which refers to the location of the photo on the...
by: Andy | last post by:
Hi, I have a complicated question that I'm hoping someone can help me out with. I have a webpage that contains a plug-in. This plug-in can communicate/pass data with the webpage that contains it...
by: Jozef | last post by:
Hello, I have some blob code that I use to polulate an OLE field with various files. Some of the files are images. The information in the field says "Long Binary Data" regardless of what I am...
by: gdgass | last post by:
Hi, I'm in the process of developing an app to scan and archive photos based upon the EXIF/Photo Keyword property. One of the requirements is that the Photo's keywords be editable via Digital...
by: MZ | last post by:
Hello! I would like to create similar script which let me (before submitting form) confirm the form. I would like to prevent from autosubmitting form by various users. I would like to create...
by: Tarik Monem | last post by:
I have been working on an all AJAX/DOM web site which is set to go live today and I thought I'd share my discoveries with all of you whom have helped me when I have encountered different issues along...
by: fnwtech | last post by:
I have been reading the forums, but I really need a step by step. I took a one day vb class about 3 years ago, so I know just enough to be confused! I have a database of students that I have to...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.