Pages

Wednesday, 16 October 2024

Seeing VBA code in MS Access

One of my office system is still underpinned by MS Access. It is an old system which works well enough, but each year needs to be manually updated... "rolled over", if you will. 

However, this year as I was updating, I found myself unable to remember how to bring up the visual basic code (VBA) pane to review and update the underlying code and functions within the database forms. I was sure that there was a very easy way to do this - i.e. a set of hot key strokes - but for the life of me, I could not remember what they were. 

A protracted online search (largely because I could also not recall the appropriate terminology!) finally yielded me the short keys, which I will repeat here for anyone else finding themselves in this position: 

Alt +F11

Thank you to SpookiePower for asking the question, way back in 2012. Keying this will USUALLY bring up a separate VBA pane, where we can amend the underlying code. 

However, I have noted that the shortcut keys sometimes don't work; which is puzzling. As cover, I have also added in the VBA icon shown above as a custom icon in the header bar.  


Sam

References:

SpookiePower. (2012, February 11). Where to see the VBA code behind the form?. https://www.access-programmers.co.uk/forums/threads/where-to-see-the-vba-code-behind-the-form.221754/

No comments :

Post a Comment

Thanks for your feedback. The elves will post it shortly.