Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can I fill a form and archive it? Difficult project need help -

I appreciate any help anyone can offer with this project including someone
who I can hire to get the task done because I'm not sure I'm up to this level.

I have an event which requires a liability form be signed by the
participants. One by one I wish to have a participant view the liability form
on my laptop screen. I wish to have to peripheral devices fill appropriate
fields in this form.

First -- I have a magnetic card reader (which puts data in excel with a
simple swipe no problem) that I will swipe a driver's license -- The data
includes delimited Name, Address, Age, and driver's license number --- which
I want to fill the appropriate fields at the top of the waiver form.

Second -- upon viewing the form which has been personalized -- the
participant would sign on the second peripheral -- an electronic signature
pad which I don't have yet but assume it's a TWAIN compliant capture device
which should then populate a signature field at the bottom of the form.

Third -- I need to archive that completed form as a graphic -- in addition,
the scanned demographic data should also be saved in (linked to?) a simple
database for later analysis which can also be saved.

I'm trying to save huge paper waste and make our membership process much
easier -- can anyone help with a method? suggestions on the best program or
programming method? someone who could accomplish this task quickly and
easily? Thanks for considering this.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Can I fill a form and archive it? Difficult project need help -

No expert on this, but a few thoughts inline.

NickHK

"drsilicone" wrote in message
...
I appreciate any help anyone can offer with this project including someone
who I can hire to get the task done because I'm not sure I'm up to this

level.

I have an event which requires a liability form be signed by the
participants. One by one I wish to have a participant view the liability

form
on my laptop screen. I wish to have to peripheral devices fill appropriate
fields in this form.


- You should check the legality of any "signed" liability form in this way.
Dick Grier has a lot of device I/O stuff: http://mvps.org/rgrier/

First -- I have a magnetic card reader (which puts data in excel with a
simple swipe no problem) that I will swipe a driver's license -- The data
includes delimited Name, Address, Age, and driver's license number ---

which
I want to fill the appropriate fields at the top of the waiver form.


- If this works as a keyboard wedge style device (e.g. barcode scanner), as
far as your app is concerned, the input comes from the keyboard. As such,
you can dump the input into a text box and process the charachters from
there. Otherwise it will on the type of device, how it functions and whether
the manufacture supplies any tools/components for interacting with the
device.

Second -- upon viewing the form which has been personalized -- the
participant would sign on the second peripheral -- an electronic signature
pad which I don't have yet but assume it's a TWAIN compliant capture

device
which should then populate a signature field at the bottom of the form.


-Again, depends on what the manufacture provides in the way of components.

Third -- I need to archive that completed form as a graphic -- in

addition,
the scanned demographic data should also be saved in (linked to?) a simple
database for later analysis which can also be saved.


- You can do a Me.PrintForm of the form, although resolution may be a
concern. Other methods are possible, but will depend on you requirements.
- The data staorage would be relatively straight forward, either to the
containing Excel sheet or a DB file file (Access, MySQL etc.). Depends
somewhat on volume of data and degree of analysis required.

I'm trying to save huge paper waste and make our membership process much
easier -- can anyone help with a method? suggestions on the best program

or
programming method? someone who could accomplish this task quickly and
easily? Thanks for considering this.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
adding a form to a VBA project Simon Shaw Excel Programming 5 March 15th 07 03:25 AM
Fill in form to type Item descrictions and costs and fill in funct cradino Excel Worksheet Functions 0 July 16th 06 08:44 PM
Loading a calendar (user form) from another project (personal.xls) Ollie[_2_] Excel Programming 1 September 25th 05 09:33 PM
Difficult project using arrays stakar[_27_] Excel Programming 7 August 19th 04 03:38 PM


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

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

About Us

"It's about Microsoft Excel"