> Database Applications: Screen Captures, Details
|
|
Use this menu to navigate to database screen captures and details...
|
||||
The Web Site Changes Log database made it easy for the webmaster to list
the most recent changes made in an intranet web site. The resultant web
page, a change log, had consistent formatting, date labels, and links to
the new or revised web pages. Intranet users could then view the change log
and scan for any new information of interest. This database application was
produced in MS-Access 97, January 2000, at PG&E Energy Trading.
Screen captures
TECH NOTE: Using the default web browser to preview the web page For previewing the web page produced by this application, I made a code module, mdlDefaultBrowser, for determining the 'default' web browser installed on the user's (i.e., the webmaster's) machine. Then, through a 'shell' call, I could open the 'default' web browser to display the database application's output web page, the change log, no matter if the 'default' web browser was Internet Explorer, Netscape, or other. Determining the 'default' web browser went like this: (1) determine the user's temporary directory, with a call to GetTempPath, kernel32.dll; (2) create a dummy HTML file in the temporary directory; (3) determine which executable program Windows had associated with the dummy HTML file, with a call to FindExecutable, shell32.dll; then (4) delete the dummy HTML file. These steps provided me with an accurate string value, to give to a 'shell' call, for opening the user's default web browser. |