Thank you, Liz, for the kind words.
Thanks to you and this wonderful group! I'm looking at the stuff from the mvp site with Crystals stuff, and the vbwatchdog stuff. I've noticed my new assistant out on your thatlldoit.com site… man I am fortunate.
Thanks Bill, Crystal, John, ---everyone!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 19, 2014 8:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: query filter drop down difference
Sounds like you have all the bases covered, Liz.
Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Hi Bill, I currently have code that inserts who, when, and which database to tables which I can then look at to see who is still logged in etc. I also have a checkforceout with a prevent login, ask user to exit, and force out respectively from timer events on a hidden form. Not sure if I got these ideas from you or someone else, but it's been working for me for several years. I also have a logstats file so I can see historically who had been logged in to which databases and when.
Thanks.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 15, 2014 8:14 PM
To: MS_Access_Professionals@yahoogroups.com; 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: query filter drop down difference
Liz
Take a look at my showusers app
Regards,
Bill Mosca
From: "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Fri Aug 15 14:07:30 PDT 2014
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Re: query filter drop down difference
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.
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.
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: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (24) |
Tidak ada komentar:
Posting Komentar