None wrote:
Hi,
I'm sure this a FAQ-worthy one, but....
I need a fairly simple database to catalogue a large number of photographs.
The primary purpose is to be able to search on fields to see if a photo
exists already and can be re-used.
I want most of the fields to be pre-defined, maybe in the form of
checkboxes, so there can be no ambiguity, such as one entry of "Blue car"
and another of "Red vehicle" for example.
Instead I would have a set of checkboxes thus:
[x] red
[ ] blue
[x] car
[ ] motorcycle
[ ] goods vehicle
etc.
In search mode, ideally, I would like a search where I can have a list of
likely hits, and be able to click on the hit and have it open the file to
viewing in the default viewer.
Is this possible?
A link to tutorial or any help/advice appreciated.
If the viewer is not contained within Access then you should check out
hyperlinks. I'm not crazy about MS's implementation of hyperlinks in
datasheets. It opens on a single click (some may like it) but it
minimizes Access and that gets to be a PITA when switching between windows.
You can do some control with FollowHyperlink but MS forgot the window
state. They basically provided a half assed solution and denied
developers control of hyperlinks.
I've modified some code at
http://www.mvps.org/access that allows you to
open an external app and set the window state. I prefer this method
most of all. I use HyperlinkPart to get the address to open the file.
Just a hint. Let's say you want to display "Red Car" to the user and
open the file at c:\temp\redcar.jpg you can create a hyperlink like
Me.HyperlinkField = "Red Car#C:\Temp\RedCar.jpg#"
Also, you should always check there are no # signs in the file name
since the # delimits the parts of a hyperlink and Access gets confused
and belches when that happens.
The rest of your question is standard database stuff.