Using Microsoft Script Editor for Data Access Pages - HTML Source View
(Page 4 of 5 )
From the main menu, you can access various items, one of which is the HTML Source as in Fig.7. This will open the page to show the complete HTML document behind the data access page as shown in Fig.10. It is too large to be shown in this format. Basically the data related information is all included in a DataSourceControl (MS Office DSO as an object); the style related to the various data bound objects; the data itself in a table format and other HTML Document information. Everything is written up in kosher XML. Also included is some standard validation for the page and the Office Web Components (we will not be discussing these as yet). Into this scripting environment you can add your own script depending on what you propose to do.
Fig. 10
Accessing the Microsoft Script Editor
The Microsoft Script Editor can be accessed from the toolbar menu by clicking on the indicated icon shown in Fig.11.
Fig.11
This will bring up the script editor with all the different windows as shown in Fig.12. This has the Document properties, the Document Outline which consists of client objects, events and scripts (you cannot see that in this figure because it has been cut off), the HTML source as well as the Project Explorer. Make sure you review this interface to note that all fields that you dragged on to the design page are there in client objects. In MS Access, textbox controls also come with a label control, so you have for example a City and a City_Label. Since the controls are data bound you have access to the methods of the navigational control as well. Of course you also meet the MSODSC (the DataSourceControl) mentioned earlier.
Microsoft Script Editor Interface
Fig. 12
Next: Client Objects and methods >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 21 
