sorting of records

[Michal]

Hello,
Question showed on short example:
I got Table with personal information with field 'Name'
If in Query based on that Table in 'Criteria' field for 'Name' I put
something in '[]' brackets f.e. [Name:] then before run Query I'll be asked
about a Name with which that table will be filtered.
Question: Is there possibility to replace 'putting from keyboard' to pick this
Name from box like Combo Box?

That Query is needed for me to prepare Report to print.

Michal

[Jeff L]

If you want your criteria to be a field on a form, you would put
Forms!YourFormName!YourFieldName in the criteria of the query field.

Hope that helps!
Michal wrote:

Hello,
Question showed on short example:
I got Table with personal information with field 'Name'
If in Query based on that Table in 'Criteria' field for 'Name' I put
something in '[]' brackets f.e. [Name:] then before run Query I'll be asked
about a Name with which that table will be filtered.
Question: Is there possibility to replace 'putting from keyboard' to pick this
Name from box like Combo Box?

That Query is needed for me to prepare Report to print.

Michal

[Tom van Stiphout]

On Tue, 1 Aug 2006 09:47:25 +0000 (UTC), Michal
<mi******@rudy.mif.pg.gda.plwrote:

I think you're talking about filtering, not sorting.
Anyway, yes, that's easy. Create the combobox and fill it. Then change
your [Name:] expression to:
Forms!MyForm!MyCombobox

Btw, it is not recommended to name a field Name, because it is a
reserved word. Rename it to CustomerName, PatientName or whatever
before you run into more problems.

-Tom.

>Hello,
Question showed on short example:
I got Table with personal information with field 'Name'
If in Query based on that Table in 'Criteria' field for 'Name' I put
something in '[]' brackets f.e. [Name:] then before run Query I'll be asked
about a Name with which that table will be filtered.
Question: Is there possibility to replace 'putting from keyboard' to pick this
Name from box like Combo Box?

That Query is needed for me to prepare Report to print.

Michal

[Korzeniowski Michal]

Jeff L <jl*******@hotmail.comwrote:

If you want your criteria to be a field on a form, you would put
Forms!YourFormName!YourFieldName in the criteria of the query field.

Hope that helps!

I'm beginner with Access, but hope I'll show my example clearly:
1) I got a Table and Query
2) I want to replace Query filtering from:
a) [EmployeeName:] in Query's Criteria -before Query is run it ask me
for EmployeeName to put from keyboard
to:
b) Combo Box before Query is run -to choose EmployeeName
All I wanna get is list of records in Report (not one recorde per page) for only one
EmployeeName choosen from Combo Box.

Michal

[Jeff L]

Ok, that is easy enough to do. In your report, you need to have it
based on a query that includes the field that you want to filter
on...in this case EmployeeName. In the criteria of that field, you
would put Forms!YourFormName!ComboBoxName, substituting the names where
appropriate.

Just a suggestion: You might want to filter on a field that makes the
employee unique, like EmployeeID. That way if you have two John Smiths
you can distinguish between them. You can easily set up your combo box
to handle this. Your row source would need to include EmployeeID and
EmployeeName, set the bound column to 1, number of columns to 2, and
column widths to 0;1. Now in the report, your criteria would be for
EmployeeID, and not the name even though the name is what you will be
able to see on the form.

Hope that helps!

Korzeniowski Michal wrote:

Jeff L <jl*******@hotmail.comwrote:

If you want your criteria to be a field on a form, you would put
Forms!YourFormName!YourFieldName in the criteria of the query field.

Hope that helps!

I'm beginner with Access, but hope I'll show my example clearly:
1) I got a Table and Query
2) I want to replace Query filtering from:
a) [EmployeeName:] in Query's Criteria -before Query is run it ask me
for EmployeeName to put from keyboard
to:
b) Combo Box before Query is run -to choose EmployeeName
All I wanna get is list of records in Report (not one recorde per page) for only one
EmployeeName choosen from Combo Box.

Michal