473,598 Members | 3,458 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Filling Interactive PDF with VBA from Access

74 New Member
I have a database that stores all information for customers. In order to comply to our quality program, we have to measure customer satisfaction. I have created an interactive PDF for them to drop down and fill in there levels of satisfaction with us. When they have completed it, they simply click the submit button.

The database that stores all of the customers information is the same database that we create the document packages (prints reports to PDF, or copies scanned PDF's) and joins the package together (with the help of pdf toolkit, higly recommended if you are doing the same type of functions).

On the survey (one PDF page) when the customer clicks the submit button, all it does is send XML data back to my email address. Which I import back into the customer satisfaction module of the database.

The problem is that i try to make the form as unintrusive as possible, because customers dont like to be bothered with things like surveys. So I would like to know if anybody knows anything about preloading information (customer name, address, contact info) into the interactive fields on the pdf, so that they dont have to do it. I have access to all of the information in access (2007). I have no problem copying the survey with code, and merging it with my other forms via code, but I dont even know where to start with filling in the form.

I looked at some stuff on the net, but didnt seem very helpful. If anybody has a starting place, it will be very appreciated. Thanks guys.

I have attached a modified form (removed my email address, lol) for you to work/experiment with. If you try to edit the pdf, you will need pdf livecycle...
Attached Files
File Type: zip CustSurvey.zip (76.2 KB, 77 views)
Dec 9 '10 #1
0 1377

Sign in to post your reply or Sign up for a free account.

Similar topics

11
12070
by: Google Mike | last post by:
I've got RH9 Linux with default PHP. Is there a way to send email on Linux to an Exchange Server from PHP and/or other tools when there is *NOT* SMTP access? Has anyone figured out a way to use PHP to get inside an OWA (Microsoft Outlook Web Access) website to send email that way? The reason I ask is because my corporate office is going to do away with our rogue SMTP server access and force everything through Exchange
7
2309
by: jason | last post by:
Is there a way - possibly a disconnected rs? - to update the contents of an existing pulldown on a page without having to re-submit the page for the user to see the pulldown populated with an additional value? I realise there are javascript possibilities (and I am still searching for a usable one) but I thought perhaps it may be possible to allow a user to add a new entry to a drop down box that had been dynamically populated from an...
3
4599
by: Lubomir | last post by:
Hi, I read that interactive windows services will not be allowed to run under Wista. I would like to ask what exactly is the interactive service. It is supposed to be a service that communicates with desktop. What about the following scenario: A service will create a thread. This thread will create and run an UI Windows application that manages task bar and so on on a desktop. This application will communicate with the service: a/ by...
22
6251
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one client (MS Access vs ..NET Windows Forms) would be preferred over the other. While I have some good arguments on both sides, I would appreciate your points of view on the topic.
2
1792
by: GarthRodgers | last post by:
Hey all I'm designing an online exam booking system in Access and need to find a way to import table data into Roboform (or some other form filling package) straight from the database. The only two options I can think of are exporting the table as an XML or as a data access page, and taking it from there, but being new to access I'm not entirely sure how these formats work. So, is there any way that data stored within my access database...
1
1194
by: salmobytes | last post by:
I've been asked to create a website where various office secretaries, in a university biology department, can update selected pages by filling out forms. In other words where privileged users upload ascii text to templating system of some kind. My options: I could try to roll this from scratch. I could use Textpattern I could use Drupal (written in php..........)
3
1876
by: R. Bernstein | last post by:
The next release of pydb will have the ability to go into ipython from inside the debugger. Sort of like how in ruby-debug you can go into irb :-) For ipython, this can be done pretty simply; there is an IPShellEmbed method which returns something you can call. But how could one do the same for the stock python interactive shell? To take this out of the realm of debugging. What you want to do is to write a python program that goes...
6
1354
by: Ulrich Dorda | last post by:
I've got a probably embarrassing trivial problem with namespaces, but couldn't solve it myself nor find an answer in the net. Hopefully one of you guys can help me. What I want to do: Use the interactive shell and e.g define the variable a there. Then load a module and access a from within. e.g file "utest.py" def doit():
2
3067
by: Toni Pohl | last post by:
Hi, some years ago I´ve implemented an classic ASP form which fills in data from a database into a PD-form. I used the free FDF Toolkit which worked very well. After submitting the PDF the asp-form reads the data of the datafields and write them into the database again. Now I want to implement an improved ASP.NET version with VB.NET and I found iText.net. - FDF seems to be completly outdated?
0
1503
by: Diana Miller | last post by:
Hi All, I have created an interactive Access 2007 report where the user selects a date from a combo box and results are shown. I would like to know how I can share this report interface so that other users can only use the report interface and not modify it (no access to any other views, i.e design view). Is there a way to do this? Any help is greatly appreciated. -Diana
0
7991
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8395
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8398
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8265
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6719
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5438
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3939
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2412
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1250
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.