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  

Form/Query/Report problems



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2005, 01:55 PM
LT Larry
external usenet poster
 
Posts: n/a
Default Form/Query/Report problems

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
  #2  
Old May 17th, 2005, 03:03 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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.

"LT Larry" wrote:

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

  #3  
Old May 17th, 2005, 03:38 PM
LT Larry
external usenet poster
 
Posts: n/a
Default

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #4  
Old May 17th, 2005, 03:46 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #5  
Old May 17th, 2005, 06:14 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #6  
Old May 17th, 2005, 06:14 PM
LT Larry
external usenet poster
 
Posts: n/a
Default

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


"Klatuu" wrote:

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #7  
Old May 17th, 2005, 06:15 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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.

"LT Larry" wrote:

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


"Klatuu" wrote:

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #8  
Old May 17th, 2005, 06:16 PM
Klatuu
external usenet poster
 
Posts: n/a
Default



"LT Larry" wrote:

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


"Klatuu" wrote:

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #9  
Old May 17th, 2005, 06:17 PM
LT Larry
external usenet poster
 
Posts: n/a
Default

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])'


"Klatuu" wrote:

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.

"LT Larry" wrote:

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


"Klatuu" wrote:

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

  #10  
Old May 17th, 2005, 06:18 PM
LT Larry
external usenet poster
 
Posts: n/a
Default

There was no message in your last reply
LT

"Klatuu" wrote:



"LT Larry" wrote:

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


"Klatuu" wrote:

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.

"LT Larry" wrote:

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
"Klatuu" wrote:

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!

"LT Larry" wrote:

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

"Klatuu" wrote:

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.

"LT Larry" wrote:

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

 




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
Mulitple Outlook problems VanS General Discussion 4 April 28th, 2005 08:45 PM
Email send problems with DSL & Outlook bmcdermo General Discussion 3 April 1st, 2005 02:43 PM
Disconnect Problems with Sending Email jeff General Discussion 4 January 18th, 2005 06:36 PM
problems initiating mplay32.exe electricrainbowfish Powerpoint 8 July 8th, 2004 09:37 AM
Problems with Style formatting terrapinie Formatting Long Documents 2 July 7th, 2004 06:18 PM


All times are GMT +1. The time now is 11:56 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.