 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / April 2006the code behind the Report?
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 >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.  SignatureMarsh MVP [MS Access] Strange... I open the report in Desing view I chose View - Code The only thing that shows is an empty module? jDI > >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. There probably isn't any code, then. Reports don't necessarily need code. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Strange... > [quoted text clipped - 10 lines] >> Open the report in design view, then use the View menu's >> Code item. 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. SignatureMarsh MVP [MS Access] >Strange... > [quoted text clipped - 7 lines] >> Open the report in design view, then use the View menu's >> Code item. 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 [quoted text clipped - 10 lines] > >> Open the report in design view, then use the View menu's > >> Code item. 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 SignatureDuane Hookom MS Access MVP -- > Ok, > [quoted text clipped - 19 lines] >> >> Open the report in design view, then use the View menu's >> >> Code item. 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 [quoted text clipped - 26 lines] > >> >> Open the report in design view, then use the View menu's > >> >> Code item. 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? SignatureDuane Hookom MS Access MVP -- >I ment the title on the first page of the written report > jDI [quoted text clipped - 31 lines] >> >> >> Open the report in design view, then use the View menu's >> >> >> Code item. It is a label, "Follow-Up of Complaints". It is the page header of the first page. Thank you for your time :-) > What do you mean by "the title"? Is this a text box or label control? Does > it have a name that you could share? [quoted text clipped - 40 lines] > >> >> >> Open the report in design view, then use the View menu's > >> >> >> Code item. I found lot of source code here: http://p2p.wrox.com/archive/access/2002-12/66.asp Thanks everybody! > It is a label, "Follow-Up of Complaints". > It is the page header of the first page. [quoted text clipped - 45 lines] > > >> >> >> Open the report in design view, then use the View menu's > > >> >> >> Code item. 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. SignatureDuane Hookom MS Access MVP -- >I found lot of source code here: > http://p2p.wrox.com/archive/access/2002-12/66.asp [quoted text clipped - 55 lines] >> > >> >> >> Open the report in design view, then use the View menu's >> > >> >> >> Code item. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.