Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 7th, 2003, 09:58 AM
Authorized User
 
Join Date: Dec 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Link to JPG images to use in forms and reports

I am starting an inventory business and have written an Access(XP)DB to hold all the data as well as JPGs of the more valuable pieces. It all works well, but the JPGs in my table are HD HOGs (500K for each 30K JPG). I now see that I should keep the JPGs in a directory and link to them, but I am having a problem doing that. I am using an Unbound Object Frame and can link to a JPG file with no problem, but I can't programatically change the link to the correct JPG for the record. I am changing the value in Source Doc, but that doesn't do anything.

Nashville_Bill
__________________
Nashville_Bill
 
Old December 7th, 2003, 10:53 PM
Authorized User
 
Join Date: Dec 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Actually the size of the database is 74,000K with the JPGs and 600K without them.

Nashville_Bill
 
Old December 8th, 2003, 05:35 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Take a look at the Northwind database sample "Employee" form. There is a good example of calling and storing files outside the database.
 
Old December 8th, 2003, 06:54 PM
Authorized User
 
Join Date: Dec 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks jemacc, that looks perfect.

Nashville_Bill
 
Old December 9th, 2003, 02:08 PM
Authorized User
 
Join Date: Dec 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I don't understand all the code, but through copying and pasting of the controls and code I made it work and my database size is down to 260K. The database is much easier to use now also. Thanks again jemacc.

Nashville_Bill
 
Old December 10th, 2003, 09:57 AM
Authorized User
 
Join Date: Dec 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Now that I have the form working correctly, I have a new problem. With every record, I import a new JPG, which works fine, BUT I get a message box that says: importing (followed by the path and file name)with a progress bar. This doesn't appear on the similar employees form of the Northwind database. Worse yet, if you advance to the next record quickly enough the message box will get stuck on the screen. It won't even go away when you close Access(XP) and I can't get back into the Access program until I reboot WinXP. I would love to get rid of this and even put a DoEvents in my Next Record command button, but no help.

Nashville_Bill
 
Old December 10th, 2003, 11:19 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

what version of access are you using?

Try this.

open the form in design via. close any form properties you may see including the design wizard. save the form again and see if dialog box for import appears again?







Similar Threads
Thread Thread Starter Forum Replies Last Post
How to provide download link for images snowbydave1 PHP How-To 2 March 27th, 2007 12:11 AM
How to provide download link for images snowbydave1 Beginning PHP 4 March 24th, 2007 04:38 AM
How to provide download link for images snowbydave1 Pro PHP 0 March 19th, 2007 02:06 AM
How to provide download link for images snowbydave1 PHP Databases 0 March 19th, 2007 02:04 AM
how to link slideshow images on js gilgalbiblewheel Javascript How-To 1 January 25th, 2007 07:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.