I am making a multi user application with a central database server. i am displaying some data on a visual basic form, now if another user updates some data on the database i want the changes to immediately show on the vb form. I was trying to do this using dynamic recordset, and i see that if someone insert a new row it is reflected in the recordset but there is no event in recordset which will tell me the someone has inserted new data or changed data.
How can i know in my application that someone have inserted or updated some data in the database so that i can refresh my VB form.
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.