Retrieving records with a query by form.

[Guest]

I am a welding trainer. I keep files of torn-out welding articles in folders
of different welding categories, e.g. “Aluminumâ€, “Brazingâ€â€¦etc. I have
Access 2003 and I want a database of welding magazine articles for research
purposes. The table’s fields are: Date-Page (primary key), Category, Article
Title, Key Word 1, Key Word 2, Synopsis. There is a 2nd table that is called
Categories and has 2 fields: id # (auto number/PK) and the category names.
Besides the two tables, there is a form that enters the info for each record
in the Article Data table. It has a ComboBox drop down list with the
Categories table as the RowSource and stamps the selected category name in
the cell of the Category Field of the Article Data table. The form works
great for entering the data for the welding article.

Also, I want a form that will have text boxes for entering search words, hit
a button and have records that include the search words in any of the fields
show up in a dynaset sub-form so I can spot articles that address the welding
issues I am resolving. The key words for searching the records cannot be on a
separate table to be shown on a ComboBox on this form because they are almost
infinite in number and often combined with an infinite number of other key
words. For example, I may need to search for all articles that discuss
“hydrogen embrittlement†in the “HAZâ€, Or all articles that discuss “hydrogen
embrittlement†and “electrodesâ€.

I do not know if to base a form on a query, filter or report. If a query
what type, a crosstab, or what? How may I make a form that can pass on such
key words to a filter, report or query and then display the records of all
articles that employ those key words? Any suggestions of a direction I can
go? Thank you for your help.

 

[Guest]

I would use only one field for Key_Word. Put all key words in the field
separated by spaces.
Then you can search with this as criteria --
Like "*" & [Enter key word] & "*"
If you enter “hydrogen†you will get all that have it in the key word field.
If you enter “hydrogen embrittlement†then the record must have the exact
phrase in the key word field.

 

[Guest]

Thanks for the reply. How may I put that criteria in a form field and get the
results displayed on the form or a subform, dynaset style?
--
Lukeskywelder

I would use only one field for Key_Word. Put all key words in the field
separated by spaces.
Then you can search with this as criteria --
Like "*" & [Enter key word] & "*"
If you enter “hydrogen†you will get all that have it in the key word field.
If you enter “hydrogen embrittlement†then the record must have the exact
phrase in the key word field.

I am a welding trainer. I keep files of torn-out welding articles in folders
of different welding categories, e.g. “Aluminumâ€, “Brazingâ€â€¦etc. I have
Access 2003 and I want a database of welding magazine articles for research
purposes. The table’s fields are: Date-Page (primary key), Category, Article
Title, Key Word 1, Key Word 2, Synopsis. There is a 2nd table that is called
Categories and has 2 fields: id # (auto number/PK) and the category names.
Besides the two tables, there is a form that enters the info for each record
in the Article Data table. It has a ComboBox drop down list with the
Categories table as the RowSource and stamps the selected category name in
the cell of the Category Field of the Article Data table. The form works
great for entering the data for the welding article.

Also, I want a form that will have text boxes for entering search words, hit
a button and have records that include the search words in any of the fields
show up in a dynaset sub-form so I can spot articles that address the welding
issues I am resolving. The key words for searching the records cannot be on a
separate table to be shown on a ComboBox on this form because they are almost
infinite in number and often combined with an infinite number of other key
words. For example, I may need to search for all articles that discuss
“hydrogen embrittlement†in the “HAZâ€, Or all articles that discuss “hydrogen
embrittlement†and “electrodesâ€.

I do not know if to base a form on a query, filter or report. If a query
what type, a crosstab, or what? How may I make a form that can pass on such
key words to a filter, report or query and then display the records of all
articles that employ those key words? Any suggestions of a direction I can
go? Thank you for your help.

 

[Guest]

Use an unbound textbox on the form to enter the key word for searching.
Use a query for the form record source.
In the query use criteria like this --
Like "*" & [Enter key word] & "*"

Thanks for the reply. How may I put that criteria in a form field and get the
results displayed on the form or a subform, dynaset style?
--
Lukeskywelder

I would use only one field for Key_Word. Put all key words in the field
separated by spaces.
Then you can search with this as criteria --
Like "*" & [Enter key word] & "*"
If you enter “hydrogen†you will get all that have it in the key word field.
If you enter “hydrogen embrittlement†then the record must have the exact
phrase in the key word field.

I am a welding trainer. I keep files of torn-out welding articles in folders
of different welding categories, e.g. “Aluminumâ€, “Brazingâ€â€¦etc. I have
Access 2003 and I want a database of welding magazine articles for research
purposes. The table’s fields are: Date-Page (primary key), Category, Article
Title, Key Word 1, Key Word 2, Synopsis. There is a 2nd table that is called
Categories and has 2 fields: id # (auto number/PK) and the category names.
Besides the two tables, there is a form that enters the info for each record
in the Article Data table. It has a ComboBox drop down list with the
Categories table as the RowSource and stamps the selected category name in
the cell of the Category Field of the Article Data table. The form works
great for entering the data for the welding article.

Also, I want a form that will have text boxes for entering search words, hit
a button and have records that include the search words in any of the fields
show up in a dynaset sub-form so I can spot articles that address the welding
issues I am resolving. The key words for searching the records cannot be on a
separate table to be shown on a ComboBox on this form because they are almost
infinite in number and often combined with an infinite number of other key
words. For example, I may need to search for all articles that discuss
“hydrogen embrittlement†in the “HAZâ€, Or all articles that discuss “hydrogen
embrittlement†and “electrodesâ€.

I do not know if to base a form on a query, filter or report. If a query
what type, a crosstab, or what? How may I make a form that can pass on such
key words to a filter, report or query and then display the records of all
articles that employ those key words? Any suggestions of a direction I can
go? Thank you for your help.