473,722 Members | 2,216 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Electronic Forms software that integrates well with Access

I am looking for electronic forms software that would integrate well
with MS Access.

I have a client for whom I built a client database to replace and update
one they had that was obsolete and not doing what they want.
They are wanting to move on to the next step and automate most of their
forms. some are boilerplate forms that are simple printed without
change. some are boilerplate but require signatures from client and
rep. Others provide for entry of quite a bit of data.

All forms will be filed manually in hardcopy (yes I am trying to bring
them into the 20th century, but then they quote Federal Goverment
requirements... ). Some of the data from the forms will need to
preferably be populated from the database, name, phone, etc. Some forms
will have a few fields recorded to the database as well as the form.
Some forms will have many fields recorded to the database.

Obviously it would be desirable to keep the completed forms accessible
electronically (and hopefully the long term repository once we get rid
of all the paper files).

Anyone have suggestions for software that have used for something
similar with good success?

The client is a nonprofit so price is a factor.

Bob
Jul 21 '06 #1
9 2099
"Bob Alston" wrote
I am looking for electronic forms software
that would integrate well with MS Access.

I have a client for whom I built a client database to replace and update
one they had that was obsolete and not doing what they want.
They are wanting to move on to the next step and automate most of their
forms. some are boilerplate forms that are simple printed without change.
some are boilerplate but require signatures from client and rep. Others
provide for entry of quite a bit of data.

All forms will be filed manually in hardcopy (yes I am trying to bring
them into the 20th century, but then they quote Federal Goverment
requirements... ). Some of the data from the forms will need to preferably
be populated from the database, name, phone, etc. Some forms will have a
few fields recorded to the database as well as the form. Some forms will
have many fields recorded to the database.

Obviously it would be desirable to keep the completed forms accessible
electronically (and hopefully the long term repository once we get rid of
all the paper files).

Anyone have suggestions for software that have used for something similar
with good success?

The client is a nonprofit so price is a factor.
Just about any information that you can capture on a paper form, you can
capture on an Access Form -- and Access has the capability to create Forms,
so I can't guess why anyone would need "forms software to integrate with
Access." Presumably, the forms in question would be specific to a particular
user organization, or industry, or sector, or ??? and would have to be
"custom forms" even if you used some "forms software."

The exceptions to "easy capture" are hand-drawn diagrams and handwriting.

I've seen one application that used the user's USERID to look up and insert
a filed signature image (the network login ID could also be used, or the
user required to enter name/password), and others that used various forms of
electronic signature validation. Whatever the "authority" requiring the
signatures has specified would determine the approach you could use -- and,
if storing a paper copy is required, it may be that a physical signature on
that paper copy is what's needed.

Larry Linson
Microsoft Access MVP
Jul 21 '06 #2

Larry Linson wrote:
"Bob Alston" wrote
I am looking for electronic forms software
that would integrate well with MS Access.

I have a client for whom I built a client database to replace and update
one they had that was obsolete and not doing what they want.
They are wanting to move on to the next step and automate most of their
forms. some are boilerplate forms that are simple printed without change.
some are boilerplate but require signatures from client and rep. Others
provide for entry of quite a bit of data.

All forms will be filed manually in hardcopy (yes I am trying to bring
them into the 20th century, but then they quote Federal Goverment
requirements... ). Some of the data from the forms will need to preferably
be populated from the database, name, phone, etc. Some forms will have a
few fields recorded to the database as well as the form. Some forms will
have many fields recorded to the database.

Obviously it would be desirable to keep the completed forms accessible
electronically (and hopefully the long term repository once we get rid of
all the paper files).

Anyone have suggestions for software that have used for something similar
with good success?

The client is a nonprofit so price is a factor.

Just about any information that you can capture on a paper form, you can
capture on an Access Form -- and Access has the capability to create Forms,
so I can't guess why anyone would need "forms software to integrate with
Access." Presumably, the forms in question would be specific to a particular
user organization, or industry, or sector, or ??? and would have to be
"custom forms" even if you used some "forms software."

The exceptions to "easy capture" are hand-drawn diagrams and handwriting.

I've seen one application that used the user's USERID to look up and insert
a filed signature image (the network login ID could also be used, or the
user required to enter name/password), and others that used various forms of
electronic signature validation. Whatever the "authority" requiring the
signatures has specified would determine the approach you could use -- and,
if storing a paper copy is required, it may be that a physical signature on
that paper copy is what's needed.

Larry Linson
Microsoft Access MVP
Thanks for the reply. I'm just looking for something that would be
simpler to convert the existing forms to electronic format. Also I
think only a small portion of the date entered into the forms will need
to go into the Access database.

And yes I could build everything with Access Forms capabilities. But
in this case, I am hoping there is an easier solution.

Bob

Jul 21 '06 #3
<bo*******@gmai l.comwrote
Thanks for the reply. I'm just looking
for something that would be simpler to
convert the existing forms to electronic
format. Also I think only a small portion
of the date entered into the forms will need
to go into the Access database.
And yes I could build everything with
Access Forms capabilities. But in this
case, I am hoping there is an easier solution.
All the Forms software I looked at was no easier than Access Forms, but all
of it provided less functionality. That was a few years ago, so the
"universe" of Forms software could have changed since then. I wish you
better luck.

Larry Linson

Jul 21 '06 #4
bo*******@gmail .com wrote:
Larry Linson wrote:
>>"Bob Alston" wrote
I am looking for electronic forms software
that would integrate well with MS Access.
>>>I have a client for whom I built a client database to replace and update
one they had that was obsolete and not doing what they want.
They are wanting to move on to the next step and automate most of their
forms. some are boilerplate forms that are simple printed without change.
some are boilerplate but require signatures from client and rep. Others
provide for entry of quite a bit of data.

All forms will be filed manually in hardcopy (yes I am trying to bring
them into the 20th century, but then they quote Federal Goverment
requirements ...). Some of the data from the forms will need to preferably
be populated from the database, name, phone, etc. Some forms will have a
few fields recorded to the database as well as the form. Some forms will
have many fields recorded to the database.

Obviously it would be desirable to keep the completed forms accessible
electronical ly (and hopefully the long term repository once we get rid of
all the paper files).

Anyone have suggestions for software that have used for something similar
with good success?

The client is a nonprofit so price is a factor.

Just about any information that you can capture on a paper form, you can
capture on an Access Form -- and Access has the capability to create Forms,
so I can't guess why anyone would need "forms software to integrate with
Access." Presumably, the forms in question would be specific to a particular
user organization, or industry, or sector, or ??? and would have to be
"custom forms" even if you used some "forms software."

The exceptions to "easy capture" are hand-drawn diagrams and handwriting.

I've seen one application that used the user's USERID to look up and insert
a filed signature image (the network login ID could also be used, or the
user required to enter name/password), and others that used various forms of
electronic signature validation. Whatever the "authority" requiring the
signatures has specified would determine the approach you could use -- and,
if storing a paper copy is required, it may be that a physical signature on
that paper copy is what's needed.

Larry Linson
Microsoft Access MVP


Thanks for the reply. I'm just looking for something that would be
simpler to convert the existing forms to electronic format. Also I
think only a small portion of the date entered into the forms will need
to go into the Access database.

And yes I could build everything with Access Forms capabilities. But
in this case, I am hoping there is an easier solution.

Bob
OK I am now trying to find ways to do this with native Access forms.
I am still hoping to avoid setting up individual text boxes for all the
form instructions and boilerplate content.

Here is a link to a sample goverment defined form:

http://www.ltca.org/ADvantage/Documents/ADv5.pdf

and

http://www.ltca.org/ADvantage/Documents/ADv6a1b.pdf

I noticed that some of the forms packages, took an image of the pager
form and then allowed you to draw data fields on top of that. I got a
PDF version of the goverment mandated forms. Converted to JPG at high
resolution (Used 300 resolution when converting PDF to JPG). Created a
large image in an Access form and set the source as the JPG file. On
the screen the characters are not crisp but when printed the quality is
fine. Used 300 resolution when converting PDF to JPG.

And yes I can create fields that have transparent backgrounds and define
the fields where I want data entered.

Anyone done this before? Any tips and tricks?

Right now it appears I may need to slightly trim the JPG file to avoid
page overflow.

Should I use a format other than JPG?

Other suggestions?

Thanks

Bob
Jul 22 '06 #5
Bob Alston <bo********@yah oo.comwrote in
news:5k******** *********@fe05. lga:
Should I use a format other than JPG?
Definitely.

Use a bitmap, as the JPG is converted to a bitmap before
storing, so you end up storing both the JPG and the bitmap, when all
you need is the bitmap.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jul 22 '06 #6
David W. Fenton wrote:
Bob Alston <bo********@yah oo.comwrote in
news:5k******** *********@fe05. lga:

>>Should I use a format other than JPG?


Definitely.

Use a bitmap, as the JPG is converted to a bitmap before
storing, so you end up storing both the JPG and the bitmap, when all
you need is the bitmap.
Thanks. I just noticed that using a JPG for the image results in the
same kind of 50 meg overhead in the database that addition of JPG images
in a Jet database does.

Bob
Jul 22 '06 #7
Bob Alston wrote:
David W. Fenton wrote:
>Bob Alston <bo********@yah oo.comwrote in
news:5k******* **********@fe05 .lga:
>>Should I use a format other than JPG?

Definitely.
Use a bitmap, as the JPG is converted to a bitmap before
storing, so you end up storing both the JPG and the bitmap, when all
you need is the bitmap.

Thanks. I just noticed that using a JPG for the image results in the
same kind of 50 meg overhead in the database that addition of JPG images
in a Jet database does.

Bob
Another question. Should I define the bitmapped image in the form
definition or use the approach to load the bitmap from a file at run
time into the blog control at run time, as is suggested for handling
pictures in databases to avoid the "OLE overhead"?

Bob
Jul 22 '06 #8
Bob Alston <bo********@yah oo.comwrote in
news:k%******** *****@fe03.lga:
Another question. Should I define the bitmapped image in the form
definition or use the approach to load the bitmap from a file at
run time into the blog control at run time, as is suggested for
handling pictures in databases to avoid the "OLE overhead"?
It depends. If you load it from disk, it will be slower, but won't
bloat the database. But then you also end up with more files needed
to run your app. I generally go with embedding in the form, since I
don't see any point in worrying about bloat of this kind.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jul 23 '06 #9
"Bob Alston" <bo********@yah oo.comwrote
Converted to JPG at high resolution (Used
300 resolution when converting PDF to JPG).
Created a large image in an Access form and
set the source as the JPG file. On the screen
the characters are not crisp but when printed
the quality is fine. Used 300 resolution when
converting PDF to JPG.

And yes I can create fields that have transparent
backgrounds and define the fields where I
want data entered.

Anyone done this before? Any tips and tricks?
I scanned in "official" forms for a prototype application back in Access 1.1
or 2.0 days, to use as background for a report. Images required just as
much processing then, as now, but my processor was only 33MHz. <SIGHIt
took approximately forever to do anything with the report once I'd embedded
the image. So I started over without the image, created the Controls first,
tried to use a printed copy with a copy of the form held up to the light to
locate them as closely as I could, then embedded the image, and suffered
through the slowness on the final tweaking. Fortunately, with today's
processors running at 3.x GHz, and much faster graphics cards, you are
unlikely to face similar problems.

Turns out I hadn't properly "qualified" the client (who'd sought me out at a
user group meeting) and he had expected custom software at shrinkwrap
prices, so it was all for naught, anyway. I wrote off the cost of scanning
(scanners were pretty expensive back then, so I paid someone to scan the
forms) as a marketing expense.
Should I use a format other than JPG?
David already answered this one, and answered it very well indeed.

Larry Linson
Microsoft Access MVP
Jul 23 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1916
by: C. Smith | last post by:
I am technical advisor for a new group of middle-aged people that want to create a web site for historical information about our local area. They want to scan in a lot of old photos, include information on schools, cemetaries, etc. The web server is NT4 running IIS 4.0. Pages are uploaded via FTP. I personally use Dreamweaver 3, and am learning Dreamweaver MX. I feel that Dreamweaver is too much for this group to learn. I had early...
1
334
by: eazycode | last post by:
visit http://www.eazycode.com Introducing a unique product "EazyCode", that can do coding/programming for you at the click of a button, in a matter of seconds. What is EazyCode? EazyCode is a RAD tool that integrates into Visual Studio .NET and helps you develop and maintain front-end GUI of database applications. EazyCode is a powerful code-generation tool that creates ready-to-use database-driven
1
1700
by: Brad L. Meyer | last post by:
Hi all! Happy Holidays to all! I work for a nonprofit 501.3.c case management agency. All of the computers have MS ACCESS database software installed. Is it possible to recreate agency forms in access (complete with logos) and have Access complete needed forms? For example: We take some identifing information at the first contact.
2
1906
by: Hank Reed | last post by:
I found only five small threads discussing Access and EDI and none of them were very recent. Is anyone interfacing with EDI using Access? Can anyone recommend a book that would explain the basics of EDI? This is all driven by a potential customer that requires EDI capability. Hank Reed
0
1043
by: Mark Rae | last post by:
Hi, I've been asked to do some analysis on a workflow system, specifically with electronic authorisation / signature. E.g. User A logs in and initiates a timesheet, fills it in and "submits" it. The system already knows that User B is User A's supervisor, so it sends User B an email to say that he has a new timesheet to authorise.
0
818
by: Nabeel | last post by:
Hi, I am writing a web application where students will fill out and sign forms on the web. How can I capture e-signatures on a web application? Which signature pad hardware/software should i use? Thanks, Nabeel
4
3532
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The objective in utilizing this new deployment method is to reduce the maintenance overhead as well as making it easier for my users to setup and run the application initially. I have VS 2002, Windows XP, Access XP(2000 format). He is my problem....
4
1601
by: Steven | last post by:
Hi, I have to draw a geometric form quite complex, like a car for example. Then, i need to know which part of the car the user has clicked on. In vb6 i would have used the "shapes" component to draw the car and then use a mathemtical formula to test if the user is in or out of the car. In C#, i don't see any componant to draw geometric forms at design time. Is there any ?
1
3243
by: Scott Sandeman-Allen | last post by:
On 5/1/08, Jumping Arne (arnlen@mac.com) wrote: I've been working with Photologue for a while with some nice results. <http://code.google.com/p/django-photologue/> It is a Django project <http://www.djangoproject.com/>, It includes support for tagging:
0
8860
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
9151
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9086
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6680
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5994
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4762
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3207
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2600
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2146
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.