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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|