Fill in PDF From Access

[steveo0707]

I have a Access Form that we enter Data into tracking our non-conforming parts (NCMR). I have the code opening up the form and starting in the correct field, however, it is not transferring the data as I hoped. The Database is too large to share. I will attach photos of the pertinent information relating to the database. If I miss anything, please let me know.

Private Sub SendData(S As Variant)

    If IsNull(S) Or S = "" Then S = " "


    SendKeys S & "{TAB}", True
    Sleep 300
    
End Sub

Private Sub FillInPDFBtn_Click()
     
     ' Hyperlink
    
        FollowHyperlink "Y:/ISO WEB/Level IV/Quality/Q-220.pdf"
        
        Sleep 1000 'wait for PDF to Load
             
    ' Fill in Fields
    
        SendData NCMRNumber
        SendData PageNumber
        SendData OfNumber
        SendData NCMRType
        SendData InitiatedDate
        SendData ProductFamily


End Sub

Any Help would be greatly appreciated.

[mike60smart]

Hi Steve
Welcome to the Forum
Looking at your Forms & Table it looks like you have a number of Repeating Groups ie
Discrepancy 2
Discrepancy 2 Qty
Discrepancy 3
Discrepancy 3 Qty
Discrepancy 4
Discrepancy 4 Qty
Discrepancy 5
Discrepancy 5 Qty

The same applies to Disposition and Causes.

All of these fields should be Records in related separate Tables.

[Micron]

While true, I don't see any proof that is the cause of whatever issue being experience. SendKeys is temperamental and should be avoided when possible.
This is too vague

however, it is not transferring the data as I hoped.

Are you trying to insert data into an existing pdf form? It's not that simple. AFAIK, you would need to find and download the Adobe library for VBA and learn how to use it. The typical approach in VBA is to create a pdf from a report.

I kinda doubt you're going to recreate your db, but as noted, it's build like a spreadsheet, not a relational db. I don't see any primary key in that table property sheet either, which at some point will likely come back to bite you.

As for attaching db's here, copying/compacting/zipping usually gets the size down enough. See "How to Attach Files" at the top of the page if you need help with uploading anything here.

[Bulzie]

Never transferred data to a PDF so going in blind but what is it not doing, is it not transferring any data at all or putting data in the wrong fields on the PDF?
Few things, you have a pause to load the PDF, what it if is not long enough? Looks like you are using <tab> to move to next field, is that tab order correct on the form? Are you keeping the focus on the form?

[steveo0707]

It is opening the PDF and is starting in the correct Position (NCMR), it just isn't sending the data at all. I have attached a zipped file of the database.

[mike60smart]

Hi Steve
The attached is just a shortcut to the Db and not the actual database?