Text Box in Form vs. User-Defined Criteria
- From: mjbruesch@xxxxxxxxxxxx
- Date: 21 Mar 2007 07:03:51 -0700
Having Problems...I have to write some queries based on a starting
date. Normally I'll set up a text box in the form, have the user enter
the date in that text box and pull the date from there in my query as
such "like Forms.formName.textboxName". This has worked great except
for one of my forms where it takes an inordinate amount of time for
the queries to run. In attempting to troubleshoot the problem I
changed how the date is entered to having the query prompt the user
for the date with the little pop-up box like such [Enter Date:]. One
such query took 4 minutes to run pulling the date from the Form but
took only 20 seconds to run with the date entered in the pop-up. All
queries on the same form have this problem but I don't have this
problem on any other forms I've done this with. I even tried deleting
the text box and recreating it thinking I maybe messed up one of the
settings but still have the same problem. I have the text box format
as Short Date (like the other forms). I even tried defining the
parameter in the query to explicitly tell it that it was a Date/Time
and still didn't help. I've changed all the queries to have the pop-up
instead but would like to use the text box so the user doesn't have to
keep entering the same date over and over for multiple queries.
Any ideas?
.
- Follow-Ups:
- Re: Text Box in Form vs. User-Defined Criteria
- From: John W . Vinson
- Re: Text Box in Form vs. User-Defined Criteria
- From: kingston via AccessMonster.com
- Re: Text Box in Form vs. User-Defined Criteria
- Prev by Date: Re: filter a table based on a query
- Next by Date: Re: filter a table based on a query
- Previous by thread: % query based on dates.
- Next by thread: Re: Text Box in Form vs. User-Defined Criteria
- Index(es):
Relevant Pages
|
