How create report in ms access using vba programming (1 Viewer)

[postingart]

i want create report in ms access using vba programming ,

strSql = "Select cityID,cityName From tblCityInfo Order by cityID"
Set adoRS = Database.executeQuery(strSql)

If adoRS.EOF <> True Then

With .Sections("Dmembers").Controls
.Item("txtCode").DataField = adoRS.Fields(0).Name
.Item("txtName").DataField = adoRS.Fields(1).Name


End With
DRAreaInfo.Show
end if

please vb6 code convert into VBA ms access programming thanks

 

[arnelgp]

create a Report in design view.
it is much easier than a bunch of code.

 

[postingart]

create a Report in design view.
it is much easier than a bunch of code.

i want to create report in ms access using vba programming not in design mode

 

[jdraw]

Why? Is this an academic exercise?
The output from built in report wizard can be tweaked with vba.
I agree with arnelgp.

 

[Gasman]

i want to create report in ms access using vba programming not in design mode

Start here then?