Using code to display data in Report

[Anita Tadhani]

I want to generate report using query.
My query is simple
"Select GMTDateTime, ConvertToLocal(GMTDateTime) as LocalDateTime from
tbDateTime"
How can I write code in VBA to generate Report?

Thanks

 

[Jeff Boyce]

Anita

Is there a reason you need to do this in code? Is the UI available?

It would be a simple matter to highlight the query, click the "New" toolbar
button drop-down, and select "Report".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Anita Tadhani]

Yeah, Since I use convertToLocal module in my query, I want to test
performance that how it makes a difference if I populate all the records
through coding?

I have thousands of records in my table.

I know using UI is faster, But I want to measure the difference.

 

[Anita Tadhani]

Please help me.

Yeah, Since I use convertToLocal module in my query, I want to test
performance that how it makes a difference if I populate all the records
through coding?

I have thousands of records in my table.

I know using UI is faster, But I want to measure the difference.

 

[Jeff Boyce]

I asked about the UI because that's what I use. I don't have any experience
to draw on using VBA to do this.

I will point out that iterating through the records using VBA is MUCH slower
(usually) than using set-oriented queries to retrieve the recordset you'd
use for the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP