** UPDATED ************
Hoprfully to fix the date time problems for everyone. Also tidied up a few bits.
Here is an early version of Whereabouts Planning
system. This will allow you to display and edit the location of you team and managers so you can display them on a web server. Its basically designed on a calender event planner for the working week.Its uses a access database to store the relevent information. This is usefull if you work in a team and need to know where the rest of your team members are
'**************************************
' for :WhereAbouts Planner
'**************************************
None free for anyone to use or modify. I have used code from some of the examples on various ASP sites to build in functions like searching. All ask is for any modifcations / improvements be mailed to me as well. I am interested in developing this system a bit and would like to see what other people do with it just in case i start duplicating it
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Just to let you know, try Alt+PrintScreen to copy a picture of the current window to clipboard, then paste it into any graphics program =) (I hate nags probably just as much as you) (If this comment was disrespectful, please report it.)
I got this message when I tried to open a team from the db: Microsoft OLE DB Provider for ODBC Drivers feil 80040e14 [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '(PersonID=8) and ((Day >= #1. januar 2001#) and (Day<=#5. januar 2001#))'.
/table.asp, linje 97
What's wrong?
Regards
Mark
(If this comment was disrespectful, please report it.)
Its seems to produce errors due to the date format. I Have my regional settings of english and it works O.K but it seems to cause problem if it is not set to english. I beleive the problem might be in common.asp will investigate (If this comment was disrespectful, please report it.)
It works fine on a system setup with inernational settings of english(GB) it has problems when the system is not set to this. Still Investigating (If this comment was disrespectful, please report it.)
I have now updated it and it seems to work fine on the 2 systems i have tried it on a English and Norwegian system (If this comment was disrespectful, please report it.)
IF you have problems with date format and mismatch errors please email me and i will resolve them. (If this comment was disrespectful, please report it.)
9/6/2002 8:29:20 AM:
I can't use Access on my Webserver so have to convert the DB to SQL,however I can't open the MDB it says unrecgnised format. Do you have a copy of the Schema or can I open up the DB...
Thank you
Lee (If this comment was disrespectful, please report it.)
3/30/2004 12:40:22 PM:
Excellent work on this!
When I tried to convert the Access .mdb file to SQL, then it doesn't seem to work. Can view, but can't update data.
Is there a particular reason why it doesn't work?
(If this comment was disrespectful, please report it.)
3/30/2004 12:42:17 PM:
Also tried creating the queries in SQL, and am still unable to update a schedule in SQL. Please advise f4mccabe@yahoo.com (If this comment was disrespectful, please report it.)
7/7/2004 4:32:22 PM:
Well, I don't know how you guys got this to run when the database doesn't have a tblLogin column for the admin login.
Any advice?
(If this comment was disrespectful, please report it.)
10/29/2004 9:59:28 AM:
wher is the zip file ??? (If this comment was disrespectful, please report it.)
10/29/2004 10:00:59 AM:
Sorry heff to scrol left :-$ (If this comment was disrespectful, please report it.)
where is button download. Plz send to fauzibspp@yahoo.com (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 4 Users
Download code
1/5/2001 5:01:31 PM: 
