MS Access Forms

How To Return A Dollar Value As A Text String

Hi, I received an interesting request, involving VBA and how to return a stock price dollar value in a text character string rather that actual numbers. Like (I=1,M=2,E=0) instead of showing cost price is 12.00 it shows IM.EE. Kind of like code returning a special code. Well, here is my rendition of it. It may […]

Continue Reading

Access Pagination

I have a client who has an underperforming continuous form so I start tinkering around with a model, and created an Access continuous form with pagination abilities. The database is attached. Hopefully it can help you. I will probably be modifying it as needed. [sourcecode language=”vb”] Option Compare Database ‘code 2014 by http://loeblcomservices.com ‘contact: erik@loeblcomservices.com […]

Continue Reading

MS Access Hiding Text Boxes Based On User Selection VBA

I received an email from a guy to the effect of wanting to hide some textboxes based on a value entered into a single textbox. In my answer, I came up with a way to do this, and decided to share it with you… This example will show you how to hide the textboxes on […]

Continue Reading

How To Write A Recordset To File With VBA

In this video you’ll find out how to write a recordset to a file with VBA using the Microsoft Scripting Object. You’ll find out how to take your table data, and export it to a csv formatted file so you can share it with other applications. Use this method to get your data out of […]

Continue Reading

VBA Building Dynamic SQL

This video example is going to show you how to generate a SQL string from a form in VBA. [sourcecode language=”vb”] ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Option Compare Database ================ form: ================ Private Sub btnFindStocks_Click() Dim strWhere As String Dim strSQL As String Dim […]

Continue Reading

MS Access Form Calculation On Checked Items

In this video you will learn how to perform a calculation on checked items in your MS Access form Get the database here: MS Access Form Calculation On Checked Items Database

Continue Reading

How To Have MS Access Increment A Number Without An Autonumber VBA

So I had an interesting question come my way today via the chatbox on this website. Basically it was to increment a value in a label based on the button that was clicked. Here is what part of the form looked like: The data was saved and read from this table: So if the green […]

Continue Reading

How To Use 2 Access Checkboxes Update 1 Field

Here is an answer to another interesting question which came to me involving “Access Checkboxes”. I have created a number of yes/no instances … but when i drag in the control button it is only a button to either click or not click. I want to have a checkmark where you click yes or you […]

Continue Reading

VBA Debug Part 2

In this video I talk about VBA Debug aspects like the Immediate Window, Local Window and Watch Window. …also we use the “debug.print” statement to print a value to the Immediate window. The Local Window is useful to view the current state of all the variables present in the current sub procedure. The Watch Window […]

Continue Reading

MS Access Validation – PT2 (explained)

In my video called “MS Access Validation – PT2”, I used a lot of controls and went through them really quickly, I couldn’t show completely what was going on in the design or where I found some of the settings I used. This video explain better. Watch it now! You can get the VBA code […]

Continue Reading




 

Call Erik Now