limiting a report to a date range

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ken@olyfurnitureworks.com

    limiting a report to a date range

    I'm trying to implement Allen Browne's advice from http://allenbrowne.com/casu-08.html.

    Unfortunately, I'm getting this error:

    Run-time error '438':
    Object doesn't support this property or method

    associated with:

    strWhere = strField & " Between " & Format(Me.txtSt artDate,
    conDateFormat) _
    & " And " & Format(Me.txtEn dDate, conDateFormat)

    It is an Access 2003 SP2 data project (MS SQL tables with an Access
    front end).

    Private email to adneykp@dshs.wa .gov preferred, since I may forget to
    come back here.
  • Salad

    #2
    Re: limiting a report to a date range

    ken@olyfurnitur eworks.com wrote:
    I'm trying to implement Allen Browne's advice from http://allenbrowne.com/casu-08.html.
    >
    Unfortunately, I'm getting this error:
    >
    Run-time error '438':
    Object doesn't support this property or method
    >
    associated with:
    >
    strWhere = strField & " Between " & Format(Me.txtSt artDate,
    conDateFormat) _
    & " And " & Format(Me.txtEn dDate, conDateFormat)
    >
    It is an Access 2003 SP2 data project (MS SQL tables with an Access
    front end).
    >
    Private email to adneykp@dshs.wa .gov preferred, since I may forget to
    come back here.
    Your problem isn't very important to you, is it?

    Not my problem.

    Comment

    Working...