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
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.
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