Ali, I am still working on this and need assistance. Here is what I am trying to create as you stated - 1 report with groups with subreports totaling 23 reports with 1 record selection and forcing a page break each report:
main report
Group - subrpt 1; subrpt2
Group - subrpt 3, subrpt4
Group - subrpt 4; subrpt 5
etc. to last has 4 subrpts
This is advanced for me...step by step would be helpful,...
Otter7
Last Activity: Oct 5 '10, 03:09 PM
Joined: May 18 '10
Location: Woodland Hills, CA
-
Thank you for the sample...it helps to use a visual...I should be good from here...hope your travel is relaxing!Leave a comment:
-
Still need your assitance...I seem to be missing something as the subreports are not showing as separate sections and not sure how to do a grouping with subreports...wo uld you mind posting a sample..or please post as a private message...Thank you!Leave a comment:
-
Thank you for responding...I was out of town on the weekend. I will follow your instructions today and respond wtih the results this afternoon.Leave a comment:
-
How do I create an unbound main report with all the existing reports being the subreports plus when clicking on this report opens only 1 record from the If combobox = 0; MsgBox "No Audit has been selected"?
I am still trying to save 1 selected record after selecting through a combox listing, the 23 reports into 1 pdf file...Leave a comment:
-
Unsuccessful, could not get the unbound report/subreports to work either...VBA must have some type of operator? to cause ongoing pagnation when saving multiple reports to the same pdf....I'll keep trying different variations of all that you submitted...any other coding you can think of? Thank you!Leave a comment:
-
I will give it a try and reply back tomorrow....Tha nks for checking in and assisting!Leave a comment:
-
The sample you submitted worked except, the reports are saving as individula pdf files...I'm trying to save all the reports for the selected record into 1 pdf file....is there an operator that stops the single pdf page from saving and holds it until the next cmd to save a page is added, etc. then the entire report is in 1 saved pdf file?Leave a comment:
-
Had a grid power failure...I will send another response tomorrow after reviewing your pdf sample...thank you for your assistance!.Leave a comment:
-
I'm not following exactly as I enter the form name MainForm which is a switchboard with control buttons to select certain forms to enter data after the user selects an audit from the drop down: there are 37 forms...the Print button works which loads all the reports into a single file to be printed...I thought I could do this with saving as a pdf. Perhaps I could email you my Db through my personal email to your personal email?Leave a comment:
-
For the "FormName" I enter the name of the form but for [Forms] I do not enter the form name, correct?Leave a comment:
-
This is the code I entered but it does not work, comes up as error End If:
Private Sub btnPDF_Click()
If Audit_Dte_ID = 0 Then
MsgBox "No audit has been selected"
ElseIf Me.Combo66 Is Not Null Then
End If
DoCmd.OutputTo acReport, "rpt1aAuditorin fo", acFormatPDF, , "Audit_dte_ id=" & Audit_Dte_ID, , True
DoCmd.OutputTo acReport, "rpt1ProjectBld gInfo",...Leave a comment:
-
Ok...I'll give it a try and respond later this evening, California time...off work right now...Thanks and I will respond back...Leave a comment:
-
Wooh! That worked except the pdf file is showing all the records and I need just 1 record selected from a drop down list. The user cannot enter data, preview or print or pdf unless an audit is selected...This is the code I have but wiill add all the rpt nams...
Private Sub btnPDF_Click()
If Audit_Dte_ID = 0 Then
MsgBox "No audidt has been selected"
Exit Sub
End If
DoCmd.OutputTo acReport,...Leave a comment:
-
Yes, but do I need to list all the report names? There are 23 individual reports per 1 recored to be a single pdf file in page order...so the user can save the pdf ie as 'One Montgomery Audit'....Leave a comment:
-
In Access, How to Convert Multiple Reports to 1 PDF file?
I want to add a control button to convert all reports for 1 selected record to print in page order as 1 pdf file. There is a control button to print 1 full report per selected record but some users will want to pdf the report to email to clients. What would the VBA coding be for the On Click Event Procedure for the PDF Report button? Or would a macro be better? I am a beginner with VBA & macros so elementary explanations/coding would be helpful....Than k... -
Wow! Went to the link and code language is too advanced for this beginner; will mark for future reference. However, thank you for the insight and clarification on NotInList event; nothing I have studied so far has not mentioned this term/event. Understand how it works now. Note: I tried UtterAccess for assistance but Bytes is easier, faster and I get my question answered with resources!!! Thanks Again!Leave a comment:
-
Field Properties-Combo Box/Value List/Lookup
Hello! I am a beginner with MS Access 2007. Creating a complex DB and need assistance on lookup columns created through Lookup Wizard with Allow Edits in table field. When a user enters a new value not listed in the lookup value list, will that value automatically be added to the lookup list or do I need to manually enter in the Field Property under Row Source? I have many more questions I will post separatly...Loo k forward to anyone assistance...Th ank...
No activity results to display
Leave a comment: