A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with photos on CD



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2006, 09:59 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Need help with photos on CD

Hi all,

This newbie needs some help please.

I need my db to be on cd for other cutomers. I have 4 cd's of photos that go
with it. My idea was to have the customer to start the db from a cd, then
browse through the records (1,400) and when they wanted to see a photo click
on a "show images" button. This would inturn open up my show_images form and
then would tell the customer to please insert the cd labeled "v5-N1" area,
and then the customer would insert this cd and presto, the photos would
appear. I am using DBPix. It works great just need to be portable with what I
have now..

any ideas?

Thanks much,

Jeff

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200602/1
  #2  
Old February 17th, 2006, 02:37 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Need help with photos on CD



If you remove the CD that the database resides on then you can expect Access to have problems (‘Disk or
Network Error’, for example). Otherwise, the user would have to swap CD’s to view a photo, then swap back
before scrolling to the next record – not very user friendly, and you would need to take care to pre-empt
any attempts to access the database in order to prompt the user to swap.

Possibilities:

1) Use a DVD, so that all the pictures fit on the same disk as the database.

2) Downsample the photos to screen resolution (and if necessary increase compression), so that they fit
on 1 CD (as long as you don’t need full resolution for zooming in or max quality printing).

3) Install the database to the hard drive so that it’s always available.

If you do need to span the files across CD’s then you’ll need to store info in the table to identify on
which disk each image resides. Then, when trying to show an image, you should be able to check if the
file is found (with a Dir command), and if not you can prompt for the relevant disk.

If the database is not launched from the CD you’ll need to find a way to identify the path to the images
(i.e. the drive letter of the CD drive).

--
__________________________________________________ _____
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0: Add pictures to Access, Easily & Efficiently


"jdogrulz via AccessMonster.com" u18293@uwe wrote:
Hi all,

This newbie needs some help please.

I need my db to be on cd for other cutomers. I have 4 cd's of photos that go
with it. My idea was to have the customer to start the db from a cd, then
browse through the records (1,400) and when they wanted to see a photo click
on a "show images" button. This would inturn open up my show_images form and
then would tell the customer to please insert the cd labeled "v5-N1" area,
and then the customer would insert this cd and presto, the photos would
appear. I am using DBPix. It works great just need to be portable with what I
have now..

any ideas?

Thanks much,

Jeff

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200602/1


  #3  
Old February 18th, 2006, 02:24 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Need help with photos on CD

Thanks much for that Bob. Ur very correct on the cd thing. Thanks, that didnt
click in me head....dugh!..that just shows what a newbie i am. I thought
about using DVD but different computers use different media. U know what I
mean. Some + and some - and the newer both wich is ok..but cant count on
customer having that..

Thanks again for everything Bob.

Jeff


jdogrulz wrote:
Hi all,

This newbie needs some help please.

I need my db to be on cd for other cutomers. I have 4 cd's of photos that go
with it. My idea was to have the customer to start the db from a cd, then
browse through the records (1,400) and when they wanted to see a photo click
on a "show images" button. This would inturn open up my show_images form and
then would tell the customer to please insert the cd labeled "v5-N1" area,
and then the customer would insert this cd and presto, the photos would
appear. I am using DBPix. It works great just need to be portable with what I
have now..

any ideas?

Thanks much,

Jeff


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200602/1
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting photos to word documents ljc General Discussion 2 December 3rd, 2005 08:38 AM
partial photos in Excel cells Lewis Shanks Setting up and Configuration 0 January 1st, 2005 10:00 PM
doc with many photos Jeff Formatting Long Documents 5 November 17th, 2004 02:06 PM
Adding photos to cells Richard Rosell Tables 2 June 14th, 2004 07:05 PM
addinng photos to cells in a table Richard Rosell Page Layout 1 June 14th, 2004 03:22 PM


All times are GMT +1. The time now is 10:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.