Form/Query/Report problems

[Guest]

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

 

[Guest]

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

There was no message in your last reply
LT

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

I'm sorry L T, I only brought half of my brain in to work today. The other
half is home asleep. It has to be like a where clause without the where:
"[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'"

Where [MyField] is the field you want to filter on.

Again, my apologies.

Same message W/out the = sign

Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19]

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'


:

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

:

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Same message W/out the = sign

Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19]

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

:

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19]

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Sorry need to make a correction
When I run the Query By its self I get a perameter promt [Forms]![Empl
Reports]![Combo19] when I enter a specific name the query pulls the correct
record

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

I entered the Expression
In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'"
And still get an oper Error
I tried placing the Where: Clause and still the same message

I'm sorry L T, I only brought half of my brain in to work today. The other
half is home asleep. It has to be like a where clause without the where:
"[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'"

Where [MyField] is the field you want to filter on.

Again, my apologies.

Same message W/out the = sign

Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19]

:

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'


:

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

:

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

I Entered the following statement
In Filter:"[Last Name] ='" & [Forms]![Patrol Reports]![Combo19]&"'"
Still receiving a Missing Oper Error
I try adding the where statement with the same results

I'm sorry L T, I only brought half of my brain in to work today. The other
half is home asleep. It has to be like a where clause without the where:
"[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'"

Where [MyField] is the field you want to filter on.

Again, my apologies.

Same message W/out the = sign

Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19]

:

Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'


:

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

:

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

LT,

I thought you took the lookup out of the query. That is absolutely necessary.
That may be why you are getting the error. Also, I notice there is no space
between the = sign and the single quote. Try changing that:

In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'"
In Filter:"[Last Name] = '" & [Forms]![Empl Reports]![Combo19]&"'"
Space goes here--------^

Sorry need to make a correction
When I run the Query By its self I get a perameter promt [Forms]![Empl
Reports]![Combo19] when I enter a specific name the query pulls the correct
record

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance

 

[Guest]

Klatuu

I cut and paste the corrected string from the last post and I deleted the
old query and built a new one with no Lookup and I am still receiving the
Missing Op error

LT,

I thought you took the lookup out of the query. That is absolutely necessary.
That may be why you are getting the error. Also, I notice there is no space
between the = sign and the single quote. Try changing that:

In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'"
In Filter:"[Last Name] = '" & [Forms]![Empl Reports]![Combo19]&"'"
Space goes here--------^

Sorry need to make a correction
When I run the Query By its self I get a perameter promt [Forms]![Empl
Reports]![Combo19] when I enter a specific name the query pulls the correct
record

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance