VBA Variable Scope

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

A Variable Scope

Key points: A private procedure can be called from any procedure in the same module. The default scope for a sub procedure is “Public” unless you specifically designate it as Private. Store all your procedures and functions you plan to use in your application in “Modules”, which you can call from your other database objects. […]

Continue Reading