Daniel-
Go take a look at:
ftp://ftp.viescas.com/Download/EntertainWCalendars.zip
The sample forms frmGroupCalendar or frmClubCalendar should give you some
ideas. Note that sample data in the database runs from June 1999 to
December 2000. Select the month and year from the drop-down boxes, then
select a club or group name. The form should show you the bookings in the
selected month. Double-click any date to pull up the detail of the
booking.
That may get you started with what you want to do.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: Dan Abc <daniel2478a@yahoo.ca>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Sunday, November 4, 2012 5:08 AM
To: "MS_Access_Professionals@yahoogroups.com"
<MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] time tracking DB
Hello,
I'm starting to work on a time tracking DB to keep track of time spent on
different projects
my main table has a series of columns, (date, user, department, project,
time, description, ...)
look-up sub tables, (users, departments, projects)
only issue is if people forget to enter time on previous days it will be
hard to see the days they missed
i would like to have a form that shows a calendar that shows the total
number of hours for a certain person on each day
then selecting a day should show a sub form list of times for that
particular day and then maybe another form for detail for one time entry
any better suggestion on how to make this more user friendly?
also what is the simplest way to create a calendar?
(currently i have a table with all days for one year, one column of ID's
and one column of dates)
thanks,
d
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar