creating form templates
I have created a form template, but I'm very very green at creating templates with Word 2007. Let me explain what I have done and what I still need to do.
I have created 2 pages:
Page 1 - Service Order - on this page I have company name, address, contact, dates, quantity, part #, description, each price and
total price. I have created Legacy Fields for each of these. As well as created toggle fields to total the quantity x each price to get a
total price.
Page 2 - Bill of Lading - on this page of have created toggle fields so that it will automatically populate with the information from the Service Order.
Now with the Bill of Lading once you have the document protected you can't change anything other than enter the quantity you have shipped so that the customer can see what is shipped and what is back ordered. What I would like to see/do is the following:
Is there a way once the form is protected that we could copy and paste information from the Bill of Lading and past it into Excel if need be or vise versa?
Is there an easier/faster way of creating toggle fields to auto population rather than going through and doing it line by line. When this Form Template is finished I need it to be 10 pages long - 150 lines which need to populate on 4 Bill of Ladings. I
wish there was a way I could attach my document so that you can see what I have done.
Please help, I'm so close to creating a form that will create less work for our employees.
Thank you!!
Solutions to the Problem creating form templates
Download Error Fixer for Free Now
There are two ways to do this - the elegant way with a userform to collect and insert the variable data (see
http://www.gmayor.com/Userform.htm to help get you started)
or
with a protected form which is the path you have started upon.
In this case the fields on your first page should be reproduced with REF fields on the subsequent pages and if you check the calculate on exit check boxes of the form fields the REF fields that
are not in the header/footer will be automatically updated.
If you want data in the header footer, you need to use Styleref fields.
As for extracting data from the form, for that you will need a macro.
See
http://www.gmayor.com/ExtractDataFromForms.htm.
The method there produces an Excel compatible comma delimited form, but the principle can be adapted to write directly to an Excel worksheet.
If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.
Recommended Method to Fix the Problem: creating form templates:
How to Fix creating form templates with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the list.
2. After the scan is done, you can see the errors and problems which need to be fixed.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Solution to Error: Constant Interrupt_Exception_Not_Handled blue screen restart,Converting an "ASCII delimited text format" file into Excel 2007 [Solved],[Solution] corrupt WMP windows 7 evrything I try to install get corrupted, plus compatablity problems,Troubleshoot:CPU utilization spikes to 100% randomly,Fast Solution to Problem: Creating a bar chart in Excel 2007,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly
No comments:
Post a Comment