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 |
#11
|
|||
|
|||
Make subform visible or not in report?
This is really the easiest way there is. It shouldn't take but a few minutes
to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#12
|
|||
|
|||
Make subform visible or not in report?
OK thank you very much. Here is one more question for you if you dont mind? The developer named the sub report this way: rsubClosers-InProcess How do I get it to recondnize the "-" inbetween closers and INprocess? "Klatuu" wrote: I understand. The solution I proposed will work. To recap: 1. Add a checkbox control to the form the combo is on that the report is run from. 2. Add the following code to the Open event of the report. (you will have to use the correct names) If Forms!MyFormName!MyCheckBoxName = True Then Me.MySubReportControlName.Visible = True Else Me.MySubReportControlName.Visible = True End If Or more simply stated: Me.MySubReportControlName.Visible = Forms!MyFormName!MyCheckBoxName Now one thing to note. You don't use the name of the report that is the subreport. You use the name of the control on the report that contains the report object that is the Source Object of the the control. If you let Access do it, they are likely the same. You just need to look at the report in Design View and open the properties dialog for the subreport control to get the correct name. Get some rest and hit it tomorrow. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#13
|
|||
|
|||
Make subform visible or not in report?
here is the actual source object name: Report.rsubClosers-InProcess
"Klatuu" wrote: I understand. The solution I proposed will work. To recap: 1. Add a checkbox control to the form the combo is on that the report is run from. 2. Add the following code to the Open event of the report. (you will have to use the correct names) If Forms!MyFormName!MyCheckBoxName = True Then Me.MySubReportControlName.Visible = True Else Me.MySubReportControlName.Visible = True End If Or more simply stated: Me.MySubReportControlName.Visible = Forms!MyFormName!MyCheckBoxName Now one thing to note. You don't use the name of the report that is the subreport. You use the name of the control on the report that contains the report object that is the Source Object of the the control. If you let Access do it, they are likely the same. You just need to look at the report in Design View and open the properties dialog for the subreport control to get the correct name. Get some rest and hit it tomorrow. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#14
|
|||
|
|||
Make subform visible or not in report?
Yes but pretty simple however the fool made ths Source Object this name:
Report.rsubClosers-InProcess How dop I get the code to work with the dash and the period in there? Thanks again for your help I am almost there "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#15
|
|||
|
|||
Make subform visible or not in report?
surround it with square brackets.
[Report.rsubClosers-InProcess] -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Yes but pretty simple however the fool made ths Source Object this name: Report.rsubClosers-InProcess How dop I get the code to work with the dash and the period in there? Thanks again for your help I am almost there "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#16
|
|||
|
|||
Make subform visible or not in report?
NIGHTMARE. Yes I dont that but the error reads cant find the field "i"
referred to in your expression. I have the the code attached to my subform however I am using the Source Object name in my code and not the actual subform name. This is correct? "Klatuu" wrote: surround it with square brackets. [Report.rsubClosers-InProcess] -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Yes but pretty simple however the fool made ths Source Object this name: Report.rsubClosers-InProcess How dop I get the code to work with the dash and the period in there? Thanks again for your help I am almost there "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#17
|
|||
|
|||
Make subform visible or not in report?
That is correct. It should be
Me.[Report.rsubClosers-InProcess].Visible = It may be that the name is actually rsubClosers-InProcess You may need to try Me.[rsubClosers-InProcess].Visible = -- Dave Hargis, Microsoft Access MVP "TKM" wrote: NIGHTMARE. Yes I dont that but the error reads cant find the field "i" referred to in your expression. I have the the code attached to my subform however I am using the Source Object name in my code and not the actual subform name. This is correct? "Klatuu" wrote: surround it with square brackets. [Report.rsubClosers-InProcess] -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Yes but pretty simple however the fool made ths Source Object this name: Report.rsubClosers-InProcess How dop I get the code to work with the dash and the period in there? Thanks again for your help I am almost there "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#18
|
|||
|
|||
Make subform visible or not in report?
Got it with a lot of re writing. however you put me on the right track. thanks for everything! "Klatuu" wrote: I understand. The solution I proposed will work. To recap: 1. Add a checkbox control to the form the combo is on that the report is run from. 2. Add the following code to the Open event of the report. (you will have to use the correct names) If Forms!MyFormName!MyCheckBoxName = True Then Me.MySubReportControlName.Visible = True Else Me.MySubReportControlName.Visible = True End If Or more simply stated: Me.MySubReportControlName.Visible = Forms!MyFormName!MyCheckBoxName Now one thing to note. You don't use the name of the report that is the subreport. You use the name of the control on the report that contains the report object that is the Source Object of the the control. If you let Access do it, they are likely the same. You just need to look at the report in Design View and open the properties dialog for the subreport control to get the correct name. Get some rest and hit it tomorrow. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#19
|
|||
|
|||
Make subform visible or not in report?
I got an e-mail that there was a post, but it is not showing up.
-- Dave Hargis, Microsoft Access MVP "TKM" wrote: NIGHTMARE. Yes I dont that but the error reads cant find the field "i" referred to in your expression. I have the the code attached to my subform however I am using the Source Object name in my code and not the actual subform name. This is correct? "Klatuu" wrote: surround it with square brackets. [Report.rsubClosers-InProcess] -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Yes but pretty simple however the fool made ths Source Object this name: Report.rsubClosers-InProcess How dop I get the code to work with the dash and the period in there? Thanks again for your help I am almost there "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
#20
|
|||
|
|||
Make subform visible or not in report?
Your not going to believe this. It works perfectly however the report shows
either a blank page or 1/2 of a blank page where the comments use to be. The comments subform is in the middle of the main form and the company will not let me move it to the end. What next? My last step! Thanks again "Klatuu" wrote: This is really the easiest way there is. It shouldn't take but a few minutes to do it. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: They have someone coming in next week. Yea! however this one is a thorn in my side. You would not believe it if I told you. What a mess. I just thought someone could inform me of an easier way? "TKM" wrote: I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to sound so dumb about this but here is how it goes. The user selects the report he wants from a cbo. the report then opens and the user will print the report in front of her directly using the menu. Now all want is some way for the user to have an option to print or not print the comeent section on the report. Your past answers will they take care of this? I am very tired 12 hours and pushing it. Thanks for all your help! "Klatuu" wrote: You don't need a Y/N field in your table. You just need a checkbox on the form. That way when a user checks the checkbox, the comments will show. Step two: Slap the crap out of your lazy developer. -- Dave Hargis, Microsoft Access MVP "TKM" wrote: Thanks however it is a little more complicated than that. The form has a subform also. There is no Y/N field and the developers wont add one to the table. There is a print form button on the main form that does a ton of stuff that I could add in the code but need the Y/N to make it work? Maybe add another button or? "Klatuu" wrote: You can use the Open event of the report to read the value in a control on the form from which you launch the report and make the sub report control on the report visible or not. This example uses a check box where checking the box makes the comments visible. Me.subComments.Visible = Forms!FormName!chkShowComments -- Dave Hargis, Microsoft Access MVP "TKM" wrote: I messed up. I need to make the comment either print or not print. As I stated it is embedded as a subform in the report based off its own query. Any help would be appreciated. "TKM" wrote: I have a subform in my report list all the comments associated with a loan number. I am looking for a why (in my query?) to hve the Comments print or not print depending what the user wants. I dont not have a Y/N box set up for this. Is there a way in my query I can do this? |
Thread Tools | |
Display Modes | |
|
|