DatePicker

I use the Microsoft Access Calendar (ActiveX) to pass dates into queries
and reports.

I have recently come across the Microsoft Access DatePicker developed by
Brendan Kidwell and I now use this to input dates into various text boxxes
on my forms. One form has the capacity for over 20 different dates and
using the DatePicker is far easier than typing in individual dates as I
used to.

Does anyone else use Brendan Kidwell's DatePicker, and does anyone know
how to pass dates from the DatePicker into a query? I have tried for 3
days but keep getting an error "you cannot use this procedure at this
time".

Many thanks in advance.

Malcolm Webb

re: DatePicker

Malcolm,
never used this version of DatePicker, but one comment on your
question. Where do the rest of us find his DatePicker? Hard to test
without it...
OTOH, if you want a datepicker that's been probably tested to death and
then some, get the one that Ken Getz & Co put in the various versions
of Access Developer's Handbook. It's essentially a non-OCX version of
the DatePicker control. (so no DLL hell problems with it.)
It may have some weird idiosyncrasies, but if you don't like the way it
acts/functions, you can always tweak the code...

re: DatePicker

pietlinden@hotmail.com wrote in
news:1131400046.249595.253770@g44g2000cwa.googlegr oups.com:
[color=blue]
> Malcolm,
> never used this version of DatePicker, but one comment on your
> question. Where do the rest of us find his DatePicker? Hard
> to test without it...
> OTOH, if you want a datepicker that's been probably tested to
> death and then some, get the one that Ken Getz & Co put in the
> various versions of Access Developer's Handbook. It's
> essentially a non-OCX version of the DatePicker control. (so
> no DLL hell problems with it.) It may have some weird
> idiosyncrasies, but if you don't like the way it
> acts/functions, you can always tweak the code...
>[/color]
I use Mr Kidwell's excellent Datepicker, which I got from Dev
Ashish's site, http://www.mvps.org/access/
the specific page is http://www.mvps.org/access/forms/frm0057.htm
and that points to download
http://www.mvps.org/access/downloads/datepicker.zip

it's great.
--
Bob Quintal

PA is y I've altered my email address.

re: DatePicker

mfwebb@btinternet.com (Malcolm Webb) wrote in
news:memo.20051107091953.59575F@mfwebb.compulink.c o.uk:
[color=blue]
> I use the Microsoft Access Calendar (ActiveX) to pass dates
> into queries and reports.
>
> I have recently come across the Microsoft Access DatePicker
> developed by Brendan Kidwell and I now use this to input dates
> into various text boxxes on my forms. One form has the
> capacity for over 20 different dates and using the DatePicker
> is far easier than typing in individual dates as I used to.
>
> Does anyone else use Brendan Kidwell's DatePicker, and does
> anyone know how to pass dates from the DatePicker into a
> query? I have tried for 3 days but keep getting an error "you
> cannot use this procedure at this time".
>
> Many thanks in advance.
>
> Malcolm Webb
>[/color]
I use Brendan's DatePicker. I generate my SQL in code and
run that using execute or .openrecordset() as applicable.

--
Bob Quintal

PA is y I've altered my email address.

re: DatePicker

>I use Brendan's DatePicker. I generate my SQL in code and[color=blue]
>run that using execute or .openrecordset() as applicable.[/color]
[color=blue]
>Bob Quintal[/color]

Thanks to all who responded. The link to Brendan's DatePicker was in one
of the replies.

Specifically for Bob Quintal -- I have a query that has a DateSupplied
field. I want to filter the records in the query using <=[ChosenDate] and
would like to pass [ChosenDate] into the query direct from the DatePicker.

i.e. When I run the query, the DatePicker pops up, I choose the date, the
query returns the filtered records.

The instructions with DatePicker say to use the InputDate command, but
this generates "you cannot run this procedure at this time".

Any advice would be greatly appreciated.

Malcolm Webb

re: DatePicker

You cannot create a query that opens a form.

You can call a query from a form or from code

What I do is

dim strSQL as String
dim strFilterDate as string

strFilterdate = nz(inputdate. date() )
strSQL = "SELECT table.field1, table.field2 from table where
table.datefield = #" & strfilterdate & "#""

sql.execute strsql

HTH

re: DatePicker

Here's something I put together that may give you some ideas about
making time periods and other criteria dynamic.

The free downloadable sample database at www.bullschmidt.com/access
uses the query by form concept so that on the invoices dialog one can
optionally choose a rep, a customer, and perhaps a date range, click on
a button that says "Input," and then have the invoice form open up
showing all the invoices that match the criteria.

Thus the min and max date fields on the initial form can be typed in or
perhaps automatically filled in with your datepicker and then the rest
(form running off query which receives its criteria from the initial
form which stays open in the background) should still work.

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips
[color=blue]
>Does anyone else use Brendan Kidwell's >DatePicker, and does anyone know
>how to pass dates from the DatePicker into a >query? I have tried for 3
>days but keep getting an error "you cannot use this >procedure at this
>time".[/color]

re: DatePicker

Consider using XE Date Control. It will help :)
http://www.xe-soft.com/xedate.asp