A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Search engine



 
 
Thread Tools Display Modes
  #1  
Old August 23rd, 2004, 04:46 PM
external usenet poster
 
Posts: n/a
Default Search engine

How do I create a search engine within my database to find
a patient based on the criteria that I have entered in the
drop down/combo box.

For example i have entered
1. Male
2. Heart Attack
3. blood pressure less than 85
4.Search for the patient based on the criteria

How would I make this work.

I have all of the information of which patients o paper ,
but i am trying to get it on a database.

Thank you
  #2  
Old August 23rd, 2004, 05:47 PM
Kevin Sprinkel
external usenet poster
 
Posts: n/a
Default

The basic strategy is to display a form based on a query
that uses the values you've entered in your combo boxes.
How you implement this depends on where this data is
stored. As example of the syntax, enter the following in
the Criteria row of the Gender field:

=Forms!YourFormName!YourComboBoxName

HTH
Kevin Sprinkel

-----Original Message-----
How do I create a search engine within my database to

find a patient based on the criteria that I have entered
in the drop down/combo box.

For example i have entered
1. Male
2. Heart Attack
3. blood pressure less than 85
4.Search for the patient based on the criteria

How would I make this work.

I have all of the information of which patients o paper ,
but i am trying to get it on a database.

Thank you
.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Engine Scott Matheny New Users 1 July 28th, 2004 08:39 PM
Can I create a search engine? Scott Using Forms 1 June 3rd, 2004 04:56 PM
Can I setup a search engine? Scott Running & Setting Up Queries 1 June 3rd, 2004 12:41 AM
search engine moc Worksheet Functions 3 September 18th, 2003 11:13 PM


All times are GMT +1. The time now is 05:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.