Home

Missing Query

%3CLINGO-SUB%20id%3D%22lingo-sub-849338%22%20slang%3D%22en-US%22%3EMissing%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849338%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20upgrading%20to%20Office%20365%2C%20one%20of%20my%20queries%20is%20not%20listed%20in%20the%20Objects%20list.%26nbsp%3B%20Other%20queries%20are.%26nbsp%3B%20The%20form%20that%20calls%20the%20query%20in%20question%20still%20works%20normally%2C%20and%20returns%20proper%20results%20when%20used.%26nbsp%3B%20I%20cannot%20open%20the%20query%20to%20make%20changes%20to%20it%20(%20add%2Fremove%20tables%2C%20columns%2C%20etc)%2C%20as%20it%20is%20not%20in%20the%20list.%26nbsp%3B%20How%20do%20I%20find%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-849338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853177%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407420%22%20target%3D%22_blank%22%3E%40DMurphy1254%3C%2FA%3E%26nbsp%3BMaybe%20you%20have%20deleted%20the%20query%20but%20the%20SQL%20of%20the%20query%20has%20being%20transferred%20to%20the%20VBA%20code%20of%20the%20form..that's%20why%20it%20works%3C%2FP%3E%3C%2FLINGO-BODY%3E
DMurphy1254
Occasional Visitor

After upgrading to Office 365, one of my queries is not listed in the Objects list.  Other queries are.  The form that calls the query in question still works normally, and returns proper results when used.  I cannot open the query to make changes to it ( add/remove tables, columns, etc), as it is not in the list.  How do I find it?

1 Reply

@DMurphy1254 Maybe you have deleted the query but the SQL of the query has being transferred to the VBA code of the form..that's why it works

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies