the code behind the Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

How can I take a look at the code behind a report that I have created using
the Access wizard? (using the Report as a code generator)

Looking forward to here from you
 
just said:
How can I take a look at the code behind a report that I have created using
the Access wizard? (using the Report as a code generator)
Click to expand...


Open the report in design view, then use the View menu's
Code item.
 
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?

jDI
 
Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
 
Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

Marshall Barton said:
Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]

Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?
Click to expand...
Click to expand...
 
What do you mean by "headline for the report"? If you mean the title of the
report window, you can set the caption property with code in the On Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

just Do It said:
Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

Marshall Barton said:
Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]

Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
I ment the title on the first page of the written report
jDI

Duane Hookom said:
What do you mean by "headline for the report"? If you mean the title of the
report window, you can set the caption property with code in the On Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

just Do It said:
Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

Marshall Barton said:
Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]


just Do It wrote:
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
What do you mean by "the title"? Is this a text box or label control? Does
it have a name that you could share?

Is the "first page of the written report" the report header section or do
you mean the page header of the first page?

BTW: What value to you want to set this object to once we determine where
the value goes?

--
Duane Hookom
MS Access MVP
--

just Do It said:
I ment the title on the first page of the written report
jDI

Duane Hookom said:
What do you mean by "headline for the report"? If you mean the title of
the
report window, you can set the caption property with code in the On Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

just Do It said:
Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

:

Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]


just Do It wrote:
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have
created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
It is a label, "Follow-Up of Complaints".
It is the page header of the first page.

Thank you for your time :-)

Duane Hookom said:
What do you mean by "the title"? Is this a text box or label control? Does
it have a name that you could share?

Is the "first page of the written report" the report header section or do
you mean the page header of the first page?

BTW: What value to you want to set this object to once we determine where
the value goes?

--
Duane Hookom
MS Access MVP
--

just Do It said:
I ment the title on the first page of the written report
jDI

Duane Hookom said:
What do you mean by "headline for the report"? If you mean the title of
the
report window, you can set the caption property with code in the On Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

:

Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]


just Do It wrote:
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have
created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
I found lot of source code here:
http://p2p.wrox.com/archive/access/2002-12/66.asp

Thanks everybody!

just Do It said:
It is a label, "Follow-Up of Complaints".
It is the page header of the first page.

Thank you for your time :-)

Duane Hookom said:
What do you mean by "the title"? Is this a text box or label control? Does
it have a name that you could share?

Is the "first page of the written report" the report header section or do
you mean the page header of the first page?

BTW: What value to you want to set this object to once we determine where
the value goes?

--
Duane Hookom
MS Access MVP
--

just Do It said:
I ment the title on the first page of the written report
jDI

:

What do you mean by "headline for the report"? If you mean the title of
the
report window, you can set the caption property with code in the On Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

:

Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]


just Do It wrote:
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have
created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
There is a lot of code at that link but I don't see how it solves your
issue. Have you found a solution or are you still looking?

If you are still looking for an answer, you might want to provide the name
of your label control and where the value should come from to place in the
label caption.

--
Duane Hookom
MS Access MVP
--

just Do It said:
I found lot of source code here:
http://p2p.wrox.com/archive/access/2002-12/66.asp

Thanks everybody!

just Do It said:
It is a label, "Follow-Up of Complaints".
It is the page header of the first page.

Thank you for your time :-)

Duane Hookom said:
What do you mean by "the title"? Is this a text box or label control?
Does
it have a name that you could share?

Is the "first page of the written report" the report header section or
do
you mean the page header of the first page?

BTW: What value to you want to set this object to once we determine
where
the value goes?

--
Duane Hookom
MS Access MVP
--

I ment the title on the first page of the written report
jDI

:

What do you mean by "headline for the report"? If you mean the title
of
the
report window, you can set the caption property with code in the On
Open
event like:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "Whatever"
End Sub


--
Duane Hookom
MS Access MVP
--

Ok,

my purpose was to find out how to set the headline for the report.

What key word should I search for in Help to accomplish this?

jDI

:

Barring a bad mdb file, that means there is no VBA code
associated with the report. This is pretty common for the
simple reports that a wizard can create.
--
Marsh
MVP [MS Access]


just Do It wrote:
Strange...

I open the report in Desing view
I chose View - Code
The only thing that shows is an empty module?


just Do It wrote:
How can I take a look at the code behind a report that I have
created
using
the Access wizard? (using the Report as a code generator)


:
Open the report in design view, then use the View menu's
Code item.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top