Recent content by bobdydd

  1. B

    Output to pdf using fields

    Thanks guys for all the prompt help. This is the line that did it for me. DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\" & Me.txtAmazonBuyer & ".pdf", False
  2. B

    Output to pdf using fields

    Hi I have tried that but it doesn't do it Thanks anyway
  3. 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...
  4. B

    VBA change characters. Use Replace or Instr

    Thanks I will give that a try
  5. 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...
See more
Back
Top Bottom