Results 1 to 7 of 7
  1. #1
    TesZero is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Location
    Portugal
    Posts
    5

    Read Pdf fields

    Hello again.


    I came back with another Headache


    So... i am developing another application.


    This application is about Service Quality and it stores the Non-Conformities in the institution.


    If there is a Non-Conformities registry we need to contact our sub contracted company and ask them the Corrective Action (how to solve the problem) about that non-conformity registry.


    So... all i need is to have a easy way to send a "form" to the other company, receive the data form filled and store it on my database...


    I dont want to send a excel file, so i was thinking about a fillable pdf form.


    The problem is that i googled a lot and i cant find how to read pdf fields to my access form/table ...


    Can someone help me? :|


    Best Regards
    Pedro Silva
    Portugal

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Maybe Collect Data would serve your needs.

    Otherwise, maybe this will help http://khkonsulting.com/2010/09/read...elds-with-vba/
    Need to know the names of the form fields on the PDF.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TesZero is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Location
    Portugal
    Posts
    5
    Hello, many thanks for your help.

    i know that example, and it would be great if it works :P
    or... if i could make it work

    I googled a lot about this before i post the question, when i found it i was very happy, but i can't make it work...

    i had created a form and a button, i post the code in the button, but it gave me a reference error.
    "Compile Error: User-Difined type not defined" here -> " Dim AcroApp As Acrobat.CAcroApp"

    I try to look up for the reference and i saw this, at here: http://www.khk.net/wordpress/2009/03...-introduction/ :



    but i dont have any "acrobat" reference in my access 2007 vba, i look for acrobat.tld in the internet but when i bowse for the reference it disapear for the list.
    At my reference list i have:
    - Acrobat Access 3.0 Type Library
    - AcroBrokerLib
    - AcroIEHelper 1.0 Tyope library
    - AcroIEHelperShim 1.0 Type Library
    - Adobe 3D utility 1.0 Type Library
    - Adobe Acrobat 7.0 Browser Control Type Library 1.0
    - Adobe Acrobat 9.0 Type Library

    I tryed to use the Adobe Acrobat 9.0 Type Library and it still dosent working..
    i got this error:
    "run-time error '429': ActiveX component can't creat object. here -> "Set AcroApp = CreateObject("AcroExch.App")"



    Again, Thank you for your help.

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Asked and answered on the UK forum. Double Post!

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I have code that manipulates PDF files. Review https://www.accessforums.net/access/...pdf-25574.html

    It does not require an App object.

    If you want to provide an Acrobat form fill document for testing, I will try.

    However, if you have a solution from another thread, would be considerate to provide here or link.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    TesZero is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Location
    Portugal
    Posts
    5
    Quote Originally Posted by burrina View Post
    Asked and answered on the UK forum. Double Post!
    Hello Burrina, is there any problem to be user in more than 1 access forum?

    when i get the solution, i put the answer in both, please find my posts and you will see it.
    I didnt put in this forum the question twice... so it is not a double post...
    Cant i be helped in diferent foruns?

    And... answered? what? is it solved?

    yup burrina, your answer didnt helped to solve it also :P

    but... thanks anyway

    __________________________________________________ _____


    June7, thank you very much for your help
    I was reading your code to merge pdf´s.
    Could it read from pdf fields?

    Yes i can let you on example of pdf that i need to fiel / read:
    http://www4.seg-social.pt/documents/...7/RC_3045_DGSS
    this for example.

    thank you very much for the help.

    Regards

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I have the form fill PDF. What are names of some of the fields?

    If you post question in multiple forums, it would be considerate to post link to other forums so respondents can review and don't spend time composing posts with info already provided. Find your posts were? Is this issue resolved?

    My code does not read PDF.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. MDB in Read Only, No .ldb, What to do
    By schwimms in forum Access
    Replies: 11
    Last Post: 02-25-2015, 03:12 PM
  2. Replies: 4
    Last Post: 09-02-2014, 11:43 AM
  3. Read Only
    By Huddle in forum Security
    Replies: 1
    Last Post: 02-24-2012, 02:23 PM
  4. How do I read the source?
    By pseudonym in forum Programming
    Replies: 2
    Last Post: 10-18-2011, 10:11 AM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums