473,325 Members | 2,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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
Nov 13 '05 #1
7 16976
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
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
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
>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
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
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
ermm
1
Consider using XE Date Control. It will help :)
http://www.xe-soft.com/xedate.asp
Feb 15 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Always Learning | last post by:
Hi Guys, I have a form field of type datepicker. I want to include it in my get string. like this: Response.Redirect("writetodb.asp?Name=" + Textbox1.Text + "&Telephone=" + TextBox2.Text +...
0
by: Deano | last post by:
Hi, May have asked this before but haven't got anywhere with this. I have a datepicker constructed from a form i.e it's not an ActiveX control. On my date controls I have this line in the...
2
by: flipdoubt | last post by:
What do most people use for a DatePicker and is a DatePicker included in ASP.NET 2.0? I've seen some of the commercial products out there, but the redistributable license for most of them is too...
2
by: G .Net | last post by:
Hi Can anybody help me with setting the allowable Max and Min date for a DatePicker? I would like to restrict the possible date selections to a given month. So for example, if I were to...
0
by: Armand | last post by:
Hi All, is anyone of you have any good resource about implementing datepicker that is binded into asp:textbox control? I do have a client side datepicker in JS, but it is binded to html input...
2
by: Vbbeginner07 | last post by:
How to display current date in a datepicker where once we have loaded the datepicker onto form it shows current date,but after some days it shows only the date when it was loaded onto the form,please...
2
by: stainless | last post by:
I have a date selection field that can be blank OR set to a valid future date. I am thinking of using a datepicker field but have one issue with this. If I have a check box in the datepicker...
6
by: ichibon | last post by:
Hi, I have trouble setting the position of the DatePicker, a control from WPF Toolket June 2009 release. When click on the DatePicker control, the Calendar always open as a drop down and expands...
1
by: muddasirmunir | last post by:
Is there any alternate to datepicker in vb6, It can be a custom made controls like many people had develope or some thing similar that can be used instead of datepicker. As i am facing some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.