Search results

  1. B

    Output to pdf using fields

    Hi I have a routine that outputs an MS Access report as a pdf file which works OK. It does not open the file which is what I want. DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\rptTransactionInvoiceExcVAT.pdf", False What I would like to do is...
  2. B

    VBA change characters. Use Replace or Instr

    Hi I have a field called txtTransactionNumber which currenty has 16 numbers in it. I am trying to find a way to replace the first 12 numbers with an asterisk * and just leave the last 4 showing normally. so that 1234 5678 9123 4567 will become **** **** **** 4567 I am trying the...
Back
Top Bottom