Re: Travel and absence calendar

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: laura (replyto_at_group.com)
Date: 11/18/04 

Date: Thu, 18 Nov 2004 09:06:31 -0000

Dear Mr. Santus,

Thank you for your reply.

I was a little surprised that you were not prepared to help me in the manner
in which everyone on the forum does, 'free of charge' and thought that that
was why you wanted me to write to your directly. If I had wanted to pay
someone I could have mentioned it in my request for assistance. I am there
to learn and am struggling completely on my own to do so.

If I had had to pay someone for every bit of assistance I have had on that
forum, I would now be poor. I am so very grateful to everyone, no matter how
much or how little help they have given me, for that help and will forever
be indebpted to them for helping to me to progress, even if very slowly. I
have learned a lot on the way too and a lot of people generously help each
other without requesting payment.

A lot of work that I do is for charities - of no profit to myself. I was
very excited to see your offer of help, but then very disappointed this
morning to find you wanted to be paid for it. I think that kind of defeats
the purpose of the forum. I will post this message on there too so that
others can be aware, in case you lift their hopes as well.

Thanks
Laura
  ----- Original Message -----
  From: PC Datasheet
  To: Laura
  Sent: Thursday, November 18, 2004 1:11 AM
  Subject: Re: absence list/calendar

  Hi Laura,

  Thank you for your interest in having me help you!

  I will build a travel and absence list database application for you that
you can use to keep track of your 200+ employees on a daily basis who is
traveling and where they have traveled to and who is on vacation. A form you
will be provided to enter your employees' names. A second form will be
provided where you can pick the Employee from a list, select their name and
then enter the start and end trip dates and trip destination. A third form
will be provided where you can pick the Employee from a list, select their
name and then enter the start and end vacation dates. A fourth form will be
provided where the form looks like a calendar. You will be able to pick any
month of any year. The calendar will dominantly display Monday through
Friday and secondarily show Saturday and Sunday for all the weeks in
whatever month you pick. For each day, Monday through Friday, the calendar
will show who is travelling and who is on vacation for that day in the month
you pick.

  Option 1 ---
  Include a table for holidays, a form for entering holidays and the date of
each holiday and display the holidays on the calendar.

  Option 2 ---
  A form for picking a range of months. A report that looks like the above
described calendar for each month in the range you pick.

  My fees ---
  Main application $550US
  Option 1 $150US
  Option 2 $250US
  Total $950US

  Note: Option 1 and Option 2 are not required for the application to
work - it's up to you to decide if you want to include these options.

  Terms: Payment in full to start the project. Payment can be made by check
(preferred) or with credit card through PayPal at my website.

  The application will be open source whereby you will be able to look at
how everything works and you will be able to make any modifications to the
application in the future you wish. You will totally own the application;
there will be no licensing restrictions.

                                         PC Datasheet
                 Your Resource for Access, Excel and Word Help

        Stephen G. Santus, MBA, Engineer Office (814) 226-5327
        52 Campbell Avenue Fax (775)
822-3965
        Clarion, PA 16214
resource@pcdatasheet.com
                                                                       www.pcdatasheet.com

    ----- Original Message -----
    From: laura
    To: resource@pcdatasheet.com
    Sent: Wednesday, November 17, 2004 5:53 PM
    Subject: absence list/calendar

    Hello, thanks for your offer, how can you help me?

    Laura

    Laura,

    I can create a travel and absence list/calendar for you. You will be
able
    to pick any month of any year and for any day Monday through Friday of
the
    selected month show who is on a trip and where and who is on vacation.
    Contact me at my email address below if you would like my help.

    --
                                            PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
                                  resource@pcdatasheet.com
                                     www.pcdatasheet.com

    "laura" <replyto@group.com> wrote in message
    news:uQEGx5#yEHA.2016@TK2MSFTNGP15.phx.gbl...
> I wonder if anyone can offer me a few suggestions on how I might go
about
> designing a travel and absence list/calendar. Perhaps someone has
already
> written a program to do this and can let me have some code to work on,
or
    if
> anyone knows of software out there that might do what I need.
>
> Basically I want to write a program that keeps track of about 200
    employees,
> where they are when travelling or what days they take as holidays.
>
> I want it to look a bit like a spreadsheet.
>
> I want to be able to show just Monday through to Friday, not weekends.
>
> I want the top of the spreadsheet column titles to be the date, i.e.,
as
    an
> example, for this week in November:-
>
> "Employee Name" "Monday 15" "Tuesday 16" "Wednesday 17"
    "Thursday
> 18" "Friday 19" "Monday 22"...etc.
> J. Smith holiday
> holiday holiday
> M. Jones Paris Munich
> P. Brown holiday holiday
>
> The way I want to be able to display the information, which will be
set
    out
> as above, is on a monthly basis where they can pick any month of any
year
> and display the grid.
>
> Data entry will probably be via a form where they can pick the
Employee
    from
> a list and select their name, then enter the trip or holiday date, and
    trip
> destination.
>
> So far I have come up with two small tables,
> tblEmployee with EmplID, Fname, Sname
> tblEvent with EventID, EmplID, Event, Date. (Event of course will
either
> be the destination or 'holiday').
>
> It should be fairly simple, but from those two small tables, I cannot
    figure
> out a way of creating a "Calendar" which is going to be the top row of
my
> Spreadsheet/grid (as illustrated above), which is going to be
infinite -
    in
> other words, this year, next year, the year after.. etc.. whatever
year
    they
> wish into the future. Sort of like a timeline - although I think I
would
> like to limit them to viewing one month at a time rather than being
able
    to
> scroll infinitely left and right.
>
> I hope this is not too confusing and that someone might have a bright
idea
> to push me forward - I have being laying awake at night wondering how
to
    do
> it. I do not know if it should be run from a query or whether I need
to
> create a table with every day of every year preset - or whether it
should
> all be somehow "virtual".
>
> Thanks
> Laura TD
>
>
>

Relevant Pages

  • Re: Travel and absence calendar
    ... show the complete displays for about 5 busy people who travel a lot and who ... "laura" wrote in message ... The calendar will dominantly display Monday through ... > Include a table for holidays, a form for entering holidays and the date ...
    (microsoft.public.access.gettingstarted)
  • Re: What a holiday is to some
    ... some were too poor to go to Phuket last December 26th. ... Those who use the causeways for their holidays in Malaysia are even more. ... I've just returned from a short trip from there. ... Ususally, for those who go thru Sg's travel agents, they got special ...
    (soc.culture.singapore)
  • HOLIDAY CALENDAR 2009
    ... 2009 calendar with holidays ... 2009 calendar with jewish holidays ... los angeles school holiday calendar 2009 ...
    (rec.arts.theatre.stagecraft)
  • Re: Business/Holiday dates
    ... table and WorkdaysCalendar until those rows are removed from WorkSchedule, ... inserting them into a table of holidays. ... the calendar table is a working day as it is to say every day in a booking ... Dim strCriteria As String ...
    (microsoft.public.access.gettingstarted)
  • trip report Michigan to Texas (kong
    ... My wife and I have very different travel styles. ... My step-son and his new bride have begun their life together in Houston. ... I was making plans for the nine-day trip to Texas, ... I used a full three days each way, clinched lots of counties, and enjoyed ...
    (misc.transport.road)