Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Monday, November 17, 2014 – Permalink –
Quickly Query Table Names
Change by code
If you've ever developed a dozen or more complex queries, then had to change one of the table names, you know how frustrating it can be to all but rebuild the queries in the Query Design view grid by changing the table name in each cell.
One quick alternative is to choose View >SQL View while the query is open and then cut and paste all the SQL code into Word.
Next, do a Find and Replace, changing all the instances of the old table name to the new table name.
Finally, copy and paste the SQL statements back into the SQL view of your Access queries.
When you go back to the QBE, the new table will replace the old one.
See all Topics access
<Doug Klippert@ 3:15 AM
Comments: Post a Comment