Does a later version of Access automatically handle .jpg's??? This seems strange that customers should have to change images to a .bmp file format when .jpgs are the predominant image file stored and used (and have been for some time). Has MS fixed this in later versions of Access? Just curious.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of John Viescas Sent: Tuesday, January 03, 2006 8:10 AM To: [email protected] Subject: RE: [ms_access] Re: Question on Photo in Report Jeannie- First, the easy question. After Microsoft releases a product, they will often later release update packages to fix problems discovered in the initial version. Open Microsoft Access and cancel the opening dialog. Choose About Microsoft Access from the Help menu. If you have the latest updates for Access 2000, you should see "Microsoft Access 2000 (9.0.6926 SP-3)" - Service Pack 3 (SP-3) is the latest update for this product. If you don't have SP-3, go to: http://office.microsoft.com/en-us/officeupdate/default.aspx .. and click the Check for Updates link near the top center of the page. In your original post, you imply that you're trying to display a jpeg file. The Access OLE Object data type will correctly display a bitmap file in the Bound Object Frame control, but I think you have to install a converter to display jpeg or jpg files correctly. You might need to rerun the installation of Access 2000 and be sure you select all options - including all the converters. In Control Panel, open Add / Remove programs and find Microsoft Office 2000. Select it and click the Change button. In the Setup dialog, click the Add or Remove Features button. Setup will show you a tree structure for the features installed - click the Converters and Filters group and choose Run All From My Computer. Click Update Now to add the converters - but you'll probably need your original install disk or files. If that doesn't work, convert all your jpg files to bitmap using some third-party program such as Photo Shop or Paint Shop Pro, then load the bitmaps into your OLE Object field. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of crazy4mustang Sent: Tuesday, January 03, 2006 6:55 AM To: [email protected] Subject: [ms_access] Re: Question on Photo in Report I hope I can answer your questions! The person who ran the database for our small company left abruptly and this fell on me. I can use Access to get the information I need out but never had to set it up before. I've been using the help and microsoft online to get through this. What I need is to print out a profile of a person in a report form. I need the person's photo on the report with their personal data. I insert the photo in the table and pull the information into the report. Its Access 2000. Service packs??? I made a photo feild and Ole. Does that answer your question? Thanks for any help you can offer. Jeannie -- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Jeannie- > > What is the data type of the field you're using to store the photo? What > version of Access, and do you have the latest service packs installed? > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of crazy4mustang > Sent: Sunday, January 01, 2006 8:02 PM > To: [email protected] > Subject: [ms_access] Question on Photo in Report > > I'm trying to put a photo in a table so I can see it in my report. I > put it in but it doesn't show up in my report as a photo. I either see > the word jpeg or the file name. How can I "see" the photo? > Thanks! > Jeannie > > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links _____ YAHOO! GROUPS LINKS * Visit your group " ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
