A
Am.It
Hi all,
From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter. I am using
Set rpt = Application.CreateReport
rpt.RecordSource = <<Query_Name>>
Once I create the report, I m trying to create labels to display the
Report title in the Report Header section.
Set ctl = database.CreateReportControl(rpt.Name, acLabel, acHeader)
But this statement is failing with an error that section number is
invalid.
Then I am trying to get the column headers as labels in Pageheader
section of the report.
Set ctl = DB.CreateReportControl(repName, acLabel, acPageHeader)
ctl.Properties("Caption") = "Id"
This is not failing but the the label is not at all visible in the
design of the Report.
Then I m trying to use a textbox bound to the fields in the recordset.
I m able to get the values visible in the report.
Set ctl = qDB.CreateReportControl(repName, acTextBox, acDetail,
ColumnName:="Id")
Can anbody please tell me if there is any other better alternative to
create a simple query based report than the one I have adopted.
If not, how do i make those labels visible in the Report Header
section to set the title of the report.
I am pretty new to access and just wondering whats being wrong here.
Is there any way in VBA to go for "AutoReport: Tabular" report
????????
Any help would greatly be appreciated.
Thanks,
Am.It
From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter. I am using
Set rpt = Application.CreateReport
rpt.RecordSource = <<Query_Name>>
Once I create the report, I m trying to create labels to display the
Report title in the Report Header section.
Set ctl = database.CreateReportControl(rpt.Name, acLabel, acHeader)
But this statement is failing with an error that section number is
invalid.
Then I am trying to get the column headers as labels in Pageheader
section of the report.
Set ctl = DB.CreateReportControl(repName, acLabel, acPageHeader)
ctl.Properties("Caption") = "Id"
This is not failing but the the label is not at all visible in the
design of the Report.
Then I m trying to use a textbox bound to the fields in the recordset.
I m able to get the values visible in the report.
Set ctl = qDB.CreateReportControl(repName, acTextBox, acDetail,
ColumnName:="Id")
Can anbody please tell me if there is any other better alternative to
create a simple query based report than the one I have adopted.
If not, how do i make those labels visible in the Report Header
section to set the title of the report.
I am pretty new to access and just wondering whats being wrong here.
Is there any way in VBA to go for "AutoReport: Tabular" report
????????
Any help would greatly be appreciated.
Thanks,
Am.It