Re: Search Form - text string.
From: Matt Reed (n0sp-m_at_sbcglobal.net)
Date: 04/05/04
- Next message: Emilio Rodriguez: "Query through Form not working in XP"
- Previous message: foxtrojan: "Re: Auto-Numbering"
- In reply to: John Vinson: "Re: Search Form - text string."
- Next in thread: John Vinson: "Re: Search Form - text string."
- Reply: John Vinson: "Re: Search Form - text string."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 11:22:24 -0500
Thanks John,
Your note and the included site bring up some good points.
I believe I'm going to head out get one of your books.
But to start with - I used those dreaded "Lookup fields" to reduce errors
when entering the data. On many of the fields listed (year, tab, volume)
this is not such a big issue. Yet on the Seminar name, it could be quite
long and only a little different than some of the others. These seminars
are repeated year to year and each time the are presented they include 10-30
different titles. So having someone repeatedly typing in these names would
greatly increase the chances of an input error.
So if I do not use Lookup fields what should I use?
I believe this is a basic table design question and I need to learn the
basics better (first). If one of your books, someone else's book or a web
site handles this topic well - please point me in the right direction rather
than trying to teach me the basics on a newsgroup.
Thanks for your input, I would much rather learn that I going in the wrong
direction than how to fiddle with the system to make something work anyway.
Matt
"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:tmks60dm2qak9mvtme3f6h69o2cqm5apif@4ax.com...
On Thu, 1 Apr 2004 12:04:20 -0600, "Matt Reed" <n0sp-m@sbcglobal.net>
wrote:
>Being brand new in Access I need some advice where to start.
Start by getting rid of all your Lookup fields, for one thing! See
http://www.mvps.org/access/lookupfields.htm
for a critique.
>Have a database listing Seminar Articles.
>It consists of a main table (tblArticlesMain) with lookups into several
>other tables.
>[ID],[Title],[Lookup to tblAuthor],[Lookup to tblYear],[Lookup to
>tblSeminar], [Lookup to tblVolume],[Lookup to tblTab]
so what your table contains is numeric AuthorID, YearID, SeminarID,
VolumeID and TabID fields. The fact that your table contains numbers
is concealed from your view by the Lookup misfeature - it LOOKS like
it contains an author name, BUT IT DOESN'T.
>There is a form built to input data and it works fine.
You could build the form with the combo boxes without the Lookup
fields. Lookups are fine on Forms; they're dreadful in tables, as
you're finding out.
>The question is how to let the users search for data. On items like the
>Author's name I have a form with a ComboBox listing the Author's name and a
>subform with a listing of all the fields from tblArticlesMain. This is
>working fine. Can repeat for any individual search using a combobox to
>select an item in the field.
>What I want to do is add a textbox were I can enter a word and then check
>then [Search] the title field for any listing that includes that word
>anywhere in the Title.
Use a criterion of
LIKE "*" & [Forms]![YourForm]![Search] & "*"
in your Query.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: Emilio Rodriguez: "Query through Form not working in XP"
- Previous message: foxtrojan: "Re: Auto-Numbering"
- In reply to: John Vinson: "Re: Search Form - text string."
- Next in thread: John Vinson: "Re: Search Form - text string."
- Reply: John Vinson: "Re: Search Form - text string."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
