John
Open the query in SQL view. If there are any parameters they'll be easier to
spot. Sometimes there is a parameter in the PARAMTERS clause that isn't being
used anywhere in the statement itself.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jfakes.rm
Sent: Friday, December 28, 2012 12:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Strange and scary happenings ...
Bill,
Thanks for the heads up on the AutoCorrect tracking issue. I always turn that
off, however, I have noticied that from time to time, a query will ask for an
old paramter that is no longer in the query and I could never figure out why.
Now I'm thinking that someone made a change to a query while AutoCorrect was
still on.
However, due to database security settings, I can't always import everything
into a clean database. I have usually just recreated the query. Is there another
way to fix this issue?
John F
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , mrsgoudge <no_reply@...>
wrote:
>
> Thanks Bill! AutoCorrect Tracking was off. Will import tomorrow.
> REALLY appreciate your input!
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" wrote:
>
> Connie
>
> First thing...make sure you have turned off the Name AutoCorrect Tracking.
This causes more harm than good.
>
> Next, import everything into a new, blank database.
>
> Hopefully, that will chase out all the gremlins.
>
> Bill Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , mrsgoudge wrote:
>
> This is a continuation of my previous post but with a different twist.
>
> Now I'm getting a different set of records :-( . It now has an error for the
same couple where previously the query returned an old unended lookingevent in
addition to a current one and now it's returning two of the current new ones.
Should be returning one current one only.
>
> I have noticed that when I've renamed a query today I'll sometimes get a
message for a parameter from the old name and when I search the SQL the old name
is not there. Cut and pasted the SQL to a new query and no problem.
>
> I'm also getting a "too many databases open" message when I do a certain
sequence of form openings, entries.
>
> I have decompiled and then compacted and repaired. Hasn't helped.
>
> What's happening???? Any thoughts on how to work through this?
> Connie
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar