Images in database Access 2007 (1 Viewer)
- Thread starter Zlatkodo
- Start date
Thanks for answer, Rabbie,
This is my first database and I need more information.
If my path is: C: \ Documents and Settings \ User \ Desktop \ Scheme in which way should I store the path?
How can I, in this case, show the picture in the form of my database?
I've heard for the relative path. What is it and whether I should use?
Thanks in advance.
Zlatkodo
This is my first database and I need more information.
If my path is: C: \ Documents and Settings \ User \ Desktop \ Scheme in which way should I store the path?
How can I, in this case, show the picture in the form of my database?
I've heard for the relative path. What is it and whether I should use?
Thanks in advance.
Zlatkodo
- Local time
- Yesterday, 20:09
- Joined
- Jan 23, 2006
- Messages
- 15,379
see this link
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820
Not sure if it still applies to 2007, I have 2003 and it works well there
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820
Not sure if it still applies to 2007, I have 2003 and it works well there
It should do. The functions used in the code all apply in 2007.
I think there are too many differences between Access 2003 and Access 2007 and it is very difficult to manage, especially for beginner who makes his first database.
Maybe somewhere I can find the answers for the Access 2007?
Thanks. Zlatkodo.
Maybe somewhere I can find the answers for the Access 2007?
Thanks. Zlatkodo.
zorrodidit
New member
- Local time
- Today, 10:09
- Joined
- Apr 22, 2010
- Messages
- 2
Hi people.
I have stumbled on something that might be very helpful, taking into account the topic here.
I have two identical tables (different data) in an Access 2007 database, with three columns that I formatted as 'hyperlink' and the data in those fields are file or folder locations. (e.g. c:/user/mydocuments/blahblah.doc)
I have a union query that queries all fields in both tables, basically joining all the data from both tables.
I have one Form that shows all the data fields.
So I can view all records in the one form and click on the hyperlinks to view such things as related photos and other related documents.
But the hyperlinks don't work, even though they were blue and the mouse cursor went to a hand with pointing finger when passed over the blue hyperlinks.
So I changed the table fields with the hyperlinks to OLE, but that didn't work either, so I changed them back to hyperlink.
Then they worked.
But changes were made to the file location text in the query hyperlink fields.
In the union query, in data-sheet view, instead of say,
c:/user/mydocuments/blahblah.doc
there was #c:/user/mydocuments/blahblah.doc#
But this change with the # was only seen in the union query.
The table fields and the form fields still had the original file location description, without the #.
I also checked the union query in it's design view (SQL view) and nothing had changed from the original statement/expression.
So now I can open my database, open the form, search for a text file 'see quote document', click and open it, and it opens in a windows explorer window, go to the accompanying field in the same form, 'see photos', click and open it, ditto, go to the last of my hyperlink fields 'view support documents, ditto.
So is this common knowledge or have I been helpful?
Cheers,
Michael.
I have stumbled on something that might be very helpful, taking into account the topic here.
I have two identical tables (different data) in an Access 2007 database, with three columns that I formatted as 'hyperlink' and the data in those fields are file or folder locations. (e.g. c:/user/mydocuments/blahblah.doc)
I have a union query that queries all fields in both tables, basically joining all the data from both tables.
I have one Form that shows all the data fields.
So I can view all records in the one form and click on the hyperlinks to view such things as related photos and other related documents.
But the hyperlinks don't work, even though they were blue and the mouse cursor went to a hand with pointing finger when passed over the blue hyperlinks.
So I changed the table fields with the hyperlinks to OLE, but that didn't work either, so I changed them back to hyperlink.
Then they worked.
But changes were made to the file location text in the query hyperlink fields.
In the union query, in data-sheet view, instead of say,
c:/user/mydocuments/blahblah.doc
there was #c:/user/mydocuments/blahblah.doc#
But this change with the # was only seen in the union query.
The table fields and the form fields still had the original file location description, without the #.
I also checked the union query in it's design view (SQL view) and nothing had changed from the original statement/expression.
So now I can open my database, open the form, search for a text file 'see quote document', click and open it, and it opens in a windows explorer window, go to the accompanying field in the same form, 'see photos', click and open it, ditto, go to the last of my hyperlink fields 'view support documents, ditto.
So is this common knowledge or have I been helpful?
Cheers,
Michael.
I would always use referential access to Images i.e. held in a folder(s). The first consideration is that if you have images for all sort of data object try to have one function to get the image. This means that each form or Report must have consistent control naming references:
Image: ImageControl
File: ImageFile
The Forms or Report RecordSource i.e. Query must prescribe the ImageFile if each Record has its own image. Now that the Form or Report has ImageFile the Path has to prescribed. As variable paths can be used this function determines the path:
Next on a Form OnCurrent event =GetPicture()
With CodeContextObject the Function doesn't care where it is being called from. ImageControl to Invisible is to handle Reports when the image is unavailable.
I create a SubReport for the images and On Print Event =GetPicture()
Simon
Image: ImageControl
File: ImageFile
The Forms or Report RecordSource i.e. Query must prescribe the ImageFile if each Record has its own image. Now that the Form or Report has ImageFile the Path has to prescribed. As variable paths can be used this function determines the path:
Code:
Function GetImageDir() As String
GetImageDir = "C:\Databases\Demo\Images\"
End FunctionNext on a Form OnCurrent event =GetPicture()
Code:
Function GetPicture()
Dim FullPath As String
With CodeContextObject
FullPath = GetImageDir & .[ImageFile]
If Dir([FullPath]) <> Empty Then
.[ImageControl].Visible = True
.[ImageControl].Picture = FullPath
Else
.[ImageControl].Visible = False
End If
End With
End FunctionI create a SubReport for the images and On Print Event =GetPicture()
Simon
Max D
Registered User.
- Local time
- Yesterday, 17:09
- Joined
- Jul 3, 2009
- Messages
- 91
There are 2 simple answers here, if you don't want to become programming guru at once.
Use the attachment datatype for pictures - its the best advice for beginner.
If you need more, you can try the AccessImagine component, that can hold and organize images in some folder automatically.
Use the attachment datatype for pictures - its the best advice for beginner.
If you need more, you can try the AccessImagine component, that can hold and organize images in some folder automatically.
Keeping files outside the database: http://www.msaccessdeveloper.pro/#!...n-the-database/c6x8v/55b1978a0cf2f7a6a9311dbf
Similar threads
