Bill, thanks so much. I'll have to do this in the morning as I'm off to the eye doctor right now. Also, I need to kick about a dozen users out of the database to do the compact/repair, but I'll do that in the morning too.
We'll chat soon.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 15, 2014 2:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: query filter drop down difference
Liz
I've uploaded the 2 images. Let's do some debugging.
1. create a new query from scratch.
2. Open it in SQL view and see if it matches the original query
3. check to see if you can get the filter to work in the new query.
4. run a compact on the database just in case it's a busted index or something.
Post the SQL just in case it might help us, but it could be the query is broken.
Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Pros, I have a query that has a single parameter input for the criteria.
When I run it with the response to [Enter program code:] of "EKB", I can click on the little arrow down button and it has the little filter boxes to check and uncheck. If I answer "EKA", there are no little filter boxes, only "filter by."
Would anyone know why? Is there a limit to how many filter selections there could be?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (18) |
Tidak ada komentar:
Posting Komentar