VBA code-set focus to Tables in database window

  • Thread starter Thread starter avarga
  • Start date Start date
A

avarga

I have code in a form_load event which displays a dialog box asking if
a particular table link has been refreshed (to point to an Excel file
based on a weekly date). If no, the form does not open.

I would like the next step to be to put the user back in the database
window viewing Tables, as a convenience for using the linked table
manager. Which command/method can I use to do this?

Thanks, Alan
 
Use SelectObject with True for the InDatabaseWindow argument.
 
That did the trick! I appreciate the link to your tips as well; really
good information there. Thanks, Allen

Alan Varga
 
You must log in or register to reply here.

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

Change one table link by vba 1
Ghost references to deleted tables in a back end database (Access2000 XP) 5
How to export table from outlook into ms access table? 0
Search access Macros, Forms and VBA code for a specific table references 2
switch focus to query through VBA 3
What are the steps to fix damaged MDF files in SQL Server? 0
Replacing a Table with a Table from another database - reference issues 1
Change linked tables in replicated database 1

Back
Top