Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Need advice on how to create a form overlay
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Need advice on how to create a form overlay
Need advice on how to create a form overlay
28-10-2008 9:02 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi all,
I need some advice/pointers on the best way forward.
We have an expense form at work that needs to be completed regularly and so to save some time for everyone I would like to create either a word, excel, or pdf document that can be completed, the form loaded on a printer and the output printed over the top.. I would not be in a position to load any additional software which is why it must be one of the formats i have specified.
what i have tried so far is with a word document, adding the form itself as a non printable watermark background but I then have trouble aligning the text to the boxes on the form...
So i would appreciate any advice
I need some advice/pointers on the best way forward.
We have an expense form at work that needs to be completed regularly and so to save some time for everyone I would like to create either a word, excel, or pdf document that can be completed, the form loaded on a printer and the output printed over the top.. I would not be in a position to load any additional software which is why it must be one of the formats i have specified.
what i have tried so far is with a word document, adding the form itself as a non printable watermark background but I then have trouble aligning the text to the boxes on the form...
So i would appreciate any advice
5 REPLIES 5
Re: Need advice on how to create a form overlay
28-10-2008 9:15 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Create the expenses form either as an Excel or Word template.
Excel may be easier as you can add macro buttons to send it to the printer. Also you can set it up so that, having filled in one cell, it automatically goes to the next one in the template. The user could also save the completed form for their records
Excel may be easier as you can add macro buttons to send it to the printer. Also you can set it up so that, having filled in one cell, it automatically goes to the next one in the template. The user could also save the completed form for their records
Re: Need advice on how to create a form overlay
28-10-2008 10:49 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'd agree with OldJim, but definately do it using Excel, and preferably with macros to control it. Lock all cells except where the user inputs data, etc etc. .
Re: Need advice on how to create a form overlay
28-10-2008 3:03 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'd use publisher and text boxes myself, It comes with most versions of M$ Office, although you say you have PDF writing facility, if its acrobat pro v9 or above it comes with Adobe Designer, which might work out better (only played with it a little bit, but It seemed it was for almost exactly what you are looking for.)
Re: Need advice on how to create a form overlay
28-10-2008 3:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Maybe if you just want to have people write text, but as it's an expenses form - it's good to use the arithmetic features that adds columns etc, does VAT calculations and with macros you can set it up to use account codes, cost centres, on drop down boxes etc so people only enter valid code, and then you can extract data to consolidation files etc etc.
Re: Need advice on how to create a form overlay
28-10-2008 11:24 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I dont understand the logic here. You have a blank form and you want to try and print the input onto a form, this is very dodgy to do due mostly to getting the paper lined up.
Why cant you create a form in word, excel etc and then just print it out as this seems to be the simple way of doing it you only have to create a form once with text boxs for user to input data
Why cant you create a form in word, excel etc and then just print it out as this seems to be the simple way of doing it you only have to create a form once with text boxs for user to input data
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Need advice on how to create a form overlay