G
Garthe
I work for a State Correctional Facility as the Mailroom Supervisor and
Computer Help Desk Representative.
While Inmate receipts are still being written by hand there is a Stand-Alone-
Computer Receipt System, consisting of a Stand-Alone-Computer, Okaidata 321
Impact Printer, 3 color part copy form fed preprinted/number receipt form,
and Lotus Approach Software, that generates Inmate receipts.
The flaw with the Stand-Alone-Computer is that when it is used each following
day the following days receipt information is lost instead of being captured
in a database.
I am in the process of designing an Access Database that will capture the
data and print the receipts issued for that day. The Challenge is that
Original Receipts have to be issued on the existing Preprinted Receipt Form
while subsequent Duplicate Receipt Copies could be issued on a HP Laser
Printer. Further, assigned numbered receipt book series are issued to
different areas – (Mailroom, Package Room, Business Office e.g.) consequently
the starting number, for an area, could vary daily.
1) I would like to know could a blank receipt be scanned in as a PDF, opened
up in the
Report background so that design Design View individual fields, from the
required
tables, could be over layed then once matched the report could be saved.
The report
then when subsequently run would actually printing on to the Printer
Form Fed
Receipts. Management wants to use the existing form and not a
redesigned new form.
I would design the receipt in a query, (pulling in the needed fields and
how they
should be sorted and grouped) then have Report use it.
2) I want a user to be prompted for the starting receipt number to force
them to have
to physically check the preprinted form for this number, and enter it,
when the
database is opened and before it will proceed to do any receipts. Once
the number is
is entered it will automatically be incremented by 1 and the new
receipt number
placed in the receipt number field.
These are the only two night mares I am facing at the moment with this
project. I welcome any ideas and code suggestions any one wishes to offer to
help me with these
Two areas
Computer Help Desk Representative.
While Inmate receipts are still being written by hand there is a Stand-Alone-
Computer Receipt System, consisting of a Stand-Alone-Computer, Okaidata 321
Impact Printer, 3 color part copy form fed preprinted/number receipt form,
and Lotus Approach Software, that generates Inmate receipts.
The flaw with the Stand-Alone-Computer is that when it is used each following
day the following days receipt information is lost instead of being captured
in a database.
I am in the process of designing an Access Database that will capture the
data and print the receipts issued for that day. The Challenge is that
Original Receipts have to be issued on the existing Preprinted Receipt Form
while subsequent Duplicate Receipt Copies could be issued on a HP Laser
Printer. Further, assigned numbered receipt book series are issued to
different areas – (Mailroom, Package Room, Business Office e.g.) consequently
the starting number, for an area, could vary daily.
1) I would like to know could a blank receipt be scanned in as a PDF, opened
up in the
Report background so that design Design View individual fields, from the
required
tables, could be over layed then once matched the report could be saved.
The report
then when subsequently run would actually printing on to the Printer
Form Fed
Receipts. Management wants to use the existing form and not a
redesigned new form.
I would design the receipt in a query, (pulling in the needed fields and
how they
should be sorted and grouped) then have Report use it.
2) I want a user to be prompted for the starting receipt number to force
them to have
to physically check the preprinted form for this number, and enter it,
when the
database is opened and before it will proceed to do any receipts. Once
the number is
is entered it will automatically be incremented by 1 and the new
receipt number
placed in the receipt number field.
These are the only two night mares I am facing at the moment with this
project. I welcome any ideas and code suggestions any one wishes to offer to
help me with these
Two areas