Import from fillable PDF (1 Viewer)

N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
Not sure if this is where this would go, but Is it possible to import fields from a fillable PDF file into a table in access without having to convert the PDF to another format?

What I would like to do is select a completed fillable PDF file, which would create a new record in the table, and then import the PDF fields to specific fields in the table.

I receive a fillable PDF with 25 fields, but based based on the project, not all field are used. Currently I either have to copy and paste, or hand type, the information into an access form, but if I could automate the process, it would speed things up a bit.

If it makes it any easier, I am using the full version of Acrobat as well.

Thank you
Kevin
 
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
Hi Kevin. Take a look at this demo page and try downloading the third file. I am hoping it will help you find the way.
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
theDBguy said:
Hi Kevin. Take a look at this demo page and try downloading the third file. I am hoping it will help you find the way.
Click to expand...

At a quick glance, thats a pretty sweet setup as it was able to identify all the fields. I'll have to dig into it more later and let you know what I come up with.

thank you
 
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
NearImpossible said:
At a quick glance, thats a pretty sweet setup as it was able to identify all the fields. I'll have to dig into it more later and let you know what I come up with.

thank you
Click to expand...
Hi. I haven't ran it in a while but doesn't it also include showing the value in the fields? If so, that's what I was hoping will help you get the values from the PDF into your database. Good luck!
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
theDBguy said:
Hi. I haven't ran it in a while but doesn't it also include showing the value in the fields? If so, that's what I was hoping will help you get the values from the PDF into your database. Good luck!
Click to expand...

looks like its just the field names...
 
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
NearImpossible said:
looks like its just the field names...
Click to expand...
I guess my memory failed me. Try adding the "value" property. Hopefully, it will work. I won't be able to do any testing for a while.
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
theDBguy said:
I guess my memory failed me. Try adding the "value" property. Hopefully, it will work. I won't be able to do any testing for a while.
Click to expand...

Using your original code I can get all the field names and If I declare and hard code each field, I can get the Value property to work. This will work as the fields won't change, unless I update the form, but looking more into it, there are over 50 fields returned from your code so an automated process would be ideal.

I just used 1 field as an example below.

your Original Code of
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & vbCrLf
gave me the "ADP" field name.

If I declare ADP as a string and add

Code: 
Me.txtFields = Me.txtFields & jso.getField("ADP").Value & vbCrLf

I get every field listed followed by the value of ADP, i.e.

ADP
140


This tells me I just need to figure out how to declare and pass the field names (me.txtFields) to the value property and i'll be set
 
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
NearImpossible said:
Using your original code I can get all the field names and If I declare and hard code each field, I can get the Value property to work. This will work as the fields won't change, unless I update the form, but looking more into it, there are over 50 fields returned from your code so an automated process would be ideal.

I just used 1 field as an example below.

your Original Code of
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & vbCrLf
gave me the "ADP" field name.

If I declare ADP as a string and add

Code: 
Me.txtFields = Me.txtFields & jso.getField("ADP").Value & vbCrLf
I get every field listed followed by the value of ADP, i.e.

ADP
140


This tells me I just need to figure out how to declare and pass the field names (me.txtFields) to the value property and i'll be set
Click to expand...
Hi. Try updating this code:
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & vbCrL
into this:
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & ": " & jso.getNthFieldName(lngCounter).Value & vbCrLf
Hope it helps...
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
theDBguy said:
Hi. Try updating this code:
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & vbCrL
into this:
Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & ": " & jso.getNthFieldName(lngCounter).Value & vbCrLf
Hope it helps...
Click to expand...

I tired that before and even just adding the .value to the end of the original string and get

424:Object Required
 
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
NearImpossible said:
I tired that before and even just adding the .value to the end of the original string and get

424:Object Required
Click to expand...
Okay, sorry. I'll have to look into it later then. I'll let you know if I find the answer. In the meantime, I suppose you could save the field names in a temp table and then loop through them to get the values from the PDF file. Just a thought...
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
theDBguy said:
Okay, sorry. I'll have to look into it later then. I'll let you know if I find the answer. In the meantime, I suppose you could save the field names in a temp table and then loop through them to get the values from the PDF file. Just a thought...
Click to expand...

I just got it !!

Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & ": " & jso.getField(jso.getNthFieldName(lngCounter)).Value & vbCrLf

Now to assign it to a table and i'm set

Thanks for your awesome code and help !!!
Kevin
 
Last edited:
theDBguy

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:26
Joined
Oct 29, 2018
Messages
21,454
NearImpossible said:
I just got it using both of these lines, looks like I need to do some renaming of my fields, lol

Code: 
Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & vbCrLf
Me.txtFields = Me.txtFields & jso.getField(jso.getNthFieldName(lngCounter)).Value & vbCrLf
Thanks for your awesome code and help !!!
Kevin
Click to expand...
Hi Kevin. Congratulations! Glad to hear you got it sorted out. Good luck with the rest of your project.
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
look at previous post for cleaned up code, guess you posted as I modified my response
 
N

NearImpossible

Registered User.
Local time
Yesterday, 20:26
Joined
Jul 12, 2019
Messages
225
Finally getting around to digging into this more, I noticed that its listing all the fields in alphabetical order, is there anyway to make it list them in the layout order, i.e. 1st field on form is 1st field listed, 2nd field is 2nd listed, etc.?
 
Last edited:
You must log in or register to reply here.

Similar threads

J
Splitting pdf files
Replies
15
Views
792
CJ_London
C
P
Error code solution
Replies
14
Views
495
Gasman
Gasman
1
Help with creating a button to export PDF file
2
Replies
33
Views
1,689
Gasman
Gasman
A
Solved Moved to New Computer, New Version of Access Issue with acFormatPDF
Replies
18
Views
266
pbaldy
pbaldy
S
Antivirus getting in the way
Replies
2
Views
363
moke123
moke123

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom