I have an Odd Question

[rshaw63]

Greetings everyone and thank you in advance for any help given to this question. I think its possible to do but unsure how to make it work.



Scenario

I have an Access table to track Transmittals to the Customer for a construction firm. I have managed to recreate their form however they can not put comments or sign that copy. What i have been doing is preparing the form twice. this is time consuming especially on multiple projects ran simultaneously. I have Acrobat DC pro and Access 2016.

My question is can i load that blank PDF already existing document and populate certain fields from the database and then send that form on to the customer for comments and signatures? Seems to me it should be possible as long as the fields on the PDF match the field names on the access table correct?
attached is their form image and the second screen is my database that i only need to fill out the top section they complete and sign the bottom and page 2 if necessary.

[rshaw63]

So update

I had found some code on the net that should be able to be tailored to do what i want
I can now get access to open an pdf existing form but not populate anything on the form.
part of the code is

FileNm = "D:\WORK STUFF\FORMS\2021 blanks\Af_3000.pdf" 'File location
Set gApp = CreateObject("AcroExch.app")


Set avDoc = CreateObject("AcroExch.AVDoc")
If avDoc.Open(FileNm, "") Then
Set pdDoc = avDoc.GetPDDoc()
Set jso = pdDoc.GetJSObject


jso.getField("Af_3000[0].Page1[0].COR_GOVT[0]").Value = "COR_GOVT"
jso.getField("Af_3000[0].Page1[0].CONTRACTOR[0]").Value = "CONTRACTOR"
jso.getField("Af_3000[0].Page1[0].Date_Submitted[0]").Value = "Date_Submitted"
pdDoc.Save PDSaveIncremental, FileNm 'Save changes to the PDF document
pdDoc.Close
End If

what i dont understand is why i am getting a runtime 424 error ?! I would think that i have to put the field location in the code so it know where to get data from right?

I know i am on the right track please help if you can..

[CJ_London]

might help if you a) tell use what error 424 is and b) what line of code is causing the error

[rshaw63]

thanks for the reply

the runtime error 424 "object not found" and when i run the debugger it highlights this Line " jso.getField("Af_3000[0].Page1[0].COR_GOVT[0]").Value = "COR_GOVT"

[rshaw63]

As i stated earlier i had renamed the fields on the PDF to match exactly the table fields in the database, so i am not sure why its not pulling the data. the object not found has to be a part of it I am guessing.

[Gicu]

Can you attach an empty PDF? It looks like you are trying to fill the fields with their names instead of their values. If the code runs on a form you might want to try something like this:

jso.getField("Af_3000[0].Page1[0].COR_GOVT[0]").Value = Me.[COR_GOVT] 'where COR_GOVT is a text box on the form bound to the COR_GOVT field

Also see the link below for some extra info that might help:
https://answers.microsoft.com/en-us/...e-3c301da5b890

Cheers,
Vlad

[rshaw63]

I tried to attach the blank PDF however it is larger than the attachment allowance

[rshaw63]

So i changed the code like your example and getting the same error . It does not populate the PDF and i get the error message

[Welshgasman]

Can't you inspect the locals window and see what jso holds?

[rshaw63]

not sure how to do that can you explain.

I did however run the code again and i am getting Runtime Error 424 - Object Required Error on this line:

[rshaw63]

I know those fields are populated in Access though looking at the table:
Attachment 46050Attachment 46051

[rshaw63]

Update again

so messing with the code a bit I had managed in the Code Editor to get it to display the proper value from the database field but it still wont put it on the PDF document. Meaning in the debugger window its pulling the values from the database just not putting that value on the pdf form.

[Welshgasman]

In the VBA window, put a breakpoint on a line FileNm=
Then click the button and walk through the code with F8.

Once you supposedly have created the jso object, inspect it in the Locals window and see what it contains.

I do not believe the error is complaining about your db fields, but the pdf fields?

https://community.adobe.com/t5/acrob...a/m-p/10047916

[rshaw63]

So i did the breek and step as you mentioned i get a ding from the PC but nothing shows up in the locals window either.
pretty frustrating I know it should be possible. thank you for your help though.

[rshaw63]

Okay so stepping through it it is what i guess i am reading has no data in the variable however if you highlight the line in the editor it is pulling the information from the table. so not sure what the deal is