linked table manager

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

í want to know if there is a way to refresh the linked table automatically, i mean by a macro or something
and how can a i make this, thanks for your answers
 
VICTOR said:
Excuse me, where do i need to put the code (fRefreshLinks) to run it ?
I´ve inserted it in a module and appears a Compile error (i´m using acces
Click to expand...
2000) User_defined type not defyned.
I hope that you can help me because i´ve used access just a few times
Click to expand...

Remember to also include GetOpenFileName:

http://www.mvps.org/access/api/api0001.htm

and put it in a module, or you will have errors. Make sure you read all the
instructions that go with both of them.

I happened to test these 2 modules last Monday, unaltered and directly from
the web pages. I put a command button on the opening form and set its Click
property to:

= fRefreshLinks()

And it ran perfectly in both Access 97 and 2002.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top