Edward S Zuris
edzedz at comcast.net
Tue Apr 29 12:50:53 CDT 2008
This looks like a more challenging project and
should command a higher rate.
I wrote a system to allow end users how to create
forms on the fly. It was hard work and ended up
using everything as text boxes because there are
different rules for each of the items to place
on a form.
For example this is how a label was emulated:
sData = ""
sData = "=" & Chr$(34) & Trim$([rsData]![zData] & " ") & Chr$(34)
Though in the end user had to struggle with
learning various database concepts.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka
Sent: Tuesday, April 29, 2008 9:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Form system
There would be 4 types of users with this system:
Developer
Document Control
Document Developer
User
I'm seriously considering making this an open source system, so the
developer user would have the complete source code to make any custom
changes to the system they would want.
The document control user has the ability to set what revisions are
active, and to monitor the revisions of each form. Skill level: needs to
be able to click links in a web page.
The document developer user has the ability to create forms. This is
probably the most 'intensive' as far as skill goes, but it's really not
that complicated. http://www.marlow.com/marlowforms/formcreation.htm is
a static page for a form my initial target user created. This is a
'saved' html version of a dynamic page, so none of the links or buttons
are going to work on this link. But you'll see that the top part is the
main menu link, then a link fields (process I just completed, which will
allow tracking and searching across multiple revisions of a form), then
the ability to change the form's caption and revision. Next is a spot
to create a new section. A button to preview the form (I saved an html
version of this at http://www.marlow.com/marlowforms/formview.htm ).
After that, it's the sections that this user created. Each section has
controls so the user can change the column widths (percentages), add
columns or rows, edit section settings (label, border, etc), and then
within each 'cell', there is an Add Field link, which lets this user add
a field to this cell. I have the following field types in the system:
Label - Non data-based control
Textbox - Text data stored in a text field, and uses a textbox control
Date Field - Date data, form usings a calendar control for data entry
Memo Field - Text data stored in a memo field, uses a Text Area control
Check Boxes - boxes allowing multiple selections
Radio Buttons - only allows one selection at a time
Combo Box - Text data using a combo box control (data displayed comes
from 'data lists' which users can change when they want)
Abbreviated Combo Box - save as above but the lists have two values,
full value and an abbreviated value
Approval Box - Electronic signature control, requires a valid NT account
name and password to 'approve' (or deny).
Approval Box - Section Locking - same as above, but once approved, the
section this control is in is 'locked' to prevent any changes to the
data.
Line Break - a non data-based formatting control (to create line breaks
within the same cell)
The User, would simply get a form to fill out, which would look like
that second link I posted.
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Tuesday, April 29, 2008 10:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Form system
Drew, that sounds fascinating. I'm not clear though on what kind of
users this is for - sounds like a certain level of computer
sophistication is needed just to be a competent user. What was the
inspiration for this? And, yes, if you do put up a demo of it, I will
go explore it. Thanks for telling us about it.
Tina
Drew Wutka wrote:
> Had a pretty big project that got delayed for a few months, due to
other
> pressing matters, but now I have gotten back into it, and I am close
to
> finishing it.
>
>
>
> It's a Form system. Not an 'Access Form' system, but a 'paperless'
form
> system. It's setup to allow the user to create a form, with various
> 'fields/controls'. Allows for form revisions. Data Entry, viewing,
and
> even 'historical' viewing (it shows you who changed what in a form
entry
> and when) (Will be adding rollback capability too). Electronic
> signatures (using NT authentication). Revision control (who can
create
> a revision and who can activate a revision can be setup in the system,
> so this system maintains document control.)
>
>
>
> What I am finishing up is a 'tracking system' and search capability.
> (the trick is 'matching' the fields between different revisions).
>
>
>
> Anywho, I was wondering if this is something anyone else on the list
> would be interested in. When it's ready, I could setup a 'demo' site
> (it's web based). But I don't want to take the time to do that if
> there's no interest in this.
>
>
>
> Drew
>
>
> The information contained in this transmission is intended only for
the person or entity to which it is addressed and may contain II-VI
Proprietary and/or II-VI Business Sensitive material. If you are not the
intended recipient, please contact the sender immediately and destroy
the material in its entirety, whether electronic or hard copy. You are
notified that any review, retransmission, copying, disclosure,
dissemination, or other use of, or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited.
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the
person or entity to which it is addressed and may contain II-VI Proprietary
and/or II-VI Business Sensitive material. If you are not the intended
recipient, please contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. You are notified that any
review, retransmission, copying, disclosure, dissemination, or other use of,
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com