PC Review


Reply
Thread Tools Rate Thread

the code behind the Report?

 
 
=?Utf-8?B?anVzdCBEbyBJdA==?=
Guest
Posts: n/a
 
      2nd Apr 2006
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
 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      2nd Apr 2006
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.

--
Marsh
MVP [MS Access]
 
Reply With Quote
 
=?Utf-8?B?anVzdCBEbyBJdA==?=
Guest
Posts: n/a
 
      2nd Apr 2006
Strange...

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

jDI

"Marshall Barton" wrote:

> 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.
>
> --
> Marsh
> MVP [MS Access]
>

 
Reply With Quote
 
Douglas J. Steele
Guest
Posts: n/a
 
      2nd Apr 2006
There probably isn't any code, then. Reports don't necessarily need code.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"just Do It" <(E-Mail Removed)> wrote in message
news:86278D5F-9455-41E3-AF9B-(E-Mail Removed)...
> Strange...
>
> I open the report in Desing view
> I chose View - Code
> The only thing that shows is an empty module?
>
> jDI
>
> "Marshall Barton" wrote:
>
>> 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.
>>
>> --
>> Marsh
>> MVP [MS Access]
>>



 
Reply With Quote
 
Marshall Barton
Guest
Posts: n/a
 
      2nd Apr 2006
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)

>>
>>

>"Marshall Barton" wrote:
>> Open the report in design view, then use the View menu's
>> Code item.

 
Reply With Quote
 
=?Utf-8?B?anVzdCBEbyBJdA==?=
Guest
Posts: n/a
 
      2nd Apr 2006
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" wrote:

> 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)
> >>
> >>

> >"Marshall Barton" wrote:
> >> Open the report in design view, then use the View menu's
> >> Code item.

>

 
Reply With Quote
 
Duane Hookom
Guest
Posts: n/a
 
      2nd Apr 2006
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" <(E-Mail Removed)> wrote in message
news:86485811-8DFD-4A59-AA1F-(E-Mail Removed)...
> 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" wrote:
>
>> 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)
>> >>
>> >>
>> >"Marshall Barton" wrote:
>> >> Open the report in design view, then use the View menu's
>> >> Code item.

>>



 
Reply With Quote
 
=?Utf-8?B?anVzdCBEbyBJdA==?=
Guest
Posts: n/a
 
      2nd Apr 2006
I ment the title on the first page of the written report
jDI

"Duane Hookom" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:86485811-8DFD-4A59-AA1F-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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)
> >> >>
> >> >>
> >> >"Marshall Barton" wrote:
> >> >> Open the report in design view, then use the View menu's
> >> >> Code item.
> >>

>
>
>

 
Reply With Quote
 
Duane Hookom
Guest
Posts: n/a
 
      2nd Apr 2006
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" <(E-Mail Removed)> wrote in message
newsBBDA6DB-1FCD-4022-9D3B-(E-Mail Removed)...
>I ment the title on the first page of the written report
> jDI
>
> "Duane Hookom" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:86485811-8DFD-4A59-AA1F-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> 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)
>> >> >>
>> >> >>
>> >> >"Marshall Barton" wrote:
>> >> >> Open the report in design view, then use the View menu's
>> >> >> Code item.
>> >>

>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?anVzdCBEbyBJdA==?=
Guest
Posts: n/a
 
      2nd Apr 2006
It is a label, "Follow-Up of Complaints".
It is the page header of the first page.

Thank you for your time :-)

"Duane Hookom" wrote:

> 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" <(E-Mail Removed)> wrote in message
> newsBBDA6DB-1FCD-4022-9D3B-(E-Mail Removed)...
> >I ment the title on the first page of the written report
> > jDI
> >
> > "Duane Hookom" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:86485811-8DFD-4A59-AA1F-(E-Mail Removed)...
> >> > 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" wrote:
> >> >
> >> >> 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)
> >> >> >>
> >> >> >>
> >> >> >"Marshall Barton" wrote:
> >> >> >> Open the report in design view, then use the View menu's
> >> >> >> Code item.
> >> >>
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing a report to a specific printer name by using code rather that report setting markshowell Microsoft Access Reports 1 22nd Apr 2004 02:51 PM
Printing a report to a specific printer name by using code rather that report setting markshowell Microsoft Access Reports 0 21st Apr 2004 01:06 PM
Printing a report to a specific printer name by using code rather that report setting markshowell Microsoft Access Reports 0 21st Apr 2004 01:06 PM
Open report from form, then wait til report is closed before running rest of code? Jason Gyetko Microsoft Access 9 5th Mar 2004 07:01 PM
Open report from form, then wait til report is closed before running rest of code? Jason Gyetko Microsoft Access Forms 1 5th Mar 2004 03:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:14 PM.