Bookable Diary On Access ?? 1

[voltarei]

Hi All,
Does anyone know if Access has the ability to include a diary which allows you to book meetings etc, with the ability to review the diary and amend if necessary.

If so, any help on how to build one into my database would be appreciated.

Phil

 

[DougP]

Access is a database so it can hold anything. also since it has VBA you can make it do anything.
if you have a date field then you can search or sort by that field.
you need a meeting table first with these possible field names.
MeetingID, Meeting title , Date , Time, other info, etc
are you going to have attendees?
Attendee Table
AttendID , name , phone , etc

Then you need a table that ties both together so attendees can be in more that one meeting.
Schedule Table
MeetingID, AttendID

This is a rough start


DougP, MCP, A+

 

[voltarei]

Hi DougP,
Many thanks for this initial insight.
I have created the tables as suggested, but now need to know how I create the diary, so that I can see what events are happening when I try to book another one in, to avoid double booking.
Can it look something like an outlook calendar?

Many thanks
Phil

 

[DougP]

no, not unless you create a calendar yourself. you can send info. to Outlook from Access, not sure how though


DougP, MCP, A+

 

[missinglinq]

Here's a link from an old post that I think is the very thing for you. When you download the zip file and extract it there are several DBs that each do different things with calendars in Access. The one named Input2000.mdb is the one you want. Open it then click on frmCalendar.

It opens a Month-at-a-Glance calendar. You click on the appropriate day and a popup box appears for that day. Enter your meeting data and click Ok and it's written to the date on the calendar. It works a treat! The author's name is Jim Lunde.Be sure and read the ReadMe file.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

Sorry, forgot the link:

http://www.referee-assistant.com/calcontrol.htm

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[voltarei]

Hi Missinglinq,
This is exactly what I needed, thank you for the link to the download.

Phil

 

[missinglinq]

That's why we're here!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!