Search results

  1. G

    VBA to PDF Form Fields - preserve value format

    I'm not sure I follow you Ranman256. I have other fields in the same PDF with the same properties that I pass strings to without error. I do not get an error when I pass the value as a string either by definition or through expression, it just drops the leading zero. Can you show me what you...
  2. 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...
  3. G

    Non-Breaking Hyphens

    Database is MS Access 2007 and MS Access 2010 but again, the problem is not that the character appears incorrectly when viewed in Access. It appears as simply a hyphen. When copied into notepad it appears as a square although I don't see how that is helpful unless you are suggesting that I copy...
  4. G

    Non-Breaking Hyphens

    I'm not quite following - the character appears to be no different than any other hyphen when viewed in the database. It is only after it is pasted into the online form and then saved does the html code show instead. Performing a search for the html code in Access as if it is a string returns...
  5. G

    Non-Breaking Hyphens

    Data is in MS SQL, I changed the data type to text but I won't know if that worked until someone brings the next occurrence to my attention. Plus I'm not certain that the issue is really with how the data is stored or if the issue is occurring when the string is copied and pasted. For these...
  6. G

    Non-Breaking Hyphens

    I hope the use of the PHP code window isn't confusing or misleading - it was the only way I could figure out to show how the string is literally appearing without the post showing the character for the html.
  7. 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...
  8. 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)...
  9. G

    Insert query writing time to date field

    That worked. I cannot believe I didn't think of that. Thank you so much.:D
  10. 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