Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save robwelan/69a0a31bf72fda4d1b950a4d6db3486c to your computer and use it in GitHub Desktop.
Save robwelan/69a0a31bf72fda4d1b950a4d6db3486c to your computer and use it in GitHub Desktop.
<table style="width:90%" border="1" cellPadding="8" align="center">
<tbody>
<tr>
<td>
<aside>TIP: what if you need to modify one of your queries, or, create a new query based on an existing query that is contained in the tblOfQueries Table? It&#x27;s easy! Locate the query you need to work on or work with. Copy the query string that is in the qryString field. Now create a new query in Microsoft Access® in the normal way. Change to the SQL view of the query design space. Now replace whatever is there by pasting the string from the clipboard into the SQL area. Now change back to the design view. Unless you&#x27;re using something fancy like a UNION query, your regular query design space should be painted in the usual fashion with tables and criteria and such. One of the reasons I love Microsoft Access® so much! Make your changes and apply them back to the tblOfQueries by reverting back to the SQL view and copying the query from there back into the appropriate record in the tblOfQueries.</aside>
</td>
</tr>
</tbody>
</table>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment