It will be much easier to follow this tutorial if you refer to the workbook.
The stock information for the Active Range will come from Yahoo Finance.
Each of these current solutions have drawbacks to them For #1, you need to distribute a DLL alongside your product.
For #2, as discussed in the Microsoft KB article, the VBA subclassing solution is not advisable due to problems that can occur if the VBE window is open.
This is quite an annoyance when you might not want this behaviour, and Microsoft never offered a simple solution to turn this feature off (until v2007).
There are other solutions such as forcing the currently displayed record to always be in edit mode, but we won't discuss them here - they have their own drawbacks too.
The data in the timesheet only seems to update to a certain point from the "data workbook". Sorry, have tried to explain it has simply as possible.
The timesheet contains filters which work in alphabetical order and only update until the letter T. Thanks, Brit I've made an excel-file that has many hyperlinks to word-documents.Also, your forms will take a performance hit since every window message goes through the relatively inefficient VBA subsystem.My solution is to use the subclassing method as described in the VBA article above, but rather than use a VBA subroutine as the callback procedure, I use a native machine code compiled procedure (read the technical stuff below if you want to understand how this is achieved).UPDATE v1.5: 04/12/2009 -- now the Init and Scroll object methods are case insensitive (fixes potential "Object does not support..." errors) This solution is being provided for free and you can use this solution in your applications freely provided you leave the copyright notices in place in the source code.In Access versions prior to v2007, when you use the mouse scroll wheel on a form, Access will always cycle through the current records in your forms dataset.A few new events have been added, but the overall structure of the event system is unchanged.