How to refresh a project?

G

Guest

I have an Access project (ADP) that creates a table via intermediate queries
(views) and VBA code, then renames the table according to
previously-specified parameters. However, the statement:

DoCmd.Rename strTableNew, acTable, strTableTemp

fails unless I first pause execution and manually refresh the project window
in Access (using F5). Can I execute this refresh in code, instead?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refresh (programmatically) an ADP project's knowledge about views and stored procedures? 16
ADODB from Excel - Running a Query 1
Newly created Views not visible to Access until after pressed F5 2
How to auto refresh a webpage ? 7
how to update a table with a form in ADP? 3
ADP bound form refresh after subform record delete? 5
Refresh a view from code 0
How to optimize a query called in code VBA 6

Top