Search results

  1. G

    VBA to PDF Form Fields - preserve value format

    I have a VBA procedure (Access 2016) that writes to form fields in a PDF file. One of the fields is a zip code, and one of the values I need to send is a zip code beginning in 0. The preceding 0 keeps getting dropped. The form field format category property is set to none, and I can manually...
  2. G

    Non-Breaking Hyphens

    I have a memo field in a table and the string is often copied and pasted into this field from a word doc, pdf or email. It's a very specific string and it is critical that it be correct in the table as it appears on documents that become public record, hence the copy/paste. The problem is...
  3. G

    Automate PDF form import from VBA?

    My db's primary function is to create documents from our data. And I mean a LOT of documents. Daily. One of these documents is an industry standard PDF form. I can output the data I need for the PDF form fields (.txt), and I can import that data into the PDF from Acrobat (manage form option)...
  4. G

    Insert query writing time to date field

    Hi, first post - please be kind. I have an insert query that looks like this: DoCmd.RunSQL ("INSERT INTO DocTable ( FileID, DocType, DocTitle, DocStatus, DocSequence, DocCreationDate, DocCreationUser ) " & _ "SELECT " & intFileID & ", " & intDocType & ", " & Title & ", " & intStatus & ", " &...
Top Bottom