Re: Text Box in Form vs. User-Defined Criteria

What version of Access are you using? Try going to Tools -> Options... ->
General and make sure Track name AutoCorrect info is unchecked. Otherwise,
try to recreate the form by renaming it and then making a copy of it with the
original name. You can create a new Access file and import all of the
objects into it to see if the problem persists. Do you have any code
attached to the form that you can step through? If you do, try to /decompile
the file. You've probably tried this, but how about Tools -> Database
Utilities -> Compact and Repair Database...
hth


mjbruesch@xxxxxxxxxxxx wrote:
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?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200703/1

.

Relevant Pages

  • Re: Append Query
    ... then I would not delete and recreate it ... If the query still thinks it doesn't exist, then try storing the query in ... Would turning Autocorrect back on solve the ... >>> same as the previous month and the append queries would work great. ...
    (microsoft.public.access.queries)
  • Re: Looking at query record selection criteria from RPG/CL
    ... I got as far as the RTVQMQRY bit but have not created a program to rebuild ... to manually zip through and determine which queries were affected by the ... >> each query in RPG or CL? ... > Write a program to modify the retrieved source and recreate the query. ...
    (comp.sys.ibm.as400.misc)
  • Text Box in Form vs. User-Defined Criteria
    ... Having Problems...I have to write some queries based on a starting ... the date in that text box and pull the date from there in my query as ... took only 20 seconds to run with the date entered in the pop-up. ... the text box and recreating it thinking I maybe messed up one of the ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)