Link to Spreadsheet problem

  • Thread starter Thread starter golfinray
  • Start date Start date
G

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!!!
 
Can I make it automatically relink? Is there a command or routine for that?
Thanks!
--
Milton Purdy
ACCESS
State of Arkansas


Ken Snell MVP said:
Relink to that spreadsheet and it will refresh.
Click to expand...
 
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/


golfinray said:
Can I make it automatically relink? Is there a command or routine for
that?
Thanks!
Click to expand...
 
Back
Top