Question using brdemos Calendar Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

epete367@optonline.net - 29 Oct 2005 21:36 GMT

The report designed by Mr. Hookum 'rptShipRequiredDates' is almost
exactly what I have been trying to achieve for weeks. I spent quite
some time looking at it (and the underlying code today). I am not sure
how the table ttblWeekOf is populated. I see dates in the table - are
they put there or do they come from a query or something I am missing?
Would I need to fill the table in myself?
Also, I used the code for ViewCalReport_Click() ammending it to match
my report names, etc... However when I use the form frmCalendarSelect I
get the message Type mismatch. Can anyone direct me on where I have
gone wrong?

Reply to this Message

Duane Hookom - 30 Oct 2005 06:48 GMT

There is code in the click of the button that runs the report. It loops
through the dates from the start to the end dates and adds each Sunday to
the table for the record source of the calendar report.

I'm not sure where or why you would get a type mismatch.

BTW: Mr. Hookom is my dad. Feel free to use my first name.

Signature

Duane Hookom
MS Access MVP

> The report designed by Mr. Hookum 'rptShipRequiredDates' is almost
> exactly what I have been trying to achieve for weeks. I spent quite
[quoted text clipped - 6 lines]
> get the message Type mismatch. Can anyone direct me on where I have
> gone wrong?

Reply to this Message