Calender

keri

unread,

Dec 5, 2006, 3:03:47 PM12/5/06

to

Hi everyone,

I apologise for repeating a topic that has been discussed many times
before but I have searched the archives and googled 2 hours of my life
away trying to solve this.

I need a calender that shows the appointments from my table. I can't
use outlook and I was hoping I could create my own from code in access.
However I have since seen on a post that this is not recommended for
people new to code.(I'm not scared of a challenge, and i was almost
looking forwards to learning as I did it but don't have weeks and weeks
to do this).

I've looked on google and through suggestions on this group but drawn a
blank on anything suitable, or even a good starting point.

If anybody has any ideas where i could start on my own, or even a basic
free code that I could adapt to my uses i'd really appreciate it.

PW

unread,

Dec 5, 2006, 4:59:20 PM12/5/06

to

I use Solutions: Schedule from www.dbi-tech.com. They also offer
other calendars. They seem to infer that they are easy to use.
However, I struggled coming up with a calendar using SS and never did
figure out how to make one that you can enter data and maintain data
on. Also a little pricey. Their e-mail support is very good.

-pw

ManningFan

unread,

Dec 5, 2006, 5:01:27 PM12/5/06

to

This isn't a simple request, and you probably won't find one that suits
your exact needs. Is using an alternative calendar program an option?
My wife uses one called HalfMoon and it is pretty inclusive, it even
gives you appointment reminders.

keri

unread,

Dec 5, 2006, 5:55:55 PM12/5/06

to

I don't mind what I use but I would prefer something quite simple, very
cheap/free (as always!) and something I can edit the code in.

The only reason I was thinking of writing one is because i doubted a
free one would be available.

keri

unread,

Dec 5, 2006, 6:00:21 PM12/5/06

to

Also would prefer something that sits within the Access DB itself, not
as an outside object, and I must be able to display appointments under
the date when viewing the monthly view page. I want the appointments to
add in from a table and I don't necessarily have to be able to edit
things from within the calendar view itself.

Tom van Stiphout

unread,

Dec 5, 2006, 10:58:52 PM12/5/06

to

On 5 Dec 2006 15:00:21 -0800, "keri" <keri....@diageo.com> wrote:

You could have several subforms, one per day, displaying the
appointments for each day. You control which columns should be showing
(perhaps TimeFrom, TimeTo, Product, Notes).
Users could double-click a record to get a popup with more
information.

-Tom.

ManningFan

unread,

Dec 6, 2006, 2:33:27 AM12/6/06

to

Keri -
Take a look here:
http://www.access-programmers.co.uk/forums/showthread.php?t=103747

Don't just download the first database, read the WHOLE thread as
there are 2 or 3 fixes posted at different points. I think this might
give you what you need, but don't quote me on that.

Albert D. Kallal

unread,

Dec 6, 2006, 9:23:29 AM12/6/06

to

There is a bunch of links to some mdb samples that have a nice full screen
calendar
(one that you could modify) here:

http://www.granite.ab.ca/access/calendars.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com

ManningFan

unread,

Dec 6, 2006, 10:52:50 AM12/6/06

to

>From your list, this one would probably help:
http://www.weascend.com/Downloads/downloadpage.htm

keri

unread,

Dec 6, 2006, 1:24:57 PM12/6/06

to

This one is exactly what I am looking for. Perfect, thanks.

http://www.access-programmers.co.uk/forums/showthread.php?t=103747

Now just goning to spend some time changing the source table to my
table and i'll be getting there. What is amazing is that I actually
understand "most" of the calendar code! I must be getting somewhere.

ManningFan

unread,

Dec 6, 2006, 2:30:22 PM12/6/06

to

Glad I could help. Apparently you work for a client of ours, so if I
can help you out with anything else let me know.

keri

unread,

Dec 6, 2006, 3:00:18 PM12/6/06

to

Small world! (Are you a database company that creates Siebel?) Thanks
again. I am slowly struggling through the code, have changed the source
for the populating appointments to a new query, and stopped the user
being able to enter an appointment by clicking on a date (not a
function i want). I am currently puzzling over showing the query
results (eg the appointment dates) when the user clicks on a date on
the calendar. (Because i only want it to show the appointments for the
date the user clicks on).

I'll get there eventually. It takes time because i have to look
everything up in my VBA books, then do trial and error 'til it works!

ManningFan

unread,

Dec 7, 2006, 9:42:49 AM12/7/06

to

Actually, I work for an auditing company that finds and collects
overpayments.

Google is definitely your friend when it comes to learning code. I'm
self-taught and the majority of my knowledge comes from online
searches.