Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Changing a MS-Access report's RecordSource property

by jsprat (Curate)
on Jun 24, 2003 at 19:59 UTC ( #268657=note: print w/ replies, xml ) Need Help??


in reply to Changing a MS-Access report's RecordSource property

Did you realize that the Reports object returns a collection of all open reports?

Move the OpenReport before the change and make sure you open it in acViewDesign (acDesignView = 1), make your change, then re-open it in acViewNormal (print) or acViewPreview.

A couple of notes:

  1. I usually use Win32::OLE::Const "Microsoft Access 8.0"; to import the constants. (Yeah, I'm stuck with Access 97 ;)
  2. You can access the report with $access->Reports("Report Name") as well as using the zero-based array subscripts.

HTH...


Comment on Re: Changing a MS-Access report's RecordSource property
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://268657]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2015-07-30 02:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls