Link problem

[ersatz]

Hi,
I want to know the equivalent for ActiveWorkbook.SetLinkOnData excel in ms access 97.
Anybody know that?
Thanks in advance

 

[scking]

There is no equivalent. Are you asking how to refresh table links in VB code, or how to create table links to other tables in VB code, or what? You could probably find this by search the FAQ or searching the forum for refresh or links.
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[ersatz]

Hi,
I want to make a link from ms access to Reuter like this excel-Reuters link:

Sub HotLink()
Rem Initialize the number of updates to zero and display in cell B2
UpdateCount = 0
ActiveSheet.Cells(2, 2) = UpdateCount
Rem Create a hot link and place it in cell A2
ActiveSheet.Cells(2, 1) = "=REUTER|IDN!’IBM,LAST’"
Rem Cause the procedure "Count" to be called when each update is received
ActiveWorkbook.SetLinkOnData "REUTER|IDN!’IBM,LAST’", "Count"

End Sub

Thanks again

 

[scking]

Access does not have either cells or hotlinks. It can however connect to a database and run queries to get information, like count, which it would then display on a form. Create a link to the REUTERS database by using file/external/link and create the query or SQL to get the count (DCount) information. Not knowing exactly what information is provided in the Excel link I can give you exact answers.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[ersatz]

Hi,
I want to have a textbox (not a cell) in an access form with link to Reuters(Text1.text="REUTER|IDN!’IBM,LAST’".
I can do that but my data in the text box don't update when data changes. For that I must select the automation link from Edit/OLE/DDE Link, which is inactive.
That is a problem for me.

 

[scking]

If you are in a form you could refresh the value based on a timer event. Even though it wouldn't automatically recognize the change of value if it were refreshed each second you wouldn't probably even be aware of the difference.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------