|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 6th, 2006, 06:06 PM
posted to microsoft.public.access.forms
|
|||
|
|||
to add an unbound without the parameter value
hello
how to add an unbound tex box using the from date and to date in a form? without adding it to the criteria in the query table. i do not want the enter parameter value to pop up once i put the date into the unbound box. Bessie 
|
|
#2
December 6th, 2006, 06:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
to add an unbound without the parameter value
On Wed, 6 Dec 2006 10:06:03 -0800, Bessie
wrote: hello how to add an unbound tex box using the from date and to date in a form? without adding it to the criteria in the query table. i do not want the enter parameter value to pop up once i put the date into the unbound box. Bessie It's easy to add the textboxes to the form - just use the toolbar textbox tool, and don't put anything into the control source. The parameter in your Query would be = [Forms]![YourFormName]![txtFrom] AND DateAdd("d", 1, [Forms]![YourFormName]![txtTo]) The DateAdd will catch records with date/time values after midnight on the last day of the range. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
