Creating a search form

[Guest]

Hi guys

I have created a database to hold photo images. This is how it is set up.

Form One = Image Information (This holds a photo and some information)
Subforms 2 = Image Description ( This holds a text field containing keywords)
Subform 3 = Image comments (this holds information for Author and comments)

I would like to now create a search form that can search under the keywords
and brings up only the image files that applies to that keyword. First of all
is this possible ( I am gathering in access it is) and if so have i set up
the database to be able to do this and how do i then create a form to do this.

Cheers guys if you need any more information please let me know.

 

[storrboy]

Has the situation changed from when you last asked? I don't know that
I would have used subforms to display the results - one form and tabs
if necessary perhaps.

March 07

I assume you're after whole word matching?
I would allow typing a list of keywords into a single text box on a
form using a space to separate them. Create a function that splits the
entered list into an array of values to search on. Another function
(or maybe the same one) would loop through the elements of the array
and build a sql string using them as criteria The WHERE portion would
end up looking something like ...WHERE(tbl.Keywords LIKE "*/keyword1/
*" OR tbl.Keywords LIKE "*/keyword2/*".... The sql returned by the
function could be used to open a query, report or applied to a form
recordsource.

 

[storrboy]

Has the situation changed from when you last asked? I don't know that
I would have used subforms to display the results - one form and tabs
if necessary perhaps.

March 07

I assume you're after whole word matching?
I would allow typing a list of keywords into a single text box on a
form using a space to separate them. Create a function that splits the
entered list into an array of values to search on. Another function
(or maybe the same one) would loop through the elements of the array
and build a sql string using them as criteria The WHERE portion would
end up looking something like ...WHERE(tbl.Keywords LIKE "*/keyword1/
*" OR tbl.Keywords LIKE "*/keyword2/*".... The sql returned by the
function could be used to open a query, report or applied to a form
recordsource.

 

[(PeteCresswell)]

Per Silver76:

I would like to now create a search form that can search under the keywords
and brings up only the image files that applies to that keyword. First of all
is this possible ( I am gathering in access it is) and if so have i set up
the database to be able to do this and how do i then create a form to do this.

Sure it's possible, but why bother when something like ThumbsPlus
(www.cerious.com) does it ten times better for a thousandth of the cost?

BTW ThumbsPlus uses an MS Access DB for it's back end...

 

[Guest]

Sorry storboy i am very basic when it comes to access so do i create this
through a query or a form. I am actually yet to create the form / query to
use as a search function. The three forms are linked by an Image Reference
Number.

The end result i would like is for the search function to bring up the file
(3 linked forms referring to the one image which has the same keywords) up on
the screen.
This should allow for other users to key in a keyword which searches for all
files relating to those keywords.I apologise for my inadequecies in access as
I have never used sql or the query function yet and i am gathering that this
has to be done through either visual basic or sql (again not sure) hehehe

When i say i am a novice i am probably being too genorous as i have
absolutely no idea when it comes to access. I guess i have stumbled my way
this far. If you can give any basic advice or direction it would be much
appreciated.

Russell

So do i create the search through a form or a quer

 

[Guest]

Pete

Because my boss is demanding and he wants me to learn it

 

[Allen Browne]

Answered in another group where you asked this question.