Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

View records option

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Linda (RQ) - 15 Mar 2007 03:49 GMT
Hi Everyone,

I have a patient database.  My main form is based on my patients table.  A
subform on my main form has Pt. location which has the fields Area, Room
number and bed number.  How can I set something up so they can search for a
patient by room number?  I don't want to use any code.  I need some
ideas/options for this.

Thanks,
Linda
Trever B - 15 Mar 2007 04:30 GMT
Hi Linda,

You could do many things but here are a few suggestions,

          1)   Create a Combo box in Patient No order just to look
and/or  2)   Create a Combo box in bed order
and/or  3)  Create a Combo box in first name order

or

Select Field and press ctr & F to use search function

You can use wards, or Problems or whatever you want just with a query and a
combo box based on that query.  You can also select the item in the combo box
and will go to that page.

Hope this helps

Regards

Trev

> Hi Everyone,
>
[quoted text clipped - 6 lines]
> Thanks,
> Linda
Linda (RQ) - 18 Mar 2007 03:54 GMT
SHUUUUT UUUUP!  I liked the last suggestion and then tried it.   That is the
coolest thing ever.  You guys are really great!

Thank-you,

Linda

> Hi Linda,
>
[quoted text clipped - 32 lines]
>> Thanks,
>> Linda
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.