The grid has become empty ! My queries were quite complicated (with subqueries etc), not easy to rebuild by just draging field names. What is strange is that i executed the queries but did not open them in design view. I really have no idea of what happened (the same happened on 20 different queries, probably after having executing them toward an excel file as output...
GC -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] De la part de Lonnie Johnson Envoyé : jeudi 3 août 2006 13:18 À : [email protected] Objet : Re: [ms_access] self destructing query ? Instead of SQL view go to design view. Are there any fields in the grid? If not drag them back down. You can go on forever trying to figure out how they were lost. Could have been an accident with the space bar or the delete button. Clauss Gilbert <[EMAIL PROTECTED]> wrote: Has anybody ever had this bug : A query, which usually works fine, suddenly answers (approximately, translated from french) : "The query must have at least one target field". When i try to see the SQL code, actually there is only "select;", the rest of the statement has disapeared. I'm sure i did not (or anybody else) modify the query, nor the data...Strange Any tip ? Thank you Gilbert Clauss May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail Beta. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
