Report Problems

[Access Virgin]

I have a simple pop up form that I am using to get the user to enter certain parameters that are feed through to a letter report. When the report preview opens the parameter values have been carried through as expected but when I click the print button on the menu bar nothing happens. I changed the code so that the report goes straight to the printer, and the report prints out.

I also had this problem with a similar letter report. It was 2 pages. Again parameter values have been entered and passed through from a pop up form. When I open the report in preview I can see the first page as normal but when I click the navigation buttons to move to the next page I get an error message about invalid use of the .(dot) or ! operator or invalid parentheses. When I go to debug the code it stops at code i've entered for a text box. As the report is a letter I have used a text box for each paragraph. A paragraph is then a combination of text and the parameter values carried through from the form, eg "You must respond by " & me.ResonseDate & "." etc

I am using Access 2003, is this a problem with 2003. Both reports worked fine on the day I created them yet when I opened them up the next day I was getting these problems. Anyone able to help me here?

 

[maxmangion]

are you closing the pop up form ?

 

[Access Virgin]

yes, I close the pop up after the report opens

 

[maxmangion]

try leaving it open, it should work.

 

[Access Virgin]

thanks that works, must be because im using a pop up form, usually I use a normal form, the report opens but the form is still open in the background.

 

[maxmangion]

yes that's why it works with your normal forms because, when your reports open, your form is still opened in the background.

Your problem was occuring because once your pop up form is closed your parameter values are no longer available.

 

[Rich]

You can keep the PopUp form, just toggle its Visible property

 

[maxmangion]

but make sure that the Modal is set to No, otherwise you can't place the focus to your report.

 

[Rich]

but make sure that the Modal is set to No, otherwise you can't place the focus to your report.

Yes you can

 

[maxmangion]

Rich,

The following is the definition of the Modal, from the Access Help

Modal Property
You can use the Modal property to specify whether a form opens as a modal form. When a form opens as a modal form, you must close the form before you can move the focus to another object. Read/write Boolean.

 

[Rich]

Use this then


Dim frm As Form
For Each frm In Forms
frm.Visible = False
frm.Modal = False
Next