CreateReport Command

W

Wayne Huxman

I'm trying to use the CreateReport command (SET repObj = CreateReport) to
dynamically create a report for a dynamically created querydef in which the
query fields will vary based on a field selection.

The Createreport statement will open a new report in design view but I
haven't found the VBA methods to save or rename the report.

The CreateReportControl functionality is apparently only available with a
saved report in design view.

Thanks in advance to anyone that has any tips / input on how to use the
CreateReport and CreateReportControl commands without any user intervention.

Sincerely,

Wayne Huxman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to programatically add an existing report to a report (as sub) 2
No report header using CreateReport? 2
Binding Fields to Control Source 3
Dynamic Report 4
Add a logo to the report header with code 2
Access Page Setup Options Using CreateReport Code 5
Save Report With CreateReport Coding Issue 8
Can't Create a Control a TextBox - err 29054 4

Top