Microsoft Jet does not recognize...

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi again...

I hope I'm not wearing out my welcome, but I'm getting
this error message when I try to print one particular
report from my print dialog:

The Microsoft Jet database engine does not
recognize 'Forms![frmPrintReports]![txtBegDate]'as a valid
field name or expression.

The problem is, I open several other reports from the same
dialog box and it works perfectly! Does anyone know why
this happens?

Thanks in advance.
 
Is the query behind this report perhaps more complex than behind the others?
Or are you running it at a time when frmPrintReports is not open?

- HTH
Turtle
 
Concatenate the value of the date into the WhereCondition string.

Example:
Dim strWhere As String
If IsDate(Me.txtBegDate) Then
strWhere = "[MyDateField] = " & _
Format(Me.txtBegDate, "\#mm\/dd\/yyyy\#")
End If
DoCmd.OpenReport "MyReport", acViewPreview, , strWhere
 
Gina said:
Hi again...

I hope I'm not wearing out my welcome, but I'm getting
this error message when I try to print one particular
report from my print dialog:

The Microsoft Jet database engine does not
recognize 'Forms![frmPrintReports]![txtBegDate]'as a valid
field name or expression.

The problem is, I open several other reports from the same
dialog box and it works perfectly! Does anyone know why
this happens?

Thanks in advance.
Click to expand...
 
Back
Top