Strange Problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This program was written by other people.
there are fifty buttons. One button one import.
program logic works like this.
1) press button "CIO"
2) copyobject "","CIO", actable, "CIO EMPTY"
3) do something. RUN queries. ("CIOSUMMARY")
4) When done deleteobject actable, "CIO"

This is the logic uesed on most of the buttons. Keep in mind the copyobject
and deleteobject. I believe they are the keys to my problem.

They problem is this. The Join's in the CIOSUMMARY query are removed. ????
It looks like to me that something in Access is causing Access to
re-evaluate the queries. If the query is found to be broken then it is
"Fixed"???

Example: CIOSUMMARY has two tables(CIO and Maginfo) they are joined by the
MCODE. Since the table CIO does not exist and "joins" cann't link nothing to
a table then the "join" gets deleted and because of that some fields get
renamed.

Results, the query works differently if at all.

The Questions:
What causes Access to re-evaluate queries?
Can I stop it?
Am I missing something here?

Scott Burke
 
Hello Scott.

Scott said:
This program was written by other people.
there are fifty buttons. One button one import.
program logic works like this.
1) press button "CIO"
2) copyobject "","CIO", actable, "CIO EMPTY"
3) do something. RUN queries. ("CIOSUMMARY")
4) When done deleteobject actable, "CIO"

This is the logic used on most of the buttons. Keep in mind the
copyobject and deleteobject. I believe they are the keys to my problem.

They problem is this.
The Join's in the CIOSUMMARY query are removed. ????
It looks like to me that something in Access is causing Access
to re-evaluate the queries. If the query is found to be broken then
it is "Fixed"???
Click to expand...

Check under "Tools, Options, tab: General" if objectname-autocorrection
is enabled, and if so, disable it. This yould be the solution.
 
Wolfgang. I looked for the feature but can't find anything with
"Autocorrect" in it. The help file only shows "Autocorrect" text and data.

I will keep looking?
Scott Burke
 
Hello Scott.

Wolfgang. I looked for the feature but can't find anything with
"Autocorrect" in it. The help file only shows "Autocorrect" text and
data.
Click to expand...

Then you probably don't have Access 2003...
Well, then don't delete the CIO table. Or don't open the design window
of the query when the table is gone. I guess, the query CIOSUMMARY
contains a link to the CIO table. If the CIO table is gone and you open
the query, CIO and the joins of course cannot be displayed.

In the debug window (provided that you use dao for data access), try:
?currentdb.querydefs("CIOSUMMARY").sql

This should show the sql command of the query, and it should still
contain the CIO table and the join, even if the table is gone.
 
Hi Wolfgang. Remember, I did not write the software. I just maintain it.
The only way I know what table a query was using was to open the query in
disign mode. Of couse it too late after that.!.

I was hoping that someone somewhere had to deal with this problem and that
he/she found a way to stop it.

hooo well. It looks like I going to be making a lot of changes in the near
future.

Thank again.
Scott Burke
 
Back
Top