Usable Calendar Form

[chellebell1689]

Hello,

Can anyone point me in the direction of a tutorial or add-in for a calendar? I thought about making one with a form, but I don't know enough to make it automatically generate the dates each month.

Ultimately what I want is a calendar that shows a colored symbol (or one symbol with a different color for each user) on a day they have something planned. Then each user can click that day and a pop will show who has what planned and the times. Then if they want, they can click on the event/appointment and will give full details in another pop-up. I also would like a message sent to the calendar admin to approve/decline appointments as they're requested. (I might know how to do the approval requests...)

I'm a little groggy right now, so please let me know if you need more information or some clarity.

Thanks in advance.

**EDIT**
Oh forgot to mention I'm using Windows 8.1 and Access 2013 (in case it makes a difference for how to set it up or for the add-in)

 

[spikepl]

I always wonder about this so I'll just ask directly: do you not have Outlook, that has a user interface much better suited for this type of things?

 

[chellebell1689]

This is for my church, and currently most of the people who will use it don't have Outlook. As far as I know only the pastor has Outlook. The pastor wants to be able to track everything in Access (and I do mean EVERYTHING). I haven't really talked to him about the calendar, but I figured he'd want it and it helps others know who has what planned; as well as let me know what's planned so I can send out the reminders to those who've signed up for them.
It is a valid question, and if I could figure out a way to integrate Outlook with Access, I definitely would!

 

[spikepl]

So who are the ones viewing a calendar? Anyone apart from the pastor? Access is not on the web! But Google's calendar is. How about that?

 

[chellebell1689]

Well, mostly it would be the pastor, the youth minister, the secretary, the music minister, the children's minister, and the head of each of the 14 committees we have (so they can add their meeting date/time, and any other events they have planned/proposed), and of course myself. They would all come to the church to use the db, except for the pastor. He's got it set up so he can work from home and still be able to access anything he needs like he would if he were here.
I may just talk to him and see if this is something he definitely wants. I just thought I would see if it's do able.

 

[speakers_86]

I did not make it. And yes, Outlook is a better choice. If you don't have that, I'm sure there are free alternatives.

 

[chellebell1689]

Thank you!! I'm in the middle of something right now, but when I finish up I will check it out. Thanks for the help!

 

[chellebell1689]

Is it an add-in? I assumed it was and saved it in the add-in folder, but when I try to use it I get a pop up:
"The add-in could not be installed because it is missing a USysRegInfo table."

In the mean time I'll try opening it as a regular database and see if that gets me anywhere. Thanks again!

 

[chellebell1689]

Ok, I was dumb it wasn't an add-in. I imported it and it works great! Thank you so very much!!

 

[speakers_86]

It is not an addin.

 

[chellebell1689]

Do you by chance know how I can make the "frmAppointments" form display a message if someone tries to schedule an appointment for the same time of an existing one?

(Apparently the Start Times are unique identifiers)

 

[speakers_86]

You've got to write some code. Take the date and time from the user, use code to check the table for that date and time, and respond accordingly.

 

[chellebell1689]

Thanks, I was hoping there was an easier way to do it. I don't know VBA and what I have been able to do so far is just modify what scripts I've found through tutorials. I'm taking VB in the fall, so I'll work on that part then.

Thanks again for the help.