error 3139

[john_willmott]

I have a FE/BE database in 2003. I have had 2007 on my machine for 18 months and have developed loads of reports which run from a 'date range report launcher' with a report selector, some text boxes for date parameters and a 'go' button.

All been working fine.

Have just upgraded to windows 7 professional and installed my 2007 on that. Suddenly getting Error 3139 - Syntax error in Parameter Clause.

All the reports record sources start PARAMETERS [Forms]![Frm_DateRangeReports].[TB_FromDate] DateTime, [Forms]![Frm_DateRangeReports].[TB_ToDate] DateTime; SELECT .....

I have an XP/2003 virtual machine on the machine and the reports run fine on there.

I can run the query from the QBE grid and it gives me the record set so it is picking up the parameters ok - it is only when I run the report

I could base all the reports on saved queries, but I would rather a fix rather than a work around. There are about 50 reports and the front end object windows are getting rather full.

Is there something I am missing ... is it a windows 7 issue or something missing from Office 2007???

Any suggestions most welcome

John.

 

[AccessMSSQL]

Have you checked your references? Open up any module and Debug> Compile. Also check Tools > References to make sure there are no MISSING references.

 

[john_willmott]

There are no modules used in this report so cannot see how it will be that but will have a look.

 

[john_willmott]

Just installed office 2007 service pack 3 and it has fixed the issue!!

john

 

[AccessMSSQL]

Good job! Glad you resolved the issue.