Holiday Table Design

D

Douglas J. Steele

I thought the article explained how the details for each holiday was stored
in the table.

Family Day falls on the third Monday in February. That means you'd set
FixedMonth to 2 (for February), FixedWeekday to 2 (for Monday) and
FixedWeekdayofMonth to 3 (for the third Monday)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Billiam said:
Hi Douglas,

Thank you for responding!

The Holiday calendar is awesome...thank you for passing it on to me.

How do I add new Holidays, for example, like Family Day, in Canada
(observed
in my Province of Ontario)...

Is there a way to take the values calculated and have them added to the
holiday table for reference by another function? I suspect a command
button
on click function to append the results to the table? I have never done
this
before...any advice? Or perhaps you have a better suggestion?

Thank you again for your help!

Billiam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top