Problem with PARAMETERS clauses in Access 2007 reports

[Guest]

There is a problem that I have discovered with Access 2007 that I have only
found reported once – at UtterAccess – but it was somewhat dismissed there by
an Access MVP. I also reported this in the microsoft.public.access.reports
discussion group at the beginning of the month, and the only reply I received
was that I should use a form to collect the parameters. I know the unbound
form trick is an option from an article on the topic on Allen Browne's site,
but it is not practical to do this to resolve the issue for 200 or so clients
my company has provided such reports to.

The problem: If you try to open a report that has a SQL statement with a
PARAMETERS clause as the Record Source, Access 2007 throws Error 3194. If you
use a named query with the exact same SQL for the Record Source, no error.
This was not an issue in Access 2003 or earlier.

To see a simple example of this, download this file:
http://home.comcast.net/~mmatuszak/ParameterClauseThrowsError3194.zip

Any ideas on how I can bring this to Microsoft’s attention, since raising
the issue in discussion groups doesn’t seem to be working?

 

[Guest]

Hi Michael,

Any ideas on how I can bring this to Microsoft’s attention, since raising
the issue in discussion groups doesn’t seem to be working?

I can tell you that your message has been brought to the attention of the
Access Development Team at Microsoft (another Access MVP did this earlier
today). Whether or not you receive an answer remains to be seen.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[michael]

Hi Michael,


I can tell you that your message has been brought to the attention of the
Access Development Team at Microsoft (another Access MVP did this earlier
today). Whether or not you receive an answer remains to be seen.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________