Recent content by Adam.Furtado

  1. A

    Module to Modify Report Controls Based on Form

    Mark, Thank you for your help. I am going to start looking into database design to get a better grasp on what you are suggesting. If you have any thoughts, I would certainly appreciate them. For anyone who is searching for this solution, I have figured it out. It was so much easier than I was...
  2. A

    Module to Modify Report Controls Based on Form

    I suppose I should've explained, this file^ is part of a much bigger relational database. I only included the relevant objects for this function, to keep it under the size limit. Customer Name is the primary key in the Customer List, because we have multiple locations and many customers have...
  3. A

    Module to Modify Report Controls Based on Form

    To be honest, I looked into name/value pairs and I can't be sure if that's what I need. I've attached the bare essentials of the operation. The form 'frmChooseFields' contains the combo boxes that allow the user to select which fields to display in the report 'rptProductListIndTest'. Your code...
  4. A

    Module to Modify Report Controls Based on Form

    Hello gentlemen, my apologies. I have been travelling and havent had the opportunity to continue this project. MarkK, I would like to go ahead and tweak your code for my specific task, but I do not know how/where to include the functions. I have fields that I can select from combo boxes (ex...
  5. A

    Module to Modify Report Controls Based on Form

    It's the same line as before: the one that calls the subroutine. I stepped through each one, and they all failed the same way.
  6. A

    Module to Modify Report Controls Based on Form

    I apologize for the double posting, I meant to delete the first one. I did not realize it was frowned upon. My bad. MarkK, I have tried to tweak the code as you described, but still ran into the same "Application or Object Defined error". Is this somewhat parallel to your train of thought...
  7. A

    Module to Modify Report Controls Based on Form

    I'm familiar with Access, this is my second database I am developing, although this is much more complicated than the first. I have used VBA, but I am still definitely a beginner. Jdraw: I wouldnt need to create the report, only modify the data source of the controls. The current field names...
  8. A

    Module to Modify Report Controls Based on Form

    Hello, I am trying to create a customizable report that would allow the users to choose fields in a form via combo boxes. I have a pretty common code that I found online and adapted it, but it fails on the first SetReportControl function. The error reads: Run-time error 2465...
  9. A

    Module to Modify Report Controls Based on Form

    Custom Report Fields based on Combo Boxes Hello, I am trying to create a customizable report that would allow the users to choose fields. I have a pretty common code that I found online and adapted it, but it fails on the first SetReportControl function. The error reads: Run-time error 2465...
  10. A

    Output A Report To Multiple PDFs

    SUCCESS! Can't believe i missed that apostrophe. For those searching, this is my final code to output to multiple PDFs.... In OpenReport Event: Private Sub Report_Open(Cancel As Integer) Me.Filter = "Customer='" & Forms![frmCreateReport]![txtCustomerSelect] & "'" Me.FilterOn = True End Sub...
  11. A

    Output A Report To Multiple PDFs

    Okay, I fixed the "Notes" part, so it should be fully functional. I removed all of the test buttons except for Command23 on frmCreateReport, as that is the only relevant one. I also checked the filter code on the Open_Report event, but I don't understand how it is differs from the code in Post...
  12. A

    Output A Report To Multiple PDFs

    Aha! I recreated it without the unneccesary features. I am looking to perform this operation through the frmCreateReport. Should be obvious which button is the go-to. Trying to produce "rptPriceSheetStandard", which is not functional right now, but rptPriceSheetQuarterly is. Reports are...
  13. A

    Output A Report To Multiple PDFs

    Unfortunately, I can't attach it, but I put it on my Google, Drive... which is useless having just learned I have too few posts to paste a link in my post. It is 2.62 mb because I had to draw in the linked tables, so it's pretty hefty right now.
  14. A

    Output A Report To Multiple PDFs

    Unfortunately, I'm getting the same error. It still directs me to my OutputTo line.
  15. A

    Output A Report To Multiple PDFs

    Okay, I fixed that. Now I have an error claiming incorrect syntax for my filter. in the OpenReport Event. Error: 3075: Syntax Error (missing operator) in query expression '(Customer=3A Composites)'. It tells me the error lies in my output coding still, but here is my Open Report Event...
See more
Top Bottom