admin
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 […]
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 […]
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 […]
Excel VBA Read Text File
So how can you import the contents of a csv or text file into your Excel worksheet: Find out: ‘======================================================== ‘DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Sub query_text_file() ‘PURPOSE: Query A Text File ‘************************************* ‘clear ‘Text File Contents’ worksheet ‘************************************* Worksheets("Text File Contents").Select Range("A2:K6500").Clear ‘************************************* ‘now populate […]
VBA Read Excel File
Here is a question I received “Thanks for the video, I have a question.How to read from a group of closed excel files searching for a certain value in say column F then if that value is found then copy that row to a workbook and continue search for then next value ” So I […]
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 By the way, if you got or are getting value from the VBA information, please click the “Donate” button to give me a small […]
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 […]
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 […]
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 […]
MS Access Validation – PT2
Table & form validation rules can be set at the table level or form level. Use the power of the database to manage your form validation. Why spending time coding something that the database can already handle for you? Remember that a validation rule created at the table level is available to all the forms […]