Recent content by Torben Villumsen

I was able to solve this by modifying some VBA-code I found. In principle you have a vba-code, which remove the ole-object and then insert it again. I do this in a database each day. By doing this your are forcing access to update the ole-object. I can not remember who made the original code...

Hi Holz. I solved this in the meantime.:)

Hi Holz, I am having the same problem. I searched several forums, but I can not find a solution to this problem. Did you find a solution? Is so I would really appreciate any help. Thanks.

Thanks for your replies. Jdrew your last post seems like the right solution. I will test that solution. Thanks.:)

Thanks for your reply. The data is sorted by name and then by date. The issues is that I have all my securities in one large table. But I want to create a new table but only with the latest 60 days closing prices for each stock. If I just take top 60 (in this case it should be bottom 60) I will...

I have a large table with approx. 1000 different securities with daily closing pricess for approx. 5 years. The Securities are sorted by name and then by date so that the latest date is the last one. I need a query that can give me the last 60 days closing prices for each security. Therefore...