Return to PORTFOLIO page
Database Applications: Screen Captures, Details
Use this menu to navigate to database screen captures and details...

 


Web Site Changes Log database

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

Screen captures of Web Site Changes Log database and web page output
From data entry to publishing the web page,
then an example change log web page

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.

 
Go to top of page Go to next page