Hello Friends, Like Microsoft Excel , These days Access also has a great place in organizations, where we need to handle large database by using only SQL or Access DB. So we have create a discussion forum for Ms Access where people can post queries and can get experts advice. Group Link: Access-SQL Group This…

Gauge Chart : [Dial Chart]


Hello world Wanna make an Amazing Gauge Chart ? Its Formally Known as Dial Chart,you can follow some simple steps to create.   I have used some VBA Code to make the needle animated : Here is the Code to Move Needle Sub MoveNiddle()     DoEvents     If Range(“rngNiddlePos”).Value = Range(“Sales”).Value Then Exit Sub  …

Waterfall chart :


A waterfall chart is an intuitive tool to visualize the cumulative effect of sequentially introduced positive or negative values.  here is file you can download the waterfall template [Automated through VBA ] , you just need to give data and press button http://www.2shared.com/file/1kSiTtg7/WaterFall.html hope you  will enjoy.

Looping Through Folders and Files in VBA:


Hi Guys,Many times we need to loop through folders , sub folders and files , i have created a code to get the folder structure of a given path=======================================================================Public ObjFolder As Object Public objFso As Object Public objFldLoop As Object Public lngCounter As Long Public  objFl As Object     ‘===================================================           …

Excel Solver :


As I study the solver, I feel this is elder brother of Goal Seek in Excel ,where we can change only one value with Goal seek , Using Solver we can provide many cell for adjusting value as per our scenario , Below is the Parameter required to solver , We can add many scenario…

Dictionary Object :


when playing with data many times we needs to save some unique values somewhere, that time we can use dictionary object , it does not allow to store duplicate values in it,  Dictionary object Takes two argument at the time of adding data 1) Key .2 ) Value and it returns the value by  ID,…