Click here to Skip to main content
14,116,173 members
Click here to Skip to main content
Add your own
alternative version


38 bookmarked
Posted 27 Jun 2005

Easy Time Management Application

, 29 Jul 2005
Rate this:
Please Sign up or sign in to vote.
Simple web-based time management application using ASP and MS Access.

ASP Time Management

Download sourcecode


The goal was to create an easy to use web-based time management application using ASP (Active Server Pages) and the Microsoft Access database for the backend.

Setting it up

Setting up is simple as long as you have met the basic requirement of having webspace that supports ASP and Access database connections via DSN.

Edit the file admin.php change the logincode = "123" on line 2 to your own password that you will use to access the system online.

The next file you may edit, depending on your preference and web host setup is the the path to your database. This is set on line 80 of the file common.asp.

The default is set to "map" the path to the current directory. It is suggested for security reasons that you move the database file and update this path with the physical path on your server. One of the reasons the password is NOT stored in the database is for this very reason. If someone downloads your database, they can't recover your password. I generally prefer this security model on simple applications to make them easier to setup with less worry about making sure the database is in a secure location. ala Dick Cheney :)

Once you have the files copied, and the password changed from the default, go ahead and open your favorite web browser and visit the location on the web where you copied the files (default.asp). You will be shown the login screen.

Login with your password and you will then be in your new time management app.

Adding New Items

Adding new items is very simple, fill in the form and hit the "add" button.

One feature I really liked was the "copy event" checkbox. I wanted to keep the application very simple, but this was one "extra" feature I thought was really needed. Many times you may have a meeting at the same time for a few days in a row. Simple click to edit the meeting, make changes (such as the date or time) and then make sure you check the "copy event" check box.

And then the event is then easily copied.

The Calendar View

This was the inspiration for the whole project. I had finally come across an easy and easily codeable calendar display in ASP.(thanks to") Click on the "view calendar link" on the top of the screen to view all your appointments right there in calendar format.

I took the calendar code and modified it so that as the calendar loops through each day of the month, it loops through an array from the database and if there is a match, it prints out the appointment information for that day.

<PRE lang=vbscript>MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from tblcalendar where eventdate between # " & godatefirst & "# AND #" & godatelast & "# AND active = 1 order by eventdate,eventtime;"
set Conn = server.createobject("adodb.connection")
Set RS = Server.CreateObject("ADODB.recordset")
RS.Open mainSQL, Conn, 1, 3
recordcount = rs.recordcount

if recordcount > 0 then
    eventnumber =  "<DIV>" & recordcount & " events from " & godatefirst & " - " & godatelast & "</DIV>"
    data = RS.GetRows()
    iRecFirst   = LBound(data, 2)
    iRecLast    = UBound(data, 2)
    eventnumber = "<DIV>No Events Found"
end if

set rs = nothing
set conn = nothing</DIV></PRE>

That is where the "magic" happens in this app.

Yes it's simple but I've found it to be effective for use as a simple and quick time management application. Full source code can be downloaded here. ASP Time Management.


If you prefer PHP, here is a php version of time management. PHP Time Management


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

United States United States
Live in Michigan, USA

You may also be interested in...


Comments and Discussions

QuestionTime management application is really more important for the organizations Pin
Member 111222765-Oct-14 23:56
memberMember 111222765-Oct-14 23:56 
QuestionTime management Application Pin
Amita Harij7-Oct-13 23:20
memberAmita Harij7-Oct-13 23:20 
GeneralGREAT!! Pin
Andrew Jee20-Aug-05 21:46
memberAndrew Jee20-Aug-05 21:46 
GeneralRe: GREAT!! Pin
aa2max24-Aug-05 7:31
memberaa2max24-Aug-05 7:31 
GeneralMinor confusion Pin
Yulianto.27-Jun-05 17:35
memberYulianto.27-Jun-05 17:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web03 | 2.8.190518.1 | Last Updated 29 Jul 2005
Article Copyright 2005 by aa2max
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid