P
pwdpwd via AccessMonster.com
Hi - hope someone can help.
What I'm trying to do is to select service dates within a 53 week year - and
the year doesn't always start on the 1st Jan. When I use specific criteria in
the ServiceDate field in the query (dd/mm/yyyy):
"Between #28/12/2009# And (#28/12/2009#+371)"
it works fine.
When I use a text box (set to dd/mm/yyyy) and set the criteria to
"Between Forms!FRM_FormName!TextBox and (Forms!FRM_FormName!TextBox +371)"
it also works fine
I don't want the user to have to remember the exact start date of each year,
so I created a tbltablestartdate table; with 3 fields - ID, year and
yearstartdate.
On the form I created & bound a combobox to that table, but only display the
year. I want to let the user select the year (yyyy) but use the yearstartdate
(dd/mm/yyyy) as the criteria in the query. I tried substituting 'Combobox'
for 'TextBox' but that doesnt work, as (presumably) the combobox is passing
the data for the year, not the yearsstartdate.
I'm sure that it must be possible, but not sure how - any help would be much
appreciated.
What I'm trying to do is to select service dates within a 53 week year - and
the year doesn't always start on the 1st Jan. When I use specific criteria in
the ServiceDate field in the query (dd/mm/yyyy):
"Between #28/12/2009# And (#28/12/2009#+371)"
it works fine.
When I use a text box (set to dd/mm/yyyy) and set the criteria to
"Between Forms!FRM_FormName!TextBox and (Forms!FRM_FormName!TextBox +371)"
it also works fine
I don't want the user to have to remember the exact start date of each year,
so I created a tbltablestartdate table; with 3 fields - ID, year and
yearstartdate.
On the form I created & bound a combobox to that table, but only display the
year. I want to let the user select the year (yyyy) but use the yearstartdate
(dd/mm/yyyy) as the criteria in the query. I tried substituting 'Combobox'
for 'TextBox' but that doesnt work, as (presumably) the combobox is passing
the data for the year, not the yearsstartdate.
I'm sure that it must be possible, but not sure how - any help would be much
appreciated.