Query disappears

M

mcgady

After Importing (from *.txt) then Exporting (*.xls) data the contents of my
query disappears. The query object does not get deleted but its substance is
gone. What is happening and how can this be fixed.
 
J

Jeff Boyce

Import and Export pertains to data. If your query definition still exists,
but returns no rows, perhaps no rows meet the query's selection criteria?
 
M

mcgady

The events that cause this phenomenon are a bit mysiterious. I do know that
the Import (which is done via a macro) and the Export (also via a macro) will
cause the query to "disappear".
The Export macro uses the query to do the export.
Also, the disappearing act will not happen if I simply look at the query in
Design/SQL view in between the Import and Export.
If I do the Import and export without looking at the query in between, the
query disappears.



The Import is probably insignificant. The point is that some action is
taken (
 
J

Jeff Boyce

Sorry, I still don't have enough to hazard a guess from.

What happens if you run the query before Import?

Jeff Boyce
<Access MVP>
 
M

mcgady

I sent a detailed email to you ...msn.com. The .mdb is attached. Thanks for
helping.
 
J

Jeff Boyce

I don't respond to unsolicited emails -- I have no way to verify their
safety. And my work here in the newsgroups is voluntary, as is most
everyone else's. If you are looking for paid support, ... <g>

Keep the Q & A in the newsgroup, that all might benefit.
 
Top