Creating a calender based on expiration field

[kris]

I want to create a calender thats looks similar to gmail-calender.I have a
table with a field called"expiration-date".What i want is a form that looks
like a calender with dates and correspnding records that have that particular
expiration date.
If a record has expiration date "07-09-09" then that record must be
displayed on the form under that date and if there is no record that expire
on that date ,it should be blank.
Over all it should look like a gmail-calender or Lotus notes calender.(the
event should be record )
Can anyone help me on how to proceed?

 

[babyatx13 via AccessMonster.com]

Kris this is a very big project to take on without knowing how to go about it.
I have a similar program that schedules appointments based on job ID.
In it I have a table for holidays one for calendar objects (where I store
what goes on what day) I have a table for employees and one for projects.
As far as the form goes
You will need one form for the actual data (Form1). Set this form inside a
section on another form (Form2). Form2 has 37 sections (set Form1 in one of
these, visible = yes) each section has the source object of Form1 visible =
no
Form2 will in turn be placed in another form (Form3), where all of your other
stuff will go (Date filters and such). Note all these forms are unbound.
I’m sorry I can’t be of more help, but like I said this is a big project, and
I can’t hold your hand through it, but I hope this little bit helps get you
started.

Good Luck
K Board