RE: Filtering Report with Form (Data Type error)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

SteveS,

I am now having problems with the date filter. I have no problem when
filtering by client and Order Id, but I do have a problem with the date. I
do not use the american format for dates (mm/dd/yyy), instead I use
dd/mm/yyyy.

The problem is that the filter is using the american format, but I need to
use the other format.

Should I change anything? Is it the form or the report?

Thanks.

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Using Combo Box to Select Date Range
    ... The dates must be in the American format. ... Dim strWhere As String ... Tips for Access users - http://allenbrowne.com/tips.html ... > I have a set of records that I would like to filter with a range of dates. ...
    (microsoft.public.access.queries)
  • Filter Report By Date
    ... do not use the american format for dates (mm/dd/yyy), ... The problem is that the filter is using the american format, ... I am using this code for sending the date filter to the report: ...
    (microsoft.public.access.forms)
  • Re: Access2003 Crashes when Filtering
    ... > When a user try's to filter a client ... Keith. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: [?] Howto create a generic ADO Search ?
    ... Filtering is a very bad idea if you are working with a database server ... because the filter occurs on the client. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Filtering Report with Form (Data Type error)
    ... Edgar Chado via AccessMonster.com wrote: ... I am now having problems with the date filter. ... filtering by client and Order Id, but I do have a problem with the date. ... The problem is that the filter is using the american format, ...
    (microsoft.public.access.forms)