admin
MS Access Beginner To Advance Propulsion
Hi, I received an interesting email that I wanted to pass on, because I think it may help some of you in the same situation. Hi Erik, After I go through your course, is there any chance you could provide additional training, such as a small project I could work on with your guidance that […]
Resolution – VBA Error 49 – Bad DLL Calling Convention
So everything in this particular database was working for a client of mine, until just last night I get notified that he can’t open the database because of some error. I was able to view his screen using T.V. and after clicking on a command button, I would get the following error: “Error 49 – […]
MS Access VBA – How To Add A ‘Select All’ Option To A Combo Box
Normally with a combo box, you can select only 1 item in the drop down list. But what happens when you want to “Select All” the items in the list? I have done this 2 different ways, 1 way is to put a checkbox on the form, called “All”, and then have the combo box […]
How to create SQL Statement from Combobox Selections
This video will show you how to use checkboxes to create a SQL statement and formulate a recordsource for a form. In the sample database, a certain product can be combined with other products to create a package. We want to select the products belonging to each package. In this video you will be shown […]
How To Convert Macros To VBA
This video describes how to use an embedded macro to open a form, and then use the superior, VBA, code to do the same. video: There is more functionality when using VBA to do your actions. Personally, I don’t use macros, unless I need to. If you want to try and convert your macros to […]
Converting a macro into VBA code
I received this email the other day… “Only you can clarify this for me. I’m a little confused and frustrated following the attached video and Database and not be able to do the macro conversion into Access 2007 and 2013 also. Is there any solution doing it by VBA program ?” Hopefully my response can […]
MS Access Running Counter In Query
This video is part of a solution to an interesting question that I know most developers have faced or are facing… “How can I number my rows in an Access query?” tblRunningSum: Lists numbers starting with 8, and shows how qryIncrement can start at 1 and increment this count from 1 to 10. tblNumbers: Gives […]
MS Access Option Group QA
This video is in response per a question about the ms access option group I received: “Hello, I have a question: can we store a decimal value in the option value?? Like if I want to put the value of yes = 0.25 and No= 1.25 is it applicable?? please help” Take a look at […]
Access Report Parameters
Dear Sir can you give me any sample database file or access vba code where report can filter by chose Interim date and select single customer data range. like “Jon” buy how mane thing from 1/1/13 to 30/1/13 where jon is my customer I just wane vba code for the command button oh i will […]
VBA Move File
So you need to end off a procedure by moving a file? This video shows you how to use the FileSystemObject and vba to move a file out of one directory into another? Well, this video shows you how to do it… Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK […]