I am trying to pull back records for a specific date range. I have an effectivedate column that I am using. But I am finding that this isnt working as I originally thought it was going to.
My initial thought was to just add a couple of parameter fields to part of the SQL where clause would look something like this:
(effectivedate >= {?pfld_BegDate} and effectivedate <= {?pfld_EndDate} )
This doesn’t...
NateDogg
Last Activity: Apr 27 '07, 07:08 PM
Joined: Apr 3 '07
Location:
-
Ok, thanks. That did make it a lot clearer. I was having trouble with the [Sub Form Control]. It works now. -
I am still getting the same results. What part of this code do i have to change to the subform name?Leave a comment:
-
Calendar Controls
I want to use a canendar control for 2 different date values on my form. I would like to have the date displayed in a text box so they cna type if they want but I would also like a button that when clicked on, it displays a calendar to pick the date. Is this possible? -
Combo boxes dependent on other combo boxes
This is what I am using to filter my combo box based on what is selected in the previous box.
Open the properties for the second combo box. Next to the 'Row Source' property, click on the '...'.
This opens the query related to the combo box.
In the criteria row under the category field, type the following:
[Forms]![Form1]![Combo1]
Where Form1 is the name of the form containing...
No activity results to display
Leave a comment: