Have you ever written a report in Reporting Services 2005? Most people have, but to get anything worth it's salt you need to have some pretty advanced t-sql experience or have a good background in databases to be productive in SQL Reporting Services. For those of you that are experienced in procedural language like C#.NET or VB.NET but are not in t-sql this article is for you. In this post I am going to show you a quick and dirty way to get some advanced custom code working in your reports.
First off, you need to know what your options are before you get started:

You can build custom assemblies in any .NET compliant language of your choice
You can embed Visual Basic code into your report directly

This article is going to discuss the 2nd option because it easier and quicker to get your custom code ...

There are a host of run time errors that can slow down a Windows computer at any time. Most of these issues are related to programming bugs that were not detected at the time of development. Runtime error 372 is a glitch associated with the Microsoft Visual Basic software, one that occurs when attempting to load an ImageList control. This run time error is typically the result of a missing or outdated mscomctl.ocx file. Although these errors can be a terrible annoyance, solving them is a simple matter of troubleshooting.

What Causes Runtime Error 372?

There are several issues that can generate a Runtime error 372. One is a conflict of color depth within icons, the desktop or a particular application. In the Visual Basic environment. This error may occur if the ImageList control consists of more colors than the depth of what the Windows desktop can actually support ...

In order to fully utilize the capabilities of MS Access, one must not only learn the Visual Basic (VB) programming language, but should also learn Standard Query Language (SQL). Once a grasp of these two languages have been obtained, MS Access users can begin to build faster and more efficient databases.

One tool that has proved itself very useful to me over the years is querying data from tables or queries using VB and SQL code. A brief introduction to this process is presented in this article. To best understand this process, an example is provided below along with an explanation of its parts.

CODE:

Dim rstTemp As Recordset
Dim strSQL As String
Dim routeNum As Integer

strSQL = "SELECT [Route], [Main Route PM], [Intersecting Route], [IntBeginPM], [IntEndPM] "
strSQL = strSQL + "FROM Intersections_list WHERE (((CStr([Route])) = """ + cmbRouteQuery + """));"

Set rstTemp = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)

If (Not (rstTemp.EOF)) Then
rstTemp.MoveFirst
routeNum = rstTemp ...

If you've got a runtime error 80010108, your solution is either really easy or it is really hard. Regular computer users often get this error because an ActiveX object they need is unavailable for manipulation. Believe it or not, that would be the good news.

Often, the reason the ActiveX object is unavailable is because you shut down the program that supports the object. For example, suppose you want to automate the export of some data from an Excel spreadsheet into Visual Basic. You are working with Visual Basic and you get the error 80010108 "the object invoked has disconnected from its clients." This means that the "client" (Visual Basic) tried to call up the ActiveX object from Excel, but the object wasn't available.

The most common reason why? You shut Excel down! So keep Excel running and the object will be connected and you shouldn't get ...

Sample program to list file and folder names (including Sub Folder)

To list all the files and folders in the given path this includes sub folders as well. If only folder name needs to be printed then comment the line in file listing. If only file name needs to be printed then comment the line in folder listing

The errors have to be handled from the calling function, this function will throw the error with a text "error from Functions.ListFolders".

This function lists all the files and folders in debug window. If you want to populate in a collection. use a separate class and use private module level variables to add it to the collection.

This is a recursive function. Modifications to this function should be taken with care using proper breaking of recursion.

'***************************************************************

'* Purpose : Get the list of items from the folder

'* Inputs : strPath(String) Path to folder ...

Runtime error 28 is commonly witnessed in Windows XP and Vista. In general, the runtime error will bother the user, since it arrests the program from execution. At times, the program will be terminated without a notice too. This error usually arises in the form of an alert box that subject "Out of stack space". When examined, this error is mainly induced due to intense use of functions and sub calls while the Visual Basic procedure access the procedure files which is kept unloaded from the system memory. When this error pops up, the software will be terminated instantly without a notice.

The runtime error 28 can be due to multiple reasons, but the primary reason will be due to lack of stack space that is required to execute the macros present in the MS WORD 2000, MS VC++, PowerPoint and other files. Also when the windows registry is corrupted ...