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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pictures and Records (repost - no answer yesterday)



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2004, 04:48 PM
Rick B
external usenet poster
 
Posts: n/a
Default Pictures and Records (repost - no answer yesterday)

Hello all!

I am writing a database for a friend of mine who is a realtor. One of the
tabs on her client form is going to contain pictures of the properties.
Since a property can sell and go from one owner to another, I have the
property in a table separate from the client. I still need to come up with
a way to 'move' properties from one client to another while tracking
historical owners. But, that is for another post.

My question now, is what is the best way to store photos of the properties?
Each property has a unique address as the key. I would like to be able to
build a form where you can see all the property details (size, location,
price, tax valuation, etc.) and have a separate tab to contain the photo(s)
of the property. The number of photos will vary. Ideally, I would like the
tab to contain three small versions of the photos across, and as many up and
down as are available. Scroll bars, of course, when more than will fit the
screen. clicking on the photo (thumbnail) should pop up a full-size
version. Under each photo, I would also need a comment so I can explain
what part of the property it is. When I open that full-sive version in a
separate form, there should be a place to manipulate that comment.

I will also need to know the best way to store the photos. Ideally, on my
property form, there would be a button to "link" a new photo. When clicked,
it would allow me to search my harddrive for the photo and enter the
comments.

Any suggestions?

Rick B



  #2  
Old May 22nd, 2004, 03:59 AM
Joe Fallon
external usenet poster
 
Posts: n/a
Default Pictures and Records (repost - no answer yesterday)

If you are interested in storing the picture in the database check out
Stephen Lebans' web site:
http://www.lebans.com/loadsavejpeg.htm

The approved solution is to store the path and display the picture
dynamically.
How to Link a Picture to a Form:

Use an unbound image frame named: ImageFrame
and add a field to your table called ImagePath.

To add the picture to a report just use code like this in the On Format
event of the Detail Section.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

In the OnCurrent event of the form use this code:

Private Sub Form_Current()
On Error GoTo Err_Form_Current

If IsNull(Me![ImagePath]) Then
Me![ImageFrame].Picture = "c:\msaccess.jpg"
Else
Me![ImageFrame].Picture = Me![ImagePath]
End If

Exit_Form_Current:
Exit Sub

Err_Form_Current:
Select Case Err.Number
Case 2220
'ignore the Can't Load Image error
Case Else
MsgBox ("Error # " & Str(Err.Number) & " was generated by " &
Err.Source & Chr(13) & Err.Description)
Resume Exit_Form_Current
End Select

End Sub

The image takes a second or two to load. A dialog is put on screen too.
This process can get very annoying after a while because it happens every
time the user navigates to another record.

From Tony Toews' web site: http://www.granite.ab.ca/access/imagehandling.htm
Getting tired of seeing that Loading Image dialogue flicker? Getting errors
by users who click on things before this is finished displaying? Try
creating/changing the following registry key
HKEY_LOCAL_MACHINE\Software\Microsoft\Shared
Tools\GraphicsFilters\Import\JPEG\Options
ShowProgressDialog to No

I use the Tab control to "hide" the image on a different "page".
I also move the code to the OnGotFocus event of the ImagePath text box
which is on the next page of the Tab control.
This way, the only time the picture loads is when the user clicks the tab to
see it.

--
Joe Fallon
Access MVP



"Rick B" wrote in message
...
Hello all!

I am writing a database for a friend of mine who is a realtor. One of the
tabs on her client form is going to contain pictures of the properties.
Since a property can sell and go from one owner to another, I have the
property in a table separate from the client. I still need to come up

with
a way to 'move' properties from one client to another while tracking
historical owners. But, that is for another post.

My question now, is what is the best way to store photos of the

properties?
Each property has a unique address as the key. I would like to be able to
build a form where you can see all the property details (size, location,
price, tax valuation, etc.) and have a separate tab to contain the

photo(s)
of the property. The number of photos will vary. Ideally, I would like

the
tab to contain three small versions of the photos across, and as many up

and
down as are available. Scroll bars, of course, when more than will fit

the
screen. clicking on the photo (thumbnail) should pop up a full-size
version. Under each photo, I would also need a comment so I can explain
what part of the property it is. When I open that full-sive version in a
separate form, there should be a place to manipulate that comment.

I will also need to know the best way to store the photos. Ideally, on my
property form, there would be a button to "link" a new photo. When

clicked,
it would allow me to search my harddrive for the photo and enter the
comments.

Any suggestions?

Rick B





  #3  
Old May 28th, 2004, 04:23 AM
Roger C. Bledsoe
external usenet poster
 
Posts: n/a
Default Pictures and Records (repost - no answer yesterday)

Have you try the Access Insert Object dialog box editor to
add picture into each field you define in your database
table. First you need to make a field call in your table
design view. You give it a property field name and next you
click a small menu containing various field design in what
you need. Click to find OLE Object for that field to add a
picture later on. You can make as many OLE Object field to
hold your pictures. When done. Save it and click back into
it in Data sheet mode. When you get to the OLE Object
field. Then you'll right click it and the Insert Object
dialog box will appear with Editors and ways to insert your
picture into that field or fields if you have many. You can
also use the Access Import command to link many pictures
into your table that is attach to a form to show it to any
client to view. The Insert Object dialog have a link
attachment that you can you to tie your picture into your
table.
I hope that this will work for you. If not, well, I been
using it for my database to show pictures as well for me or
the client viewing it.
-----Original Message-----
Hello all!

I am writing a database for a friend of mine who is a

realtor. One of the
tabs on her client form is going to contain pictures of

the properties.
Since a property can sell and go from one owner to

another, I have the
property in a table separate from the client. I still

need to come up with
a way to 'move' properties from one client to another

while tracking
historical owners. But, that is for another post.

My question now, is what is the best way to store photos

of the properties?
Each property has a unique address as the key. I would

like to be able to
build a form where you can see all the property details

(size, location,
price, tax valuation, etc.) and have a separate tab to

contain the photo(s)
of the property. The number of photos will vary.

Ideally, I would like the
tab to contain three small versions of the photos across,

and as many up and
down as are available. Scroll bars, of course, when more

than will fit the
screen. clicking on the photo (thumbnail) should pop up a

full-size
version. Under each photo, I would also need a comment so

I can explain
what part of the property it is. When I open that

full-sive version in a
separate form, there should be a place to manipulate that

comment.

I will also need to know the best way to store the photos.

Ideally, on my
property form, there would be a button to "link" a new

photo. When clicked,
it would allow me to search my harddrive for the photo and

enter the
comments.

Any suggestions?

Rick B



.

 




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


All times are GMT +1. The time now is 09:05 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.