Search results

  1. V

    vba exporting query to excel based on certain field

    Uncle Gizmo, thank you for your time.
  2. V

    vba exporting query to excel based on certain field

    I changed... ReportName = "QryDetailParticipants401" to... QueryName = "QryDetailParticipants401" now im getting a "complie error" Wrong number of arguments or invalid property assignment on the line that states... DoCmd.OpenQuery QueryName, acViewNormal, "[Cycler] = '" &...
  3. V

    vba exporting query to excel based on certain field

    sorry, I'm not following where and how would I do that?
  4. V

    vba exporting query to excel based on certain field

    Hello All, I'm stuck on this VBA code and cant seem to see what's wrong. running... access 2016, excel 2016 objective... have a query named “QryDetailParticipants401” contains four fields, cycler, RptName, Company, LastName. I would like to export the records into a spreadsheet...
  5. V

    formating and sending emails in access with vba

    Hello, I'm running: access 2016 outlook 2016 having a few issues... 1) need to be able to state certain font and size for email 2) need to be able to make certain words in the body bold 3) email need to be Send From a different email address, not mine the code...
  6. V

    email using vba in access looping thru recordset

    sorry should say... I was NOT able to get the Outlook Account change to work
  7. V

    email using vba in access looping thru recordset

    Gasman, thanks for the help I was able to complete the formatting on the body of the email however, I was able to get the Outlook Account change to work. I am running outlook 2016 any further advise you can give? where exactly do I insert the code that was on that link you...
  8. V

    email using vba in access looping thru recordset

    I am curenttly using some code I found online and it is working. I just have two issues that I would like to modify 1) I would like at add a FROM field so that the email comes from that email and not my email 2) I would like to format the "body" of the email in this fashion... Dear Sir...
  9. V

    Merge Multiple PDF into one thru VBA

    Got it... thanks CJ, everything is working really appreciate you help now onto the next task...
  10. V

    Merge Multiple PDF into one thru VBA

    Thanks CJ, I've made a few changes as I believe you suggested... 1) I changed this part. Part1Document.InsertPages 1, Part2Document, 0, Part2Document.GetNumPages(), True Part1Document.InsertPages 2, Part3Document, 0, Part3Document.GetNumPages(), True 2) I changed...
  11. V

    Merge Multiple PDF into one thru VBA

    Hi Minty, I cant produce only one report because of the size(I believe), what I'm trying to do is create a seven page pdf in which every page has different data from the same qry, I know that a mail merge would be the simplest way, but this is what I was asked to?!?! Hi CJ, thanks...
  12. V

    Merge Multiple PDF into one thru VBA

    Here is the code that I got to work, but need to loop and somehow have a variable for the filelocations... Private Sub MergePDF_Click() Dim AcroApp Dim Part1Document Dim Part2Document Dim Part3Document Dim Part4Document Dim Part5Document Dim Part6Document...
  13. V

    Merge Multiple PDF into one thru VBA

    I have a current VBA script that loops thru every recordset and export 7 reports into 7 pdfs with a unique file name derived from the "CustomerID" field in the recordset... so 1000 records means I have a folder with 7000 pdfs all with unique filenames. now I need to merge every 7 into 1...
  14. V

    Export Acess Report into Single One Page PDF

    A Millions Thanks !!!, it worked exactly as you stated.
  15. V

    Export Acess Report into Single One Page PDF

    yes, that is correct
  16. V

    Export Acess Report into Single One Page PDF

    the unique field is a combo of letters and numbers that actually makes up the "CustomerID", no two are alike. as for the quantity of PDF, most will be 1 or 2 pages but the script should create a new PDF when the CustomerID (unique field) field changes.
  17. V

    Export Acess Report into Single One Page PDF

    Hello, I have an Access DB with a report that contains 1000s records, looking to export into multiple PDFs while filtering on an unique field name and then using that same field in the naming convention. I am fairly new to the VBA world so an help would be greatly appreciated. thanks
Top Bottom