By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

DatePicker

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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...

Nov 13 '05 #2

P: n/a
pi********@hotmail.com wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:
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...

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.
Nov 13 '05 #3

P: n/a
mf****@btinternet.com (Malcolm Webb) wrote in
news:me************************@mfwebb.compulink.c o.uk:
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

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.
Nov 13 '05 #4

P: n/a
>I use Brendan's DatePicker. I generate my SQL in code and
run that using execute or .openrecordset() as applicable. Bob Quintal


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
Nov 13 '05 #5

P: n/a
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

Nov 13 '05 #6

P: n/a
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
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".


Nov 14 '05 #7

P: 1
Consider using XE Date Control. It will help :)
http://www.xe-soft.com/xedate.asp
Feb 15 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.