Diary problem

[Derek Brown]

Hi all

Is it possible to produce a diary report that looks like your regular diary
say with 7 days on 2 pages show days of week and put any appointments booked
on access into the diary?

Obviously the pages will move around if one day for example has numerous
appointments. At least I need to show days when no appointment exist. Not
easy eh?

 

[Rob Parker]

This probably isn't the sort of reply you were expecting, but you might
consider it - it's how I'd approach this.

Instead of re-inventing a "diary-printing wheel", use the one that's built
into Outlook, and write some automation code to export your appointment data
from Access to Outlook. The following link (watch for line-splitting), to
the Microsoft Developers Network site, could be a useful starting point:

http://msdn.microsoft.com/office/un...to.asp#odc_ac_olauto_addappointmentstooutlook

Or you could try a Google search.

HTH,

Rob

 

[Derek Brown]

Thanks Rob

Unfortunateley I have no choice the dBase is for distribution I dont want to
have to package Outlook with my install as i am told it's hillarious. I'll
guess I'll have to keep trying as you can see from other postings already
hitting problems.