October 2020
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: https://vbahowto.com/ms-access-object-security/ https://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 […]
How To Use A Variable In A VBA Message Box.
In this post I’m going to show you how to use a variable in a vba message box. This is used commonly to notify the user that an entered item in a combo box is not in the list, also per this post it’s to display the error number or the error description to the […]
How To Make A VBA Msgbox Yes No
You can use a VBA Msgbox Yes No to get guidance from the user an the control your program’s flow In the following example I am asking the user to confirm whether or not they want to continue. I am storing the answer in the integer variable intAnswer, and then my algorithm processes their answer […]
VBA Msgbox New Line Example
Here is an example of a vba msgbox with new line Sub VBAMsgboxNewLine() Dim strText As String ‘Here I am using the enum version of the character feed. ‘strText = “Please try your operation ” & vbCrLf & ” again” ‘Chr(10) and Chr(13) do pretty much the same thing in VBA ‘Chr(10) is a […]
Here Is An Example Of The VBA Trim Function
The “Trim” function is useful in eliminating the blank spaces in a string normally caused by some data entry error. Why do you want to do this? Well because a sorting error can happen if you are trying to sort ” Dan, “Fred”, and “Ann”. ” Dan” will show up on top before “Ann” because […]