Drew Wutka
DWUTKA at Marlow.com
Tue Apr 29 11:30:37 CDT 2008
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.