Calendar Error (Duane's Calendar)

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
 
Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?
 
Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.
 
You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If
 
That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
..... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!
 
Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?
 
Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.
 
Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


NFL said:
Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


Duane Hookom said:
Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?
Click to expand...
Click to expand...
 
I removed the criteria for Col1 and it came up with no records. I tried
changing the source table/query and it didn't work. It was looking for
Col1's criteria.

Duane Hookom said:
Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


NFL said:
Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


Duane Hookom said:
Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
.... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I removed the criteria for Col1 and it came up with no records. I tried
changing the source table/query and it didn't work. It was looking for
Col1's criteria.

Duane Hookom said:
Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


NFL said:
Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
.... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
I'm not sure why it came up with no records.

With a high volume of records, I have other reports to identify courses
required, but not scheduled. At least the courses are identified for future
scheduling.

Duane Hookom said:
Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I removed the criteria for Col1 and it came up with no records. I tried
changing the source table/query and it didn't work. It was looking for
Col1's criteria.

Duane Hookom said:
Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


:

Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
.... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
I'm not sure I understand. You seem to want to print a schedule report that
has no records. This is causing issues in the report. Why attempt to even
render the report if there is nothing to report?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I'm not sure why it came up with no records.

With a high volume of records, I have other reports to identify courses
required, but not scheduled. At least the courses are identified for future
scheduling.

Duane Hookom said:
Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I removed the criteria for Col1 and it came up with no records. I tried
changing the source table/query and it didn't work. It was looking for
Col1's criteria.

:

Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


:

Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
.... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
I just need the Week At A Glance report to filter records that do have dates
and times. Keep in mind that there are records in the same table that do not
have dates and times entered yet. I hope that helps. I apologize for not
communicating this right.

Duane Hookom said:
I'm not sure I understand. You seem to want to print a schedule report that
has no records. This is causing issues in the report. Why attempt to even
render the report if there is nothing to report?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I'm not sure why it came up with no records.

With a high volume of records, I have other reports to identify courses
required, but not scheduled. At least the courses are identified for future
scheduling.

Duane Hookom said:
Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


:

I removed the criteria for Col1 and it came up with no records. I tried
changing the source table/query and it didn't work. It was looking for
Col1's criteria.

:

Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already removed
the null records?

--
Duane Hookom
Microsoft Access MVP


:

Each column represents the query column from the Week at a Glance report.
The top row represents the "Field" and the second row represents the
"Criteria". When I run the query with the Criteria listed from Col1 and Col
6 the query will give me a long error message "The expression is typed
incorrectly.......too complex". When I remove Col1 and Col6 criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from what you have
stated. Is your report attempting to render a week that doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your "Week-At-A-Glance"
report and even filter out the dates, start time, and end times to "Not Null"
in the query. Now when I try to see certain weeks (which begins on a Sunday),
I get the error message "The expression is type incorrectly or is too complex
.... ". How can I make this report work even though some class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime + Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime, Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in table
Me.Instructor.Left = Me.ReportColumn 'field in table

I'm also getting an error on both the weekly and monthly calendar. The
error reads as "The expression is type incorrectly or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
You stated earlier "I removed the criteria for Col1 and it came up with no
records". If there were no records returned then there would be nothing to
print in the report.

Maybe you just need some code in the report in the On No Data event that
shows a msgbox and closes.


--
Duane Hookom
MS Access MVP


NFL said:
I just need the Week At A Glance report to filter records that do have
dates
and times. Keep in mind that there are records in the same table that do
not
have dates and times entered yet. I hope that helps. I apologize for not
communicating this right.

Duane Hookom said:
I'm not sure I understand. You seem to want to print a schedule report
that
has no records. This is causing issues in the report. Why attempt to even
render the report if there is nothing to report?

--
Duane Hookom
Microsoft Access MVP


NFL said:
I'm not sure why it came up with no records.

With a high volume of records, I have other reports to identify courses
required, but not scheduled. At least the courses are identified for
future
scheduling.

:

Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


:

I removed the criteria for Col1 and it came up with no records. I
tried
changing the source table/query and it didn't work. It was looking
for
Col1's criteria.

:

Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already
removed
the null records?

--
Duane Hookom
Microsoft Access MVP


:

Each column represents the query column from the Week at a
Glance report.
The top row represents the "Field" and the second row
represents the
"Criteria". When I run the query with the Criteria listed from
Col1 and Col
6 the query will give me a long error message "The expression
is typed
incorrectly.......too complex". When I remove Col1 and Col6
criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has
classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from
what you have
stated. Is your report attempting to render a week that
doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your
"Week-At-A-Glance"
report and even filter out the dates, start time, and end
times to "Not Null"
in the query. Now when I try to see certain weeks (which
begins on a Sunday),
I get the error message "The expression is type incorrectly
or is too complex
.... ". How can I make this report work even though some
class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to
ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime +
Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have
several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the
start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and
not sure why i'm getting
the error. The error is pointing to this line
below. The report worked
great, but when I start adding more appointments,
this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n",
datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in
twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in
section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n",
datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime,
Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in
table
Me.Instructor.Left = Me.ReportColumn 'field
in table

I'm also getting an error on both the weekly and
monthly calendar. The
error reads as "The expression is type incorrectly
or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
I want to thank you for your patience with me. I finally got the week at a
glance to work. Your input challenged me to think this through.

Duane Hookom said:
You stated earlier "I removed the criteria for Col1 and it came up with no
records". If there were no records returned then there would be nothing to
print in the report.

Maybe you just need some code in the report in the On No Data event that
shows a msgbox and closes.


--
Duane Hookom
MS Access MVP


NFL said:
I just need the Week At A Glance report to filter records that do have
dates
and times. Keep in mind that there are records in the same table that do
not
have dates and times entered yet. I hope that helps. I apologize for not
communicating this right.

Duane Hookom said:
I'm not sure I understand. You seem to want to print a schedule report
that
has no records. This is causing issues in the report. Why attempt to even
render the report if there is nothing to report?

--
Duane Hookom
Microsoft Access MVP


:

I'm not sure why it came up with no records.

With a high volume of records, I have other reports to identify courses
required, but not scheduled. At least the courses are identified for
future
scheduling.

:

Questions for you to ponder:
- Why did it come up with no records?
- If there would be no records then why report this?

--
Duane Hookom
Microsoft Access MVP


:

I removed the criteria for Col1 and it came up with no records. I
tried
changing the source table/query and it didn't work. It was looking
for
Col1's criteria.

:

Did you try with just removing the Col1 criteria?
Can you change the source table/query to a query that has already
removed
the null records?

--
Duane Hookom
Microsoft Access MVP


:

Each column represents the query column from the Week at a
Glance report.
The top row represents the "Field" and the second row
represents the
"Criteria". When I run the query with the Criteria listed from
Col1 and Col
6 the query will give me a long error message "The expression
is typed
incorrectly.......too complex". When I remove Col1 and Col6
criterias the
query will give me the information I need.

Col1
weekof: DateAdd("d,-weekday([coursedate]]),[coursedate])+1
[forms]![frmCalendarReport]![text6]

Col2
ClassID

Col3
CourseDate
Is not null

Col4
Classtime
is not null

Col5
endtime
is not null

Col6
instructor
[forms]![frmCalendarReport]![combo4]

Col7
ReportColumn

Col8
Cancelled
0

Col9
Completed
0

I want the report to only allow me to pick a week that has
classes with
dates and times scheduled.


:

Can you identify what is causing the issue? I can't tell from
what you have
stated. Is your report attempting to render a week that
doesn't have anything
scheduled?

--
Duane Hookom
Microsoft Access MVP


:

That worked....

Question: I was able to view certain weeks from your
"Week-At-A-Glance"
report and even filter out the dates, start time, and end
times to "Not Null"
in the query. Now when I try to see certain weeks (which
begins on a Sunday),
I get the error message "The expression is type incorrectly
or is too complex
.... ". How can I make this report work even though some
class times and
dates have not been scheduled or entered yet?

Thank you again for you help!

:

You need to filter out the blank records or add code to
ignore these records.
If you don't filter them out, set up something like:

If Not IsNull(Me.ClassTime + Me.EndTime +
Me.ReportColumn) Then
'code to position etc
Me.ClassID.Visible = True
Else
Me.ClassID.Visible = False
End If

--
Duane Hookom
Microsoft Access MVP


:

Yes I do. Start times begins at 8:00am. We do have
several appointment on
the books, but no date, start time, and end time.

:

Do you have any records that have no values in the
start or end times or
dates? Do any times start before 8:00 AM?

--
Duane Hookom
Microsoft Access MVP


:

I'm getting a runtime error 13 -- type mismatch and
not sure why i'm getting
the error. The error is pointing to this line
below. The report worked
great, but when I start adding more appointments,
this error pops up.

Me.ClassID.Top = lngTopMargin + DateDiff("n",
datSchedStart, Me.ClassTime) *
lngOneMinute

Dim lngTopMargin As Long

Dim lngOneMinute As Long 'size of one minute in
twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in
section
Me.MoveLayout = False
Me.ClassID.Top = lngTopMargin + DateDiff("n",
datSchedStart,
Me.ClassTime) * lngOneMinute
Me.ClassID.Height = DateDiff("n", Me.ClassTime,
Me.EndTime) * lngOneMinute
Me.ClassID.Left = Me.ReportColumn 'field in
table
Me.Instructor.Left = Me.ReportColumn 'field
in table

I'm also getting an error on both the weekly and
monthly calendar. The
error reads as "The expression is type incorrectly
or is too complex .... "
It doesn't take me to the code.

Is there a limit of appointments you can enter?

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top