thank you for answering.
in Current: Me.dateB.Value = Date
this works.
in Current: Me.c_datesA.Value = DateSerial(year(Date), month(Date), 1)
this don't work. shows: Access can't find the field 'year' referred to in
your expression.
I tried:
in Current: Me.c_datesA.Value =
DateSerial(Year([c_dateA]),Month([c_dateA]),1)
I get the same error.
this is in the ControlSource of the Date fields and it works:
=DateSerial(Year([c_dateA]),Month([c_dateA]),1) then c_dateB with 2 and so
on.
works fine, no errors but I like to see how it would be behind Events.
I am trying to make a Calendar form with the dates (the whole month) across
the top.
actually I would like to do this in a query, so I can then do a MakeTable
query and then a Append
query to record every month's history.
but, I don't know how to format the dates in a query.
like: dateA, dateB, dateC, ......
then it would be easier to make the table and then append the data after the
end of each month.
the whole project will(or should)look something like this:
Teacher: Joe _____________Monday_______Tuesday
Dates ___________________3/01/07________3/02/07________, etc.........
Day: Monday
____Time:
________12.00 Jimmy____Rescheduled_____............
________12.30 Toni_____..........._____............
________1.00 Mary_______Out Sick_______............
________1.30 Lori_______.........._____............
Day: Tuesday
____Time:
________12.00 Alfred____..........._______On Vacation
________12.30 Harry_____..........._______.............
________1.00 Susan______..........._______No time
________1.30 Henri______...........________.............
etc, etc....
the form would be for the teacher and his students, to record every days
activity.
the fields under the dates are note fields(can be zoomed to show more info).
the data for each day and time comes from the Enrollment form from each
student.
I would like to put this form into a Tab form, next to the others:
New
Student___Stdt-Info___Reschedule___Sub-Students______Activities___Teachers___Month
Fees
looks complicated, but it should be interesting.
any suggestions how I should go about it?
[email protected]...