This application allows you to :
Click on the following links for various help :
The system also provides the server-side programs that allow :
Each of the 8 buttons, apart from the 'Line' button, within the 'Add to HTML Form' Frame at the top left corner, when clicked, will display a window asking for various form method attribute values for each of the form elements you wish to add to your form.
Once you have defined the Form method's properties and clicked the 'Add to Form' button, the Form Method will be inserted into your form and the method Name and Type will be inserted into the Method List in the 'Alter Form Layout' frame on the left.
Each of the form Element's properties can be edited, moved or deleted using the
'Alter Form Layout' frame.
To create a new HTML Form go to the 'Form' Pull Down Menu and select 'Create New Form'.
This will display a box asking for the File Name you wish to save your new form as (e.g. form1 will produce an HTML Form form1.html). The box also requires you to enter the desired Title of the New Form that you wish to display at the top of the HTML page. In this box you can also define various form attributes such as the Font size and Justification of the Form Title as well as your desired Form background image.
To edit these Form Attributes in the future simply click on the Header field within the form method list in the 'Alter Frame Layout' box on the left and click the 'Edit Form Method' button.
To open a previously created form, simply select Pull Down Menu 'Form' and select 'Open Form'. Then select the desired form file Name that you wish to open.
This will cause the application to create the HTML Form from the HTML Code contained in the form's Collection which is opened from the Forms Collection text file contained in the local Collections directory.
If however the Form's Collection text file is missing or cannot be found it will instead open the form's HTML file.
However, since the forms Collection is not loaded, you will not have the option of editing the form in any way.
However will still be possible to view the related Database Table for the form and to use the application's reporting methods of viewing graphs and exporting tables to word document reports.
There is no actual need to save an HTML file. The form currently displayed in the 'Current Form' window is always the currently saved HTML file. Any changes you make to the form are dynamically updated to the the currently open form.
The form's Collection containing various data required to edit the HTML Form in the future is also dynamically updated and automatically saved to file within a Collections directory.
You can rearrange the layout of the HTML Forms by moving the methods up and down the form using the 'Move Method Up From' and 'Move Method Down Form' buttons contained within the 'Alter Frame Layout' Frame on the left. To do this simply select the Form Method you wish to move in the Method List. This method list contains each method's user instruction and its type within brackets. With the desired method selected simply click the desired Move Button until it is in the desired position within the HTML Form.
You can also edit each of the HTML Forms by again selecting the Form Method in the Form Method List on the left and pressing the 'Edit Form Method' button. This will cause the form methods attributes to be displayed. You can then edit the method's various attributes and then click the Update button.
It is also possible to simply remove a method from the HTML From by again simply selecting the desired Method to remove from the Method List and clicking the 'Remove Form Method' button.
However it is not possible to remove the Header Field or the Submit Button since these are essential within a HTML Form.
By pressing the 'View Current Form Database Table in HTML' button on the left causes the application to build and display in this HTML Window the Database Table of the currently open form. The table will contain the answers of each of the Form's Questions of the currently open form that have been answered and submitted.
To view the Table of another Form simply open that from in the usual way from the 'Open Form' option within the 'Form' pull-down menu and click on the 'View Current Form Database Table in HTML' button.
In order to view different areas of the table simple use the scroll bars of the web browser window to scroll vertically and horizontally around the table to view various responses to the HTML form.
The application's reporting facility allows you to export a desired table of data of the submitted responses from the currently open HTML form to a Word Document. It also allow the you to view and export single HTML form answers or your own desired text to the same Word document. It's third ability is to view and save to file Pie Charts and Bar Graphs of the HTML Form responses to Check Boxes, Select Pull-Down menus and Radio Button Form elements. Such saved Graphs can then be simply pasted into the same Word report.
To display the Reporter window simply click the 'Report Table Data and Graphs to Word Document' tab at the top-left.
The Reporter window initially displays the table constructor and HTML form response section :
The list-box on the top-left of the frame lists all of the HTML Form's input elements and hence the fields within the database table for that particular HTML Form. By clicking on each item within the list-box the first response for that HTML input element will be displayed in the below frame labelled as 'View Field Answers'. Within this 'View Field Answers' frame you may view each response given to that element in turn by clicking the 'View Next Answer' button. If for some reason you wish to export the currently viewed answer to the currently specified report (the filename of which is specified in the 'Current Word Report Name' text box directly below the answers frame) simply click on the 'Add above text to Word Report' button. If you wish to include this table field in the table in the word report click the 'Add Field To Report Table' within the 'Table Fields' frame in the top left. Upon doing this the user instruction of the HTML form element will appear in the list-box of the 'Fields in Table to be added to report' frame at the top right corner. Once all of the desired fields are listed in this list-box, by pressing the 'Add above Table To Word Report' button, below the list-box, the table will be created and pasted into the Word report document.
To access the Graphs section of the reporter click the 'View and save Graphs of data for inclusion in Report' tab on the top-right corner of the window.
At the top of this Graphs frame is a list-box containing the names/user instructions of all of the Check Boxes, Select Pull-Down Menus and the Radio Button elements of the currently open HTML form.
To view a graph of the responses to these HTML form elements simply click on its name within this list-box.
The default graph type is set the be a Pie Chart.
To instead view the graph as a Bar Graph simple click the 'View Bar Graph' radio button to the left of the list box.
If you wish to save the currently displayed graph to file enter the desired full file name of the picture in the denoted text box below the graph and click the 'Save Graph To File' button.
This will save the graph in the local Reports folder where the generated reports are stored.
To make the generated HTML forms accessible over the Intranet you must copy the each of the forms from the 'HTML' folder into the server's www root directory. Into this same directory you must also copy all of the background picture files which are also contained in the 'HTML' folder.
If you make any adjustments to a Form you must again copy the new Form into the www root directory.
In order to allow the HTML Forms to communicate with the Microsoft Access on the server machine you must also copy the two provided Active Server Page (ASP) programs into the server machine's scripts directory.
These two ASP programs are called 'save.asp' and 'showTable.asp'.
The 'save.asp' program is the program that is called by the HTML Forms and is responsible for storing the responses from the Form into the corresponding database table in the Microsoft database on the server machine.
It also generates a HTML response page which returns to the user the answers they entered and possibly the option of viewing the new updated table in HTML.
The 'showTable.asp' program is the program that can be called the response page that generates and returns the HTML table of the database table.
Along with these two programs you must also include the 'Adovbs.inc' file.
It is a ADO constants include file for VBScript that is used by the ASP programs.
To allow the generated response pages to share the same background as the submitted forms you must also copy the background picture files into the scripts folder with the ASP programs.
The three files above can all be found in the 'Scripts' folder provided with this application.