UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Word Vs. Excel For Fill-out-able Forms, Office 2010    
 
   
doctor9
post Oct 28 2011, 03:28 PM
Post #1

UtterAccess Editor
Posts: 12,732
From: Wisconsin



For the last eight years I've maintained a database of calibrations for my laboratory. That database included about 40 reports, which were calibration forms that needed to be printed out, then filled out, then filed. Now another person is taking over that particular database, and he'd like to change from the old "database report that's printed and written on" method that I've used and move to using Word for the calibration forms instead.
The main reason - he finds Word easier to edit, and I agree. I can easily change from a "print report x" methodology to an "open Word file x" logic in the database. But he'd also like to use Word fields to allow the users to fill out the calibration forms within Word, rather than printing the calibration form and filling it out with a pencil. At this point, I suggested Excel instead. I personally find Excel to be better for this sort of thing than Word. Just merge cells and mark some as Locked, and the user can Tab from blank to blank and fill them out.
Either way, the user would be opening some sort of protected template, either Word or Excel. Then they'd fill out the appropriate blanks in the form, and save the file in a special folder.
This is the early stage of the transition process, so I'm curious... Any recommendations on using either Word or Excel for this sort of thing?
Dennis
Go to the top of the page
 
+
CyberCow
post Oct 29 2011, 08:22 AM
Post #2

UdderAccess Admin + UA Ruler
Posts: 19,094
From: Upper MI



Dennis,
While many of us know that either tool is suitable and more than adequate for the task you've described, I believe it becomes a matter of taste based on who's responsible for the final decision. "You say 'tomato' I say 'bowling shoes'."
In my estimation (and based on my experience with high volume reporting), I would maintain an Access db to provision the forms and fields in which the user would fill in the blanks; storing that data IN the db. Then, instead of using Access reports to produce the final product, I would merge the results with Word and all the fun that goes with bookmarking all points in a Word template to generate the resultant Word document from within the Access app. This is what we did at General Electric for the 84 page report that had to accompany each sensor rod they produced for mounting inside the walls of cooling stacks at nucluear power plants. They liked the WOrd documents because they easily pass those around to all the approving departments before final approval; and the Access db made it easy to track which document went with which rod, and who signed off on each step in its manufacturing process.
But that's just my opinion. I'm curious how others will chime in.
(It was me who moved this thread to this forum - it wasn't just interface, or word or excel or automation, so this seemed the best forum to put it.)
Go to the top of the page
 
+
Aquadevel
post Oct 29 2011, 08:44 AM
Post #3

UtterAccess VIP
Posts: 6,902
From: Earth...



Hi Doc,
Have you looked into possible use of PDFill PDF Editor? I'm using it to as an attachment to emails to get data.
Just thought i'd give ya the option.
Good luck with your project!
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 30th October 2014 - 11:47 PM