Archive for August, 2013


VBA Building Dynamic SQL

This video example is going to show you how to generate a SQL string from a form in VBA. 1 Click here for the database and the code: Building-Dynamic-SQL.mdb

Read More...
Click Here And Visit Our Store!

Helpful? Consider giving us a tip. Thanks!

($5 suggested amount)
(...10% of your gift amount will go to charity)










Need help? Click and Call LoeblCom Services

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 […]

Read More...
Click Here And Visit Our Store!

Helpful? Consider giving us a tip. Thanks!

($5 suggested amount)
(...10% of your gift amount will go to charity)










Need help? Click and Call LoeblCom Services

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 […]

Read More...

Excel VBA Read Text File

So how can you import the contents of a csv or text file into your Excel worksheet: Find out: 1 Click here for the file: VBA Read Excel File.zip

Read More...

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 […]

Read More...

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… 1 Click here for the database and the code: vba-move-file.mdb

Read More...

Access VBA Create Table

This example is a response from an email I received regarding: “How to build a table by extracting some fields from a main database…” I interpret it as: “Query a main database (mainframe) and create a local table.” Take a look, and get the example database below: 1 Click here for the database and the […]

Read More...

Being More Specific In Access Import

In this video will help you be more specific in your access import. You will find out how to insert a name of the table you want to import. 1 Click here for the database and the code: Access-Import-Table.mdb

Read More...

Shell VBA function

Did you know that you can use the Shell VBA function to launch external applications? 1 Click here for the database and the code: Shell VBA function

Read More...