Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 06-07-2006, 07:09 AM   #1
MStCyr
Newly Registered User
 
Join Date: Sep 2003
Location: Ottawa, Canada
Posts: 333
Thanks: 0
Thanked 43 Times in 39 Posts
MStCyr is on a distinguished road
Display Picture Without Storing the File in the Database

This sample database shows how you can display an image without storing the image in the database, simply by storing the path and the name of the file, therefore allowing you to store an unlimited number of images.

Also included are a few sample files to try this out.
Attached Files
File Type: zip PictDatabase2000.zip (90.5 KB, 14663 views)

MStCyr is offline  
The Following 2 Users Say Thank You to MStCyr For This Useful Post:
car20 (07-07-2011), hassanogaibi (06-28-2016)
Old 06-16-2006, 03:12 AM   #2
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 57 Times in 49 Posts
Oldsoftboss will become famous soon enough
And to zoom in and out, as well as print

http://www.access-programmers.co.uk/...ighlight=image

Dave
__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline  
The Following User Says Thank You to Oldsoftboss For This Useful Post:
hassanogaibi (06-28-2016)
Old 06-16-2006, 06:51 AM   #3
99shassan
Registered User
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
99shassan is on a distinguished road
Hi, thanks for that, it looks cool, but i'm not sure how you do it.
is there a guide anywhere?

99shassan is offline  
The Following User Says Thank You to 99shassan For This Useful Post:
hassanogaibi (06-28-2016)
Old 06-20-2006, 01:59 AM   #4
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 57 Times in 49 Posts
Oldsoftboss will become famous soon enough
Just follow the attachment.
__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline  
The Following User Says Thank You to Oldsoftboss For This Useful Post:
hassanogaibi (06-28-2016)
Old 07-25-2006, 04:31 PM   #5
sdzc
Registered User
 
Join Date: Mar 2004
Posts: 46
Thanks: 0
Thanked 3 Times in 3 Posts
sdzc is on a distinguished road
I like the ability to do this, but I only need a portion of the functionality.

I only need to store the path to the picture, I do not necessarily need a field to show the picture in the form.

What can I delete from the code so it does not require the picture field?

Thank you!
sdzc is offline  
The Following User Says Thank You to sdzc For This Useful Post:
hassanogaibi (06-28-2016)
Old 07-26-2006, 03:04 AM   #6
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 57 Times in 49 Posts
Oldsoftboss will become famous soon enough
To much to answer in a couple of lines.

One way would to be to delete the image from the form and then debug. Any offending lines will be highlighted and can then be deleted.

Dave
__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline  
The Following User Says Thank You to Oldsoftboss For This Useful Post:
hassanogaibi (06-28-2016)
Old 07-26-2006, 06:16 PM   #7
sdzc
Registered User
 
Join Date: Mar 2004
Posts: 46
Thanks: 0
Thanked 3 Times in 3 Posts
sdzc is on a distinguished road
Thank you for the response. I actually did kind of what you said, but made a copy and worked from that until I got it right (which was pretty much on the first try, which surprised me).

sdzc is offline  
The Following User Says Thank You to sdzc For This Useful Post:
hassanogaibi (06-28-2016)
Old 09-19-2006, 12:29 PM   #8
bjallen2880
T-Mobile USA
 
Join Date: Aug 2006
Location: Pennsylvania, USA
Posts: 13
Thanks: 0
Thanked 1 Time in 1 Post
bjallen2880 is on a distinguished road
Is there a way for this to work with continuous forms (multiple records displayed at a time) and display each picture? I took the DB here and converted the form from a single form to a continuous form and both records displayed the same picture (but each record was linked to a different pic). If you click on record 1 you got an apple on record 1 and 2. If you clicked on record 2 you got an orange on record 1 and 2.
bjallen2880 is offline  
The Following User Says Thank You to bjallen2880 For This Useful Post:
hassanogaibi (06-28-2016)
Old 09-20-2006, 01:43 AM   #9
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 57 Times in 49 Posts
Oldsoftboss will become famous soon enough
Quote:
Originally Posted by bjallen2880
Is there a way for this to work with continuous forms (multiple records displayed at a time) and display each picture? I took the DB here and converted the form from a single form to a continuous form and both records displayed the same picture (but each record was linked to a different pic). If you click on record 1 you got an apple on record 1 and 2. If you clicked on record 2 you got an orange on record 1 and 2.
Access bug..... sorry
__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline  
The Following User Says Thank You to Oldsoftboss For This Useful Post:
hassanogaibi (06-28-2016)
Old 09-29-2006, 06:27 AM   #10
teiben
Newly Registered User
 
Join Date: Jun 2002
Location: Detroit
Posts: 462
Thanks: 0
Thanked 1 Time in 1 Post
teiben
pdf's?

This works great. I tried it with jpg and it works too, but I've tried to do it with pdf's and I get a message the field is to small to accept the amount of data you attempted to add. The pdf is one page. I increased the image picture area to accomodate a 8.5 x 11 page and I still keep getting the same error message. Any idea how to accomplish this?

Help would be greatly appreciated.
teiben is offline  
The Following User Says Thank You to teiben For This Useful Post:
hassanogaibi (06-28-2016)
Old 10-19-2006, 02:53 AM   #11
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 57 Times in 49 Posts
Oldsoftboss will become famous soon enough
The PDF file is not an image, thus probably the reason for the error.
Search for PDF ActiveX or the like.

Dave

PS: There as samples here on how to open pdf files here
__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline  
The Following User Says Thank You to Oldsoftboss For This Useful Post:
hassanogaibi (06-28-2016)
Old 12-02-2006, 06:17 AM   #12
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 1,062
Thanks: 81
Thanked 67 Times in 59 Posts
MickJav will become famous soon enough
Quote:
Originally Posted by Oldsoftboss
Access bug..... sorry
I Found A Way Round It LOL

http://www.polyhex.net/ct/index11.jpg

Let me know if ya still need help

Mick

__________________
All open code examples and free projects are only available from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Creating a new project then add styles to it download open code example from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline  
The Following User Says Thank You to MickJav For This Useful Post:
hassanogaibi (06-28-2016)
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
getting file names in a given directory and then storing them in an array Trees Modules & VBA 4 08-03-2005 08:01 AM
Export table from Backend data file to new database aqif Tables 0 07-09-2005 04:35 AM
Set Day Name by Date DaniBoy General 7 11-22-2004 10:41 PM
Binding form to another form to display picture maya Forms 3 09-10-2003 05:00 PM
[SOLVED] display a record specific linked file as a picture christianhagman Reports 1 08-25-2000 12:12 PM




All times are GMT -8. The time now is 11:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World