Go Back   Access World Forums > Apps and Windows > Visual Basic

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-22-2019, 12:07 PM   #16
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,609
Thanks: 50
Thanked 1,052 Times in 1,033 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Add text into a pdf file within a form in MS Access

Quote:
Originally Posted by Alhakeem1977 View Post
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.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 08-22-2019, 12:09 PM   #17
Alhakeem1977
Newly Registered User
 
Join Date: Jun 2017
Posts: 190
Thanks: 88
Thanked 0 Times in 0 Posts
Alhakeem1977 is on a distinguished road
Re: Add text into a pdf file within a form in MS Access

Quote:
Originally Posted by theDBguy View Post
Oh, I'll let Arnel explain his approach then. I thought you were trying to manipulate an existing PDF file.


Sent from my HUAWEI NXT-L29 using Tapatalk
Alhakeem1977 is offline   Reply With Quote
Old 08-22-2019, 12:19 PM   #18
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,401
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Add text into a pdf file within a form in MS Access

here is a starter (experiment if you wish) on how to save pdf as image:
https://myengineeringworld.net/2013/...iles-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.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Alhakeem1977 (08-22-2019)
Old 08-22-2019, 12:28 PM   #19
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,609
Thanks: 50
Thanked 1,052 Times in 1,033 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Add text into a pdf file within a form in MS Access

Quote:
Originally Posted by Alhakeem1977 View Post


Sent from my HUAWEI NXT-L29 using Tapatalk
Good luck!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Alhakeem1977 (08-22-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
append records to existing access db from text file via access via cirugio Modules & VBA 10 10-28-2016 09:00 PM
How to import a fixed width text file into access using Form/VBA/Macro keithaul Modules & VBA 7 07-27-2016 08:46 PM
"Importing TEXT file" to Access | Issue - Long file name Ramya_mudambi Modules & VBA 1 01-08-2014 08:44 AM
How to put text file in Access DB form gear General 1 04-12-2007 06:45 AM
[SOLVED] Import Text File into Access Then Delete the Text File tiomin Macros 3 10-04-2004 05:53 AM




All times are GMT -8. The time now is 02:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World