Re: Create Report using VBA

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.

--
Duane Hookom
MS Access MVP


"Thiru - Create Report" <Thiru - Create Report@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:BDEA4422-06BD-4D5E-803F-BC21C464215F@xxxxxxxxxxxxxxxx
> 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


.