Group:  Microsoft Word ยป microsoft.public.word.vba.beginners
Thread: open table command

open table command
Earlbowden 11/17/2008 9:13:02 PM
We promot code for our client once a month, and most times database tables
change. I'd like to set up a macro to open the linked table manager (found
that command), and be prompted for table names (or portions of table names)
that need to be relinked.

Is that possible, without having to write code?
Re: open table command
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/17/2008 10:16:10 PM
I assume that you are asking this question in connection with the use of
Access, not Word.

That being the case, you should ask the question in one of the
microsoft.public.access newsgroups as this one is for Word.

However, you can get the Linked Table Manager to appear automatically by
creating an Autoexec macro in Access that contains the Action "RunCommand"
and for the Command you select "LinkedTableManager"

The linked table manager will then display the tables that are already
linked to the database.

It sounds like very poor design to need to do this sort of thing however.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Earlbowden" <the_earl_of_bowden[ at ]earth.com> wrote in message
news:21F0B49F-E312-4C2D-AEAC-2FD75AEA738D[ at ]microsoft.com...
[Quoted Text]
> We promot code for our client once a month, and most times database tables
> change. I'd like to set up a macro to open the linked table manager (found
> that command), and be prompted for table names (or portions of table
> names)
> that need to be relinked.
>
> Is that possible, without having to write code?


Home | Search | Terms | Imprint
Newsgroups Reader