Create a report with vba

C

Col

Hi all,

I have a temp table whose structure can change (client can add or remove
fields)
I want to create a tabular A3 report using vba.
How do I access the page setup items?

or is there a simpler way to do this?

Regards

Colin
 
D

Duane Hookom

A simpler method is to push the records to Excel. Creating an Access report
from code is a bit difficult compared with just exporting to Excel and
printing from there.
 

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

Create a Tabular Report with more than 30 fields 1
how do you shade alternating lines in a tabular report 11
create a custom report 1
Page Setup with VBA 1
Create a report from VBA. is it possible?? 1
create multiple details in a report 1
Report with variable number of columns 1
A3 Report layout help 3

Top