admin
Mouse Click Counter On Access Form
This post will demonstrate how you can count the number of clicks on your button in a certain time frame. It will function like a game . Here is the database form all in one: Option Compare Database Public m_dteStartTime As Date Public m_dteStopTime As Date Private Sub btnClicker_Click() Dim intValue As Integer Dim rst […]
Find Error Line Number in VBA With Erl
In this post you are going to find out a way of handling errors in your code with the Erl function. Erl displays the last label before the error Another alternative error handling solution is using labels at each point in long procedure. Here we get a random error: Here is the code behind the […]
How To Open A Form To A Specific Record In Access 2016 VBA
In this post I am going to give you a basic example of how to open your Access form to a specific record. This works in all versions of Access, but we are using Access 2016 in this example. First create “parent and child” forms. In our case, it’s frmCustomers and frmOrders. Here’s “frmCustomers” Here’s […]
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 […]
Shared Access Database Management
Here is a handy setup for those who need to manage a shared access database. Either you can create this from scratch as per the example or add the new tables to your existing database. This setup will track: 1. the users currently using the database 2. what time the user and computer name currently […]
Access To PHP MySQL Tutorial
If you want to make your Access database available on your website, I would recommend you learn PHP and MySQL. Access is a file database, for desktop clients. PHP and MySQL are more native for website solutions, while Access is not really suitable for a web solution. If anyone is interested in an Access To […]
Access Database Users And Permissions Example
This post is a compilation of two of my previous posts: http://vbahowto.com/ms-access-object-security/ http://vbahowto.com/ms-access-login-form-revised/ This elaborates on the two posts a bit: First, here are all of the database objects: There are 2 tables here: tblLogin and tblAdmin Here are the main forms: frmLogin – this is the form that opens when the database opens Here […]
VBA MS Access Form Filter Example
This post is going to show you a ms access form filter sample. The database I created only has one table called “Categories”. We are going to have a form called “frmCategory”. The form is going to be a “Split Form”, because that seems to be quicker than the “main form / sub form” setup. […]
MS Access Object Security
Today’s post is based on a question that I received. We are going to assume that there are multiple users who have rights to view different database objects. So in this example there are 3 user logins with different rights to access 3 forms and 3 reports. Here is an overview of the database setup: […]
Here Is A Customized Msgbox VBA Example
Here is an example of a customized VBA Msgbox. We giving some richtext and customizable flair to the rather ordinary message box. The following code provided with the code after the screenshot, is going to provide you with the ability to really make the ordinary message box shine! Sub MsgboxVBAExamples() Dialog.Box “VBAHowTo.com is your source […]