[AccessD] (no subject)

...that means she has to possibly scroll through all the records ...use a 
LIKE filter to greatly narrow the list to quickly find the one she needs 
...type in an F she gets all the Fs ...add an A and she gets all the FAs in 
a filtered list where she just clicks on the name she wants to open a single 
record form or report ...I've sent her a sample off list.

William

----- Original Message ----- 
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, February 25, 2008 12:57 PM
Subject: Re: [AccessD] (no subject)


> My suggestion would be to skip the LIKE query and instead pop up a form
> first, containing a combo box and two buttons (preview and cancel). Let's
> call the combo-box Finder_cbo. First create a query called Patients_qs 
> whose
> SQL is:
>
> SELECT PatientID, Lname & ", " & Fname & " " & Mname
> FROM Patients
> ORDER BY Lname, Fname, Mname
>
> Save this query as Patients_qs (suffix means query select).
>
> Create a form containing a combo box and a pair of buttons "Preview" and
> "Cancel". use the wizard to create the buttons and for the former button,
> choose Preview Report. Change the resulting code so its stCriteria string
> looks like:
>
> stCriteria = "PatientID = " & Me.Finder_cbo
>
> Use the wizard to create the Cancel button and for its action just choose
> Form | Close.
>
> Finally, instead of opening the report directly, open the form just 
> created
> and it will handle the rest.
>
> hth,
> Arthur
>
> On Mon, Feb 25, 2008 at 12:34 PM, <krosenstiel at comcast.net> wrote:
>
>> >From a patient database in Access 2003, I want to pick the right patient
>> for a report of individual details. I have fields Lname, Fname and Mname. 
>> In
>> the query on the Lname field I have the following as the criteria:
>>
>> Like "*" & [Enter Last Name] & "*"
>>
>> This works fine to pick all the Johnsons, including "Johnson, Jr."
>> However, the report is then returning all the Johnsons in sequence, but I
>> only want 1 particular Johnson with his/her individual details. How do I 
>> get
>> the query to give me a list of "Johnsons," including first and middle 
>> names,
>> from which I can pick the right patient to plop into the report?
>>
>> MTIA -- and please keep it simple, I'm not very advanced with Access
>>
>>
>> --
>> Karen Rosenstiel
>> Seattle WA USA
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>