Recent content by chadbrewyet

  1. C

    IF/Then with Multiple Conditions

    SELECT CASE worked out exactly like I needed. Thanks guys!
  2. C

    IF/Then with Multiple Conditions

    I tried an array with my values in it but could never get the syntax to process the IF/then properly. I've made several changes to the code since beginning so I can't remember exactly how it was coded before and exactly what error it kept throwing.
  3. C

    IF/Then with Multiple Conditions

    Looked around and haven't found a satisfactory answer. I'm trying to create an If/Then statement that needs to match to multiple values. My initial thoughs were to create a list but that doesn't seem to work the way I thought it would. For example: If Me.Field = 1,2,5, or 8 Then Do 'X' Else...
  4. C

    Merge form data with Word template, then auto publish to PDF

    For some reason I can't seem to wrap my head around what I would think would be a simple process. I needed to merge a form's data into a pre-existing Word template so I looked around and found MANY MANY MANY code samples to do a word merge with each one being different from the last...
  5. C

    Open separate reports for each record in a continuous form

    Thanks everyone for the help. With your links and suggestions I was able to come across a code that finally worked. :) Not sure what I was really missing initially but it works now and that all that matters I guess. If there are any "best practices" that I should be using instead of what's...
  6. C

    Open separate reports for each record in a continuous form

    Yes, the buttons I want to have working are in the header of the form. There are buttons to print/export each individual record in the detail section and those work fine. It's only the buttons in the header that do not. I made a few changes to try to troubleshoot and it appears that it is...
  7. C

    Open separate reports for each record in a continuous form

    Here is another code snipet I found and it exports the file but it only exports 1 file for 1 record. The remaining files seem to not be there even though it appears to open a report for all the records. Set rstSubForm = Me.Form.RecordsetClone Do While Not rstSubForm.EOF Dim strFileName...
  8. C

    Open separate reports for each record in a continuous form

    Sorry if my OP wasn't clear. I'll try to explain better. Continuous form has 3 command buttons, print, export, email. Print button - when clicked, want to open a separate report for each record - the opened reports do not have to be visible - each individual report needs to be printed to the...
  9. C

    Open separate reports for each record in a continuous form

    New to the site. Hopefully this is in the right forum. I have a continuous form that displays a list of invoices (frmInvoiceList) based on an adjustable filter contained within the form. I have the filters working the way that I want them through VBa and I have a button on each record to open...
See more
Top Bottom