The following code shows Print Preview Option, so that the user can opt to see the preview on screen or directly send it to the printer. Following is generic code which needs report name 'PRepName' and 'PRepCond' as its parameters. In the present context PRepName and PRepCond are set as Global Variables.

One time or the other, probably someone could have lost data due to corrupt MS Access Database.  However Not all corrupted Access database are irrecoverable.  In most of the cases you can recover almost all the data from the corrupt MS Access Database.  The Code below provides one possible

The objective of this function is to generate invoice number in a specified serial format.  Commonly Invoice Number is stored as number in the database.  While printing Invoice, It is offen required to print invoice numbers in specified format as per customer's requirement.   Most

Whenever we create forms for data tables it becomes necessary to provide navigation buttons.  Though MS-Access provides built-in navigation buttons, Developers would like to provide standardised, user-friendly button type navigation features in their forms.  The Function FrmNavigate aims to

There are situations where data entry operators need to change date value.  This custom made function helps the users to quickly edit the date field using plus key (+) to increment the date value by one day and minus key (-) to decrement the date value by 1 day. The function provided below takes