473,324 Members | 2,456 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

probably a old chestnut-tips of Photo database design please

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.


Nov 13 '05 #1
2 1381
None,
http://www.cerious.com ThumbsPlus. It's very good, it's cheap, and you can
save yourself the grief of trying to roll your own.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"None" <no*******@this.address.com> wrote in message
news:11***************@azores.network-i.net...
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.

Nov 13 '05 #2
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.
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Snah | last post by:
hi, i installed php on my XP Prof. PC (including IIS, Mysql) a basic command like $PHPLIB_DIR = $_SERVER . '/phplib'; is not working in php what's wrong ?
0
by: python newbie | last post by:
Ok, I am struggling with this setup.py. My python script happens to use the mxBase library, specifically the mx.DateTime package. That's the only "third party" package I use. I've gone through...
5
by: Harry | last post by:
but I'm a bit puzzled with javascript functions you can include to use in a JSP page - you can't see them in the page source code but can call them - does this mean they are called on the server...
15
by: Jim | last post by:
This is probably a common question - What is the best CSS editor? I'm an old HTML dinosaur that just getting into CSS. My HTML editor from way back is Homesite. They (Macromedia) tout Topstyle Pro...
3
by: Nicke | last post by:
Hi, I've used vb.net for 3 hours(!) now and have probably a very easy question. In my VB6 programs I use For Each Cell in Range... very often which not seems to work in vb.net. Ex. Dim Cell...
7
by: LeROY | last post by:
I need to output some related data tables as XML. I have my data adapters and my dataset with the relations defined. It is certainly simple enough to use the dataset.WriteXML function. However,...
4
by: Tomas Machala | last post by:
Hi, I'm trying to make an application communicating over TCP/IP. It should do only one thing - write received data to console and terminate itself when "exit" received. Problem is that if I send some...
3
by: Catweasel | last post by:
I'm new to C++ and have been chucked in at the deep-end. I have a C++ console app that works fine. All I want to do is write to file however as soon as I include the fstream library and try to...
7
by: Charles Sullivan | last post by:
On my system (using gcc) I found I need to use the "volatile" qualifier to limit compiler optimization. I notice that this qualifier is described in K&R 2nd edition (1988) but not in K&R 1st...
30
by: Brian Elmegaard | last post by:
Hi, I am struggling to understand how to really appreciate object orientation. I guess these are FAQ's but I have not been able to find the answers. Maybe my problem is that my style and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.