Link to Spreadsheet problem

[golfinray]

I have command buttons (2) on a from that take the user to Excel sheets for
reference purposes. If they need to look up details on a project, they can
click and view the spreadsheet from the form. I linked the spreadsheet with
the linked table manager. The problem: is there a way to automatically
refresh that link? When the spreadsheet is updated, it does not seem to
automatically refresh. Thanks, so much!!!

 

[Ken Snell MVP]

Relink to that spreadsheet and it will refresh.

 

[golfinray]

Can I make it automatically relink? Is there a command or routine for that?
Thanks!
--
Milton Purdy
ACCESS
State of Arkansas

Relink to that spreadsheet and it will refresh.

 

[Ken Snell MVP]

Yes, see TransferSpreadsheet action in VBA Help; it has an argument to let
you link to the spredsheet instead of import the spreadsheet. You can delete
the original link by using the DoCmd.Delete action first.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Can I make it automatically relink? Is there a command or routine for
that?
Thanks!