April 2019

How To Create A MS Access Dynamic Report Based On A Dynamic Table

So in my other post, I demonstrated how to create a table dynamically with VBA. Here’s the post How To Create A Table In Access Using SQL And VBA Now what if we need a report based on a table that is always changing, but is consistent in its format? Well we can send the […]

Continue Reading

MS Access Stock Control Database Pt1

I am in the process of converting an Excel spreadsheet into an MS Access database. One of the first questions I asked was, “Are you doing this manually” and “How”. The reason is simple, I don’t want to try and figure out a new way of processing for them. If they are already used to […]

Continue Reading