Calendar using between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use the between dates of a query into Calendar Control 10.0.
Is it possible?
 
Hi,


The calendar "control" has to be in a form, and once there, the syntax to
query it is as with any control in an open form:
FORMS!FormName!ControlName



Those parameters are automatically evaluated for you if you use the user
interface, or if the statement is in a RowSource property, of if you use
DoCmd.RunSQL, as example. If you use CurrentDb, these parameters ARE NOT
automatically resolved, and you have to do it BEFORE execution of the query
using this syntax.


Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount returning no results!!! 0
Using ActiveX Calendar to pupulate dates 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Parameter dates 1
grouping quarters 3
Using Calendar's for date range 1
Date Range for Query 4
query on date 1

Back
Top