I have something interesting...l ooking to see if anyone else has came across this.
I have a query with parameter [From Date] and [To Date] and the query works beautifully every time. However, when I use the wizard to build a report, at the end of the wizard the report opens beautifully, asks for the 2 parameters, and displays results. Beautiful. Then, after closing the report and re-opening, the report promts me for a third, unwanted parameter. [See the thread: http://bytes.com/topic/access/answer...xtra-parameter.] (Don't get lost in all the technical stuff...at the end of the thread we discovered it's somethign different between Access 03 and Access 07. It seems was set up right to begin with (as far as we could tell.))An expert from Bytes tried to help me using Access 2003. He said he couldn't make the third parameter box come up. I tried it in 2003 and it indeed worked properly for me too. But in 2007, it still asks for this silly parameter. I have built the report at least 10 times and every time it does the exact same thing. I'm a beginner so go easy with the tech lingo. :-)
PS. My company is using 2007 optionally and saving files in 03 format so things are compatible with people who haven't upgraded.
If you pull up my DB from the linked thread, the report with the problem is rptHOTSTICK_FAI LURE_BY_DATE. The first two parameters can handle "1/1/09" and "10/10/09." The query it comes from is HOTSTICK_FAILUR E_BY_DATE Query.
Has anyone else had this problem and does anyone know a remedy?
Thanks in advance. Danica
I have a query with parameter [From Date] and [To Date] and the query works beautifully every time. However, when I use the wizard to build a report, at the end of the wizard the report opens beautifully, asks for the 2 parameters, and displays results. Beautiful. Then, after closing the report and re-opening, the report promts me for a third, unwanted parameter. [See the thread: http://bytes.com/topic/access/answer...xtra-parameter.] (Don't get lost in all the technical stuff...at the end of the thread we discovered it's somethign different between Access 03 and Access 07. It seems was set up right to begin with (as far as we could tell.))An expert from Bytes tried to help me using Access 2003. He said he couldn't make the third parameter box come up. I tried it in 2003 and it indeed worked properly for me too. But in 2007, it still asks for this silly parameter. I have built the report at least 10 times and every time it does the exact same thing. I'm a beginner so go easy with the tech lingo. :-)
PS. My company is using 2007 optionally and saving files in 03 format so things are compatible with people who haven't upgraded.
If you pull up my DB from the linked thread, the report with the problem is rptHOTSTICK_FAI LURE_BY_DATE. The first two parameters can handle "1/1/09" and "10/10/09." The query it comes from is HOTSTICK_FAILUR E_BY_DATE Query.
Has anyone else had this problem and does anyone know a remedy?
Thanks in advance. Danica
Comment