Happy Codings - Programming Code Examples

Html Css Web Design Sample Codes

CPlusPlus Programming Sample Codes

JavaScript Programming Sample Codes

C Programming Sample Codes

CSharp Programming Sample Codes

Java Programming Sample Codes

Php Programming Sample Codes

Visual Basic Programming Sample Codes

Visual Basic Programming Code Examples

Visual Basic > Database SQL Stuff Code Examples

Preview an Access Database Report



Preview an Access Database Report

The function below can be used to preview a report created in MS Access.

'Purpose   :    Preview an Access Report from VB
'Inputs    :    sAccessDBPath           The path and filename of the access database containing the report to show
'               sReportName             The name of the report to show
'Outputs   :    Returns an empty string on success, else returns an error message.


Function AccessShowReport(sAccessDBPath As String, sReportName As String) As String
    Dim oAccess As Object 'Access.Application
    
    On Error GoTo ErrFailed
    AccessShowReport = ""
    'Create Access
    Set oAccess = CreateObject("Access.Application")
    'Open Database
    oAccess.OpenCurrentDatabase sAccessDBPath
    'Open report
    oAccess.DoCmd.OpenReport sReportName, 0 'acViewNormal
    'Show Access Report
    oAccess.Visible = True
    oAccess.CloseCurrentDatabase
    Set oAccess = Nothing
    Exit Function

ErrFailed:
    Debug.Print Err.Description
    Debug.Assert False
    AccessShowReport = Err.Description
    If oAccess Is Nothing = False Then
        oAccess.CloseCurrentDatabase
        Set oAccess = Nothing
    End If
End Function

Program Remove given Word from String
This program takes string and its substring as input, removes the Substring from the string. Take a string, its substring as input and Store it in the array str[] & key[] respectively. Store

Create an Array of Chars in C++ Language
String is a "sequence of characters". char data type is used to represent one single character in C++. So if you want to use a String in your program then you can use an "array of chars".

Code Convert a Number Decimal to Binary
Find a Binary equivalent of a decimal number entered by the user, using recursion. The user has to enter a 'decimal' which has a base 10 & this program evaluates the binary equivalent

C++ Two-Dimension Transformations In
This C++ Program code example deals with all two-d transformation such as translation, 'scaling', 'rotation', 'reflection', 'shearing' in homogeneous coordinates. Transformation

Program Finds Sum of First and Last Digit
C Language Program to input a number and find sum of first and last digit of the number using for loop. Input a number. Find last digit. Find total number of digits - 1. Find first digit.

Program to Delete Element from an array
Program code to delete an element from an array at specified position. How to remove an element from array at given position. Array is a linear data structure. It provides an index...

C++ Program Implements Fibonacci Heap
Link nodes in fibonnaci heap. Union nodes in fibonnaci heap. Extract min node in fibonnaci heap. Consolidate node in fibonnaci heap and Decrease key of nodes in fibonnaci heap. Find

Find Sum of Opposite Diagonal Elements
C program to read elements in a matrix and find the sum of minor diagonal elements. C program to calculate sum of minor diagonal elements. Input elements in matrix from user

Romance707