Access Calender

[Numpty1961]

Hi I need some help.
I would like staff to book annual leave on a database calender. I then want the calender to look at there work schedule which by the way is set out on a wk 1 - 5 schedule depending on the number of wks a month.
example
tuesday 4th may 04 is 1st tuedays on month being wk 1.
Tuesday 11th May is 2nd tuesday of month being wk 2
Tuesday 29th June is week 5 although july 5th (monday) is week 1
Hope this explains and someone can help me.
The weeks 1-5 are on an excel speadsheet. My problem being the calender (entering the data of annual leave storing and linking to excel)

I am waiting in anticipation of someone helping me.


Shaun

 

[simeybt]

I to am looking to develop something similar to this, if any of you "Gurus" out there have an idea of where or how you would go about this it would be excellent.

 

[hymn]

have a look at

http://www.mvps.org/access/resources/downloads.htm

Hope this helps
Hymn

 

[simeybt]

I am getting a lot of funny compile errors when i run the system. IT telling me that Date and Format cannot be found in the project library. Has any one else had this problem. Am I missing out something here

Simon

 

[PHV]

Check your references.
When in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[simeybt]

What references do I need I seem to I have the common VBA one selected. These function I take it would be part of that. Might be a corrupt file

Any other ideas

Simon

 

[PHV]

No MISSING reference ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244