A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Standardized Forms



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2010, 07:46 PM posted to microsoft.public.access.forms
ElijahTurner
external usenet poster
 
Posts: 1
Default Standardized Forms

Is there a way to use pre-made/standardized forms in access? For example, I'm
in the army and we have a lot of processing forms that are standardized (i.e.
DA forms, and DoD forms) and it would be convenient if you could scan in one
of those forms, make it fill able and use the tables information to fill it.
Is this possible? If not through access are there any software’s that could
do this? Thank you for the help.
  #2  
Old February 16th, 2010, 08:02 PM posted to microsoft.public.access.forms
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Standardized Forms

hi Elijah,

On 16.02.2010 19:46, ElijahTurner wrote:
Is there a way to use pre-made/standardized forms in access? For example, I'm
in the army and we have a lot of processing forms that are standardized (i.e.
DA forms, and DoD forms) and it would be convenient if you could scan in one
of those forms, make it fill able and use the tables information to fill it.
Is this possible? If not through access are there any software’s that could
do this? Thank you for the help.

Yes, you can do it. Use the scanned form as background image and place
the necessary TextBoxes onto it.

mfG
-- stefan --
  #3  
Old February 16th, 2010, 08:21 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Standardized Forms

On Tue, 16 Feb 2010 10:46:01 -0800, ElijahTurner
wrote:

Is there a way to use pre-made/standardized forms in access? For example, I'm
in the army and we have a lot of processing forms that are standardized (i.e.
DA forms, and DoD forms) and it would be convenient if you could scan in one
of those forms, make it fill able and use the tables information to fill it.
Is this possible? If not through access are there any software’s that could
do this? Thank you for the help.


In order to have something that you can print out and hand or mail to someone,
you will need to create Access Reports. There's no way for Access, by itself,
to recognize the lines and labels on a scanned image; what you will need to do
is to base the report on a query retrieving the necessary information, use the
image as the background for a Report in report design, and put textboxes onto
the report lined up with the proper positions on the image. Tedious but
doable!
--

John W. Vinson [MVP]
  #4  
Old February 16th, 2010, 11:57 PM posted to microsoft.public.access.forms
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Standardized Forms

I just did a database with lots of these forms for an army guy. I ended up
making routines to import and
export the excel documents (using Excel automation) and certain reports
were also created to
mimic the look/feel of the original excel documents. I ended up doing it
the regular way of
drawing boxes and placing fields (very boring). Hire someone to do it just
so you don't go insane from the boredom.

So options are (in my opinion):
- reports that mimic look/feel of original
- excel automation to populate a blank excel form
- both report and excel options

If it's a form based on Microsoft Word you could do a word merge approach.

Let me know which ones you are trying to do (possibly a slight chance I did
them already).
I was working with a database for discrepancy and injury related forms.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com




"ElijahTurner" wrote in message
...
Is there a way to use pre-made/standardized forms in access? For example,
I'm
in the army and we have a lot of processing forms that are standardized
(i.e.
DA forms, and DoD forms) and it would be convenient if you could scan in
one
of those forms, make it fill able and use the tables information to fill
it.
Is this possible? If not through access are there any software’s that
could
do this? Thank you for the help.


  #5  
Old February 17th, 2010, 12:22 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Standardized Forms

On Tue, 16 Feb 2010 10:46:01 -0800, ElijahTurner
wrote:

Is there a way to use pre-made/standardized forms in access? For example, I'm
in the army and we have a lot of processing forms that are standardized (i.e.
DA forms, and DoD forms) and it would be convenient if you could scan in one
of those forms, make it fill able and use the tables information to fill it.
Is this possible? If not through access are there any software’s that could
do this? Thank you for the help.


One point to bear in mind: the ultimate goal is that the recipient get the
*INFORMATION* on the form, in a way that is convenient to read and use.

Sometimes this means precisely matching some paper form devised in 1971 by a
bored bureaucrat. But that might not be the only option.

In a rational world, the information would be transmitted electronically from
your database into the recipient's database, without the requirement of
printing it to paper and then laboriously retyping it... but I fear we're not
yet in a rational world. The closest we're likely to get is that an
approximation of the official form would be acceptable.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.