Recent content by joswald

Paul: Works like a charm. Had lost sight of the fact that qryTemp was in fact a named QueryDef object, so OpenQuery would work. CJ: Don't appear to need the extra lines, but they might be good just to finish things off more cleanly. Thanks to both of you for the suggestions.

CJ: If I understand your second solution correctly, it would work primarily to just display the results of the query in the subform. What I would really like is a way to open the query in the Access query window so that I can toggle back and forth among Datasheet, SQL and Design views. That...

CJ: The queries do not exist as separately named objects in the database; they only exist as SQL strings in the table. According Database Journal article 3505836 (sorry, I can't paste the link, my post count isn't high enough) "raw SQL" like this can not be handled by OpenQuery. I explained...

Hi Paul: Most of the queries are already paramaterized select queries. But the table actually contains a wide variety of different kinds of queries, all of which I would still like a convenient way to open and display. At the risk sidetracking my original question, below is a description of how...

I have a table that holds the SQL texts for ca. 1000 Select queries (mostly minor variants that are used to programmatically swap out RowSource strings for combo boxes). I'd like to have a quick and easy way to open/review/modify these queries. One strategy would be to display the SQL strings...

Hi, I'm a university faculty member in the field of entomology (that bugs...). I have been using Access since 1996 for personal management of the data associated with my academic research projects (particularly for management of the data behind the web-based Lacewing Digital Library project). I...