Add text into a pdf file within a form in MS Access (1 Viewer)

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Hi All,

How can I open and add text or movable stamp contains data into pdf file within a form in MS Access?

To clarify my aim, within a form I can press a button and navigate to an existing pdf file and add a movable time stamp contains a record reference into the file.

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
Hi. Pardon my ignorance but what you do mean by "movable time stamp?"
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Hi. Pardon my ignorance but what you do mean by "movable time stamp?"
Hello,
Like a small transperent image has a data from the form past it into the pdf file while it's open, and once it's done can save it to a specific folder D:/Work in progress.

Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
Hello,
Like a small transperent image has a data from the form past it into the pdf file while it's open, and once it's done can save it to a specific folder D:/Work in progress.

Sent from my HUAWEI NXT-L29 using Tapatalk
Are you referring to a "watermark?"
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Are you referring to a "watermark?"
No, not watermark.

My aim is to eliminate pasting a print out of a label has a barcode references the record ID with a time stamp of submission on the pdf document.

Like to press a button and populate a transparent electronic label that the user can past it on the pdf electronically.


Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
No, not watermark.

My aim is to eliminate pasting a print out of a label has a barcode references the record ID with a time stamp of submission on the pdf document.

Like to press a button and populate a transparent electronic label that the user can past it on the pdf electronically.


Sent from my HUAWEI NXT-L29 using Tapatalk
Hi. Sorry, I am still lost. Can you maybe post some images or a reference to what you're talking about?
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Hi. Sorry, I am still lost. Can you maybe post some images or a reference to what you're talking about?
I am still searching I will post it ASAP.

Sent from my HUAWEI NXT-L29 using Tapatalk
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:41
Joined
May 7, 2009
Messages
19,169
is the pdf static or some kind of template?
if so just create an Image of this pdf.
create a report on access and insert the pdf-Image.
then add a Label/texbox to this report.
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Please find attached, it's a movable electronic stamp in Adobe Acrobat.

I would like to implement it in MS Access.

Thanks for your prompt response.


Sent from my HUAWEI NXT-L29 using Tapatalk
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:41
Joined
May 7, 2009
Messages
19,169
there are lot's of barcode sample here that you can adapt.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
Please find attached, it's a movable electronic stamp in Adobe Acrobat.

I would like to implement it in MS Access.

Thanks for your prompt response.

Sent from my HUAWEI NXT-L29 using Tapatalk
Hi. Since I am not familiar with what you're referring to, looking at an image doesn't really explain to me the "movable" part. Are you able to simply post a sample PDF file where we can see this "movable" timestamp and actually move it? Or, can you post a link to where you found that image? Thanks.
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
is the pdf static or some kind of template?
if so just create an Image of this pdf.
create a report on access and insert the pdf-Image.
then add a Label/texbox to this report.
Thanks for your response.

That's exactly what I want, but how can build my VBA code to automate this process?

The process map as below:
1 Select pdf file.
2 Add the image with respective data.
3 Save it into a specific folder: D:/Work in progress.
4 Save the record.

Thanks.



Sent from my HUAWEI NXT-L29 using Tapatalk
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Hi. Since I am not familiar with what you're referring to, looking at an image doesn't really explain to me the "movable" part. Are you able to simply post a sample PDF file where we can see this "movable" timestamp and actually move it? Or, can you post a link to where you found that image? Thanks.

I want to do the same in MS Access

https://youtu.be/0rVvLNreuv4

Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
I want to do the same in MS Access

https://youtu.be/0rVvLNreuv4

Sent from my HUAWEI NXT-L29 using Tapatalk
Hi. Thanks. That helps explain what you're talking about. Reading some information from their website, I understood dynamic stamps are JavaScripts installed on your copy of Acrobat. If so, you might be able to run these scripts using Acrobat automation. If you're going to do this using VBA, the user must have a full version of Acrobat installed on their machine because you'll probably have to use Acrobat API.
 

Alhakeem1977

Registered User.
Local time
Today, 14:41
Joined
Jun 24, 2017
Messages
308
Hi. Thanks. That helps explain what you're talking about. Reading some information from their website, I understood dynamic stamps are JavaScripts installed on your copy of Acrobat. If so, you might be able to run these scripts using Acrobat automation. If you're going to do this using VBA, the user must have a full version of Acrobat installed on their machine because you'll probably have to use Acrobat API.
But I think as Arnelgp explained:

create an Image of this pdf.

create a report on access and insert the pdf-Image.

then add a Label/texbox to this report.

And I need to save it in a specific folder. D:/Work in progress

Unfortunately, I can't create a VBA code to do this process.

If any body can help me for that

Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:41
Joined
Oct 29, 2018
Messages
21,357
But I think as Arnelgp explained:

create an Image of this pdf.

create a report on access and insert the pdf-Image.

then add a Label/texbox to this report.

And I need to save it in a specific folder. D:/Work in progress

Unfortunately, I can't create a VBA code to do this process.

If any body can help me for that

Sent from my HUAWEI NXT-L29 using Tapatalk
Oh, I'll let Arnel explain his approach then. I thought you were trying to manipulate an existing PDF file.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:41
Joined
May 7, 2009
Messages
19,169
here is a starter (experiment if you wish) on how to save pdf as image:
https://myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html

on the report part, add an image control (blank).
stretch it to the entirety of the page.
add your recordsource (the table).
add the fields you need in the report.
set the field's position to "Bring to Front".
set the transparent background of the textbox.

on the Load event of the report
set the Picture property of the image to the path+filename of the picture you converted from acrobat.
 

Users who are viewing this thread

Top Bottom