FindFirst

How To Restart A VBA Loop Counter

This is related to an interesting question I received from an individual, and this processing example may help someone. Basically we are conducting a 10 day clinical study on a group of patients. We want to store the results of the finding in a database and reset the study counter when a result comes back […]

Continue Reading

How To Identify The Last Row Worked On (VBA Variable Scope)

So, I had an interesting question regarding how to find the last row the user was working on before the closed the form, so when the reopen the form, they could continue to work on that record. (This is actually expanding on an example I showed: http://vbahowto.com/how-to-highlight-the-current-row-in-a-continuous-form-in-3-steps/) The the following code will demonstrate one way […]

Continue Reading