If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linked table manager
Ã* 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 |
#2
|
|||
|
|||
linked table manager
"VICTOR" wrote in message
... í 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 Have a look at this post on the Access Web: http://www.mvps.org/access/tables/tbl0009.htm -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access |
#3
|
|||
|
|||
linked table manager
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 2000) User_defined type not defyned. I hope that you can help me because i´ve used access just a few times |
#4
|
|||
|
|||
linked table manager
"VICTOR" wrote in message
... 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 2000) User_defined type not defyned. I hope that you can help me because i´ve used access just a few times 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 |
Thread Tools | |
Display Modes | |
|
|