Add Events Calendar to my Dashboard Form

[Shazz]

Hi All,



I am trying to create an events Database, I have created a dashboard with buttons to take you to form/Tables, but I would like to either have a monthly calendar at the bottom of the dashboard showing events for the month, which will have the data from my events table.

Or if this is not possibly, is there a way of having the events table showing on the dashboard under the buttons in stead.

Anyone help would be greatly appreciated.

Shazz

[Homegrownandy]

I'd commend using Microsoft outlook calendar as you can easily update/manage via a DB.

What is the purpose of the database? If you have just one table "events" access probably isn't required. Maybe you could also post a screenshot of your relationships.

Andy.

[June7]

A calendar database is not simple to build.

Yes, can have a subform on dashboard/menu form.

Have you looked at MS EventManagement database template?

[Missinglinq]

A calendar database is not simple to build....

Truer words were ever spoken! I've seen it lately, but a few years ago there was a post on one Access forum on the subject that had run to somewhere in the neighborhood of 1500 responses...and still had problems to resolve!

This is definitely a case where you don't want to reinvent the wheel if you can find something out there that you can adapt to your use...as suggested by June7 and homegrownandy.

Linq ;0)>

[June7]

Having said that, I will add that it is fairly simple to build a form that looks like a calendar and sets values and visibility of 42 UNBOUND textboxes representing days of calendar.

Private Sub Form_Open(cancel As Integer)
Me.FirstDate = Date
Call filldates
End Sub

Private Sub filldates()
Dim curday As Variant, curbox As Integer
curday = DateSerial(Year(Me.FirstDate), Month(Me.FirstDate), 1)
curday = DateAdd("D", 1 - Weekday(curday), curday)
For curbox = 1 To 42
    Me("D" & curbox) = Day(curday)
    Me("D" & curbox).Visible = Month(curday) = Month(Me.FirstDate)
    curday = curday + 1
Next curbox
End Sub

Now building a calendar/appointment db and feeding data to the form does get complicated. I have seen it but unfortunately didn't save it.

[moke123]

Heres a sample that may help get you started
SampleCalendar.zip

[June7]

Here's another https://www.access-programmers.co.uk...d.php?t=275897