ChDir and IN Clause of Access Query
Posted On 14 May 2012 By a.p.r.pillai. Under Functions.
Last week we have learned how to change the Directory Path control of VBA to the CurrentProject.Path (active database’s location) with the use of ChDrive() and ChDir() Commands, without altering ... Continue Reading
No Comments
Microsoft DOS Commands in VBA-2
Posted On 05 May 2012 By a.p.r.pillai. Under Functions.
With the MkDir() Command we were able to create a folder on disk, with the help of a small VBA routine that we have written last week. We don’t even ... Continue Reading
No Comments
Microsoft DOS Commands in VBA
Posted On 24 Apr 2012 By a.p.r.pillai. Under Functions.
Continued from last week’s Article: Disk Operating System Commands in VBA. Once we determine the presence of a file in a folder with the Dir() Command we can do ... Continue Reading
1 Comments
Disk Operating System Commands in VBA
Posted On 13 Apr 2012 By a.p.r.pillai. Under Functions.
The first edition of Microsoft Disk Operating System (MS-DOS 1.0) was launched in 1982. The first edition of Microsoft Windows 1.0 Operating System, Disk Operating system with Graphical User Interface ... Continue Reading
No Comments
Calculating Time Difference
Posted On 21 Mar 2012 By a.p.r.pillai. Under Functions.
How do we calculate difference of time in Hours, Minutes and Seconds between two time period? The time period can be on the same date or across dates. ... Continue Reading
No Comments
Writing VBA-Code with VBA
Posted On 20 Nov 2011 By a.p.r.pillai. Under Functions.
To insert an Event Procedure in a Form or Report we will open the VBA Module and write the code manually. If we open the Class Module through the Event ... Continue Reading
No Comments
IIF vs SWITCH Function in MS-Access
Posted On 25 Sep 2011 By a.p.r.pillai. Under Functions.
The IIF() Function definition is reproduced here from Microsoft Visual Basic for Applicatiions Reference below: IIf Function Returns one of two parts, depending on the ... Continue Reading
3 Comments
iSeries Date in Imported Data
Posted On 09 Jul 2011 By a.p.r.pillai. Under Functions.
If you have IBM iSeries Machine (IBM AS400) and taking raw data from there for customized report preparation in Microsoft Access then you might have noticed that the date value ... Continue Reading
No Comments
Join Split Array Functions-2
This is the continuation of last week's Article: Join Split Array Functions If you have not gone through the fundamentals of the above functions then please do that, by ... Continue Reading
No Comments
Join Split Array Functions
Posted On 12 Nov 2010 By a.p.r.pillai. Under Functions.
The above MS-Access functions are not so popular or used frequently in programs, but their usage is very interesting and powerful too. Let us take one by one and learn ... Continue Reading
No Comments
User Defined Data Type
VBA have several predefined data types like Integer, String, Date and so on to use in Programs. These can be used to hold only one type of data in them. ... Continue Reading
No Comments
Text Search Filter Web Style
Posted On 20 Dec 2009 By a.p.r.pillai. Under Functions.
How to search for several pieces of information across all the fields and in all the records of a Table?
For example, when we search for something on the Web we give several piece of text separated with , or + symbol to match any of the given text anywhere within the Web Pages and display the matching links on the screen.
3 Comments
Filter with BuildCriteria Function
Posted On 14 Dec 2009 By a.p.r.pillai. Under Functions.
Any method that helps to find data quickly on a Form is always welcome by Users. There are several options available when you are in Form View Mode.
When you Right-click on a Field a Shortcut Menu will popup showing four data filter options as shown on the sample image given below.
No Comments
Filter Function Output In Listbox-2
Last week we have seen the usage of Filter() Function with a simple example and I hope you understood how it works. We have assigned constant values to the Source Array elements directly to keep the VBA Code as simple as possible.
2 Comments
Filter Function output in ListBox
This FILTER is not related to a Query or WHERE clause in SQL or Filter settings on a Form. It is a built-in Function. Its usage is very interesting and it is useful to quickly filter out data from an Array of information through text matching. We will use this Function to search for values across more than one field of data from a Table, extract matched items or mismatch items, as the case may be, and display them in a List Box.
No Comments
Cardinal Text Format In Access
Posted On 02 Jan 2009 By a.p.r.pillai. Under Functions.
The other day one of my colleagues asked me to open MS-Word and type the expression =Rand() on a separate line and press Enter key. It was a magic that ... Continue Reading
No Comments
Rounding Function MRound of Excel
Posted On 06 Dec 2008 By a.p.r.pillai. Under Functions.
Normally we round numbers in calculations when the fractional part is 0.5 or more to 1 (next highest integer) or truncate it altogether. But, there are times that this fractional ... Continue Reading
2 Comments
Custom Calculator and Eval Function
Posted On 29 Nov 2008 By a.p.r.pillai. Under Functions.
When we think of a Calculator the image that comes into our mind is the traditional type with button labels 0-9 and with Arithmetic Operators. We have it in Windows ... Continue Reading
3 Comments
Sum Min Max Avg ParamArray
Posted On 07 Nov 2008 By a.p.r.pillai. Under Functions.
I know your immediate response after looking at the Title will be, "I know all those things, tell me something that I don't know". Well, if you haven't come across ... Continue Reading
No Comments
Days in Month Function
Posted On 24 Apr 2008 By a.p.r.pillai. Under Functions.
Function to Calculate Number of Days
The User-Defined Function DaysM() given below can be used in calculations that involves the number of days of a particular month. Copy and Paste the ... Continue Reading
No Comments
Useful Report Functions
Common Functions that you can use in Report Header or Footer Sections, while designing Reports, are given below. Copy and Paste the VB Code into a Global Module of your ... Continue Reading
3 Comments
