Search results

  1. N

    ExportingWithFormating with Variable file path and name

    So I was messing around with it and realized that the date in the filename is coming up as "mm/dd/yyyy" and the / are the problem. Any way to change it to a - or a .??
  2. N

    ExportingWithFormating with Variable file path and name

    yes, i created the folder
  3. N

    ExportingWithFormating with Variable file path and name

    here is the macro im trying to run
  4. N

    ExportingWithFormating with Variable file path and name

    the error says: "Microsoft Access can't save the output data to the file you've selected" no error number or anything like that. :banghead:
  5. N

    ExportingWithFormating with Variable file path and name

    The message box appears with the correct file location and name but I am still getting the output error. This would create a new file, would that cause the error?
  6. N

    ExportingWithFormating with Variable file path and name

    I double checked the spelling and it all looks good, I did notice I had the same combo box in the expression twice, here is the updated ="P:...\Merch Database\" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" & [Forms]![USER PAGE]![Text67] & ".pdf" I am still getting an error...
  7. N

    ExportingWithFormating with Variable file path and name

    Im wondering if it is possible to use the ExportWithFormating macro with an Output File dependent on a combo box and date picker located on separate forms. the expression I have right now isnt working =P:...\Merch Database" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" &...
Back
Top Bottom