DLookup

How To Use The Value Of A Hidden Combo Box Column

So I had a question come my way regarding some form operations. It will probably help someone else, so I am going to let you know how I did it. Basically it had to do with setting 2 other form controls based on the first. Here is a picture: The table data is a simple […]

Continue Reading

How To restrict user logon to specific computers

This was a question I received on one of my YouTube videos. “That’s good. But how to protect this access database to be limited to certain number of PCs. Because if you copy this database to your friend and give him the password he can give it to another person and so on. What I […]

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

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




 

Call Erik Now