Re: access 2000 date query

Mike,

I do that at times.

But at other times I build SQL strings with code that change to much to use
parameters. I then assign the string to queryObject.sql.text.

Thanks
Bill
"Mike Shkolnik" <mshkolnik2002@xxxxxxx> wrote in message
news:43d0ef6d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Bill,
>
> use the parameters for query instead. And you'll not depend from any date
> formats.
>
> --
> With best regards, Mike Shkolnik
> EMail: mshkolnik@xxxxxxxxxxxxx
> http://www.scalabium.com
>
> "Bill Hannan" <wfha@xxxxxxxxxxxxx> wrote in message
> news:43d0e674$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> Access 2000 sql query.
>>
>> Is there any way to get access to recognize '01/01/2006' as a valid date
>> instead of using #01/01/2006#. The database is set to use ANSI 92, I
>> thought that would do it.
>>
>> Thanks
>> Bill
>>
>>
>
>


.

Relevant Pages

  • Re: Is there an SQL query for table schema ...
    ... > Is there an SQL query that will return a list of all indexes on a ... > In addition will it list the fields involved if it is a compound index? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Using parameters with LIKE comparison
    ... William (Bill) Vaughn ... Microsoft MVP ... > I have trayed to create SQLCommand with sql query: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using parameters
    ... Then look at Bill Ryan's solution;-) ... > Author, Mentor, Consultant ... > Microsoft MVP ... >>> I have a problem with creation of SQL query when I try to use parameter ...
    (microsoft.public.dotnet.framework.adonet)
  • access 2000 date query
    ... Access 2000 sql query. ... The database is set to use ANSI 92, ... Bill ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Is there an SQL query for table schema ...
    ... Is there an SQL query that will return a list of all indexes on a ... In addition will it list the fields involved if it is a compound index? ... Bill ... Prev by Date: ...
    (microsoft.public.access.queries)
Loading