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
Highlighted
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
Highlighted

@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