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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |