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 Keeps Reappearing in Report
I'm using a form to set date ranges and agent names. Once the info is
selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#2
|
|||
|
|||
Form Keeps Reappearing in Report
This is happening because something is set up wrong. Are you using subreports
with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#3
|
|||
|
|||
Form Keeps Reappearing in Report
Yes to both questions. I have a report for phone stats with a subreport for
email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#4
|
|||
|
|||
Form Keeps Reappearing in Report
Don't close the form. Leave it open but hide it if you don't want to see it.
-- Duane Hookom Microsoft Access MVP "Whitney" wrote: Yes to both questions. I have a report for phone stats with a subreport for email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#5
|
|||
|
|||
Form Keeps Reappearing in Report
I'm assuming that's done in the Event Procedure. What code do I use to keep
it open, but hide it. This is the current code: Private Sub Report_Open(Cancel As Integer) ' Set public variable to true to indicate that the report ' is in the Open event ' Open Sales By Category Dialog DoCmd.OpenForm "ReportDateSelector", , , , , acDialog ' Set public variable to false to indicate that the ' Open event is completed End Sub "Duane Hookom" wrote: Don't close the form. Leave it open but hide it if you don't want to see it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: Yes to both questions. I have a report for phone stats with a subreport for email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#6
|
|||
|
|||
Form Keeps Reappearing in Report
You didn't provide any code that closes the form so I can't help you.
I expect there is some code in the form that closes it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm assuming that's done in the Event Procedure. What code do I use to keep it open, but hide it. This is the current code: Private Sub Report_Open(Cancel As Integer) ' Set public variable to true to indicate that the report ' is in the Open event ' Open Sales By Category Dialog DoCmd.OpenForm "ReportDateSelector", , , , , acDialog ' Set public variable to false to indicate that the ' Open event is completed End Sub "Duane Hookom" wrote: Don't close the form. Leave it open but hide it if you don't want to see it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: Yes to both questions. I have a report for phone stats with a subreport for email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#7
|
|||
|
|||
Form Keeps Reappearing in Report
It looks like it is already making it non-visible.
Private Sub Cancel_Click() DoCmd.Close acReport, "Daily Flash Report" DoCmd.Close acForm, "DailyReportDateSelector" End Sub Private Sub Form_Open(Cancel As Integer) Form_Open_Exit: Exit Sub End Sub Private Sub OK_Click() Me.Visible = False End Sub Private Sub ReportDate_Enter() Me.DTPicker = Date - 1 End Sub "Duane Hookom" wrote: You didn't provide any code that closes the form so I can't help you. I expect there is some code in the form that closes it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm assuming that's done in the Event Procedure. What code do I use to keep it open, but hide it. This is the current code: Private Sub Report_Open(Cancel As Integer) ' Set public variable to true to indicate that the report ' is in the Open event ' Open Sales By Category Dialog DoCmd.OpenForm "ReportDateSelector", , , , , acDialog ' Set public variable to false to indicate that the ' Open event is completed End Sub "Duane Hookom" wrote: Don't close the form. Leave it open but hide it if you don't want to see it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: Yes to both questions. I have a report for phone stats with a subreport for email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
#8
|
|||
|
|||
Form Keeps Reappearing in Report
This code looks like one of the reasons why I never use a solution that has
code in the report that opens the filtering form. I always open the form first and then the report. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: It looks like it is already making it non-visible. Private Sub Cancel_Click() DoCmd.Close acReport, "Daily Flash Report" DoCmd.Close acForm, "DailyReportDateSelector" End Sub Private Sub Form_Open(Cancel As Integer) Form_Open_Exit: Exit Sub End Sub Private Sub OK_Click() Me.Visible = False End Sub Private Sub ReportDate_Enter() Me.DTPicker = Date - 1 End Sub "Duane Hookom" wrote: You didn't provide any code that closes the form so I can't help you. I expect there is some code in the form that closes it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm assuming that's done in the Event Procedure. What code do I use to keep it open, but hide it. This is the current code: Private Sub Report_Open(Cancel As Integer) ' Set public variable to true to indicate that the report ' is in the Open event ' Open Sales By Category Dialog DoCmd.OpenForm "ReportDateSelector", , , , , acDialog ' Set public variable to false to indicate that the ' Open event is completed End Sub "Duane Hookom" wrote: Don't close the form. Leave it open but hide it if you don't want to see it. -- Duane Hookom Microsoft Access MVP "Whitney" wrote: Yes to both questions. I have a report for phone stats with a subreport for email stats. I'm using that same subreport as a regular report as well. So I need it to open with a form as well. Is that possible to do? When I click Ok the form does close and then reappears. "Duane Hookom" wrote: This is happening because something is set up wrong. Are you using subreports with code that open the form? When you "hit OK" are you closing the form? -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I'm using a form to set date ranges and agent names. Once the info is selected and I hit OK, it reappears again and again. I continue to click ok until the report appears, but then when scrolling from page to page the form again appears. I have to click ok to scroll to the next page. Why is this happening, how can I correct it? |
Thread Tools | |
Display Modes | |
|
|