Create Report using VBA

[Guest]

Hi, I would like to create an Access Report using VBA. Please give some one a
workable code. My work requires like this:
Have a button on a form. When clicking on the button I am creating a table
based on a "CSV" file. Get the Records from the Table (SQL statment and
Recordset). I would like to display this record sets into a Report and
dynamically.

All I required is the user should click the button only, the result should
be a report showing on the scren.

with thanks & regards
Thiru

 

[Duane Hookom]

I would open the CSV file with Excel and allow the user to format the
results for printing.

If you want to spend a huge amount of time for less functionality, consider
the CreateReport function. There is decent information in Help about the
syntax.