Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

In my continuing AI adventures, I have decided to attempt to use a tool called Augment Code which can analyze and index my code base via Visual Studio Code.

Visual Studio Code: An open source Code Editing IDE for multiple languages with a large number of extensions. I’ve never used this before and it definitely has a learning curve in trying to set it up. So far I’ve been able to point it at a source control folder and it sees my files.

VS Code Extensions:

  • Augment (I created a trial account at AugmentCode.com to try it out): This is the AI magic, Users have reported it is much better than Github Copilot which is the AI I usually see associated with VS Code.
  • VBA Pro – I’m really wanting syntax highlighting, and this is supposed to offer that and more with Language Server features (I’m sorry to say I don’t know exactly what that means yet) although I haven’t been able to get it to highlight my OASIS exported files with a *.def extension for the VBA code. I asked CoPilot how to get that to work and it gave me incorrect instructions.
  • SVN – This extension works with SVN servers so supposedly I’ll be able to update and commit my changes right from within VS Code. Not sure that matters that much.

The bigger thing is that it would be nice to automate my Access database OASIS add in so that when I save a file in VS Code it imports it into my database automatically so I can test it there. Right now, if I save a file, I’ll have to manually import that object into my database using the OASIS SVN add-in.

The Augment plugin was able to import my code though and give me a summary of a project I had in there.

Additionally, I’m hoping I’ll be able to add the AJS library I’m using in the project and have it know about that code as well and that it’s in a different Access file.

In any case, soon I’ll have figured out how to configure and use these tools and I’ll be off to the races.

Sign up For a Daily Email Adventure in Microsoft Access

Every business day (typically M-F), I'll send you an email with information about my ongoing journey as an advanced Access application developer. It will be loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.