|
Title: how to refresh data after odbc update Post by: Toot on June 11, 2010, 11:08:50 AM Hi,
I know my question is going to be a little off topic. I need to refresh a MSaccess database subform after new data was transferred with the TCP/IP data logger software with the ODBC plugin. Right now i am using a timer that refreshes the whole form. Not an ideal situation. What i need is a refresh trigger (VBA or thru ODBC or something) that is triggered as soon an new data enters the data base. Maybe i need to find other way of transferring the data? DDE? The nice thing about ODBC is that i can even close the application but still recieve data in the database. Now only if i could find a way to refresh when new data arrives. who can help me with this one? Thanks in adance. Otto Title: Re: how to refresh data after odbc update Post by: Arthur Grasin on June 11, 2010, 11:31:13 AM You can activate and use the DDE Server. You should link your form with one of DDE items (for example date/time stamp). You'll receive a notification when this item will be updated and refresh your table.
Title: Re: how to refresh data after odbc update Post by: Toot on June 12, 2010, 12:28:16 AM Thanks,
I've looked in the tutorial but could not find a good example on how to do this. How do i refer to a DDE link in MSaccess? Otto |