X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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

UtterAccess Editor
Posts: 18,324
Joined: 29-March 05
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?
Go to the top of the page
post Oct 29 2011, 08:22 AM

UdderAccess Admin + UA Ruler
Posts: 19,557
Joined: 27-April 02
From: Upper MI

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
post Oct 29 2011, 08:44 AM

UtterAccess VIP
Posts: 6,902
Joined: 8-August 05
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

Custom Search
RSSSearch   Top   Lo-Fi    27th May 2018 - 08:23 PM