Rocky Smolin
rockysmolin at bchacc.com
Mon Nov 29 12:26:47 CST 2010
Does anyone know the answer to this question? TIA Rocky _____ From: Hartje, Charles [mailto:CHartje at sandiego.gov] Sent: Monday, November 29, 2010 10:14 AM To: Barry Hynum; 'Doug Murphy'; 'Bob_Heygood'; Hartje, Charles; 'Darrell Burns'; 'Dixon'; 'Jackie Murphy'; 'JKA Joe K Anderson'; 'Mike Dwyer'; 'Polly Arndt'; 'Rocky Smolin' Subject: Refresh QueryDefs? Group, Oftentimes when I'm working in the VBE with a new query I've created using the query designer, I get an error that says the (query) object isn't found. I figure the error occurs because the QueryDefs collection doesn't yet contain the new query. Restarting the database always fixes the problem - but what a nuisance. If it were just a matter of refreshing the collection, you'd expect to be able to run a line of code from the immediate window such as: Currentdb().QueryDefs.Refresh But that doesn't take care of the problem. I still have to close and restart the database if I want to work with the new query from the VBE using the DAO Recordset object. Does anyone know of a solution. Charles Hartje City of San Diego | Engineering and Capital Projects Project Implementation and Technical Services | Information Systems - Engineering Application Support Ph: 619.533.5131 Mobile: 619.609.5023 email: <mailto:lbobis at sandiego.gov> chartje at sandiego.gov "Working Together to Engineer a Better Tomorrow"