Prompt Query Error

  • Thread starter Thread starter bthiessen
  • Start date Start date
B

bthiessen

I have a query with a basic prompt, but sometimes when I run it, after
entering a value, the prompt reappears and will not accept any value I
enter. Sometimes the query and the prompt work just fine, sometimes it
just repeats the prompt until I escape out.
 
I have a query with a basic prompt, but sometimes when I run it, after
entering a value, the prompt reappears and will not accept any value I
enter. Sometimes the query and the prompt work just fine, sometimes it
just repeats the prompt until I escape out.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A guess: You have sorted or filtered the query multiple times & then
closed the query & clicked Yes to the prompt "Save changes to the
query." If so, whenever you re-run the query the filters & sorts will
be applied. For each filter/sort the prompt appears. To fix: Open the
query & enter any value for all the prompts. When the result appears
right-click the results grid & select Remove Filter/Sort on the pop up
menu. Close & save the query. The next time you run the query, when
closing, don't click the Yes button to save changes to the query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9qHwYechKqOuFEgEQIKIwCg1wCfFvppkv2M8/UTnP9FuJi841EAoLes
GyZADYg/amNbQZl7cn9Rz6x2
=RN2Q
-----END PGP SIGNATURE-----
 
Back
Top