Category : MS-Access

Solved Ms Access Run-time error 2501

September 4, 2014 | Harun | In Form

Are you looking for fix the MS Access Run-time error 2501? In this post I'll show you how to fix the problem and handle this error. Basically this error shows when you apply a button for open a form or report by VBA or Micros. Most of new Ms Access developer confused when they can't fix the error. Don't worry I'll give you the 100% solution to fix this error. Let's see the process. [caption id="attachmen...

Comments 1 | Views 100105 Read More

Open and Close Form by VBA in Microsoft Access

June 8, 2014 | Harun | In Form

Hi,dear MS Access learners! Generally we use micro for open and close our form but Some times we have  need to open or close form by clicking button, image or anything else by VBA code. In this topics I'll show you how to open form and how to close form by clicking a button. Suppose You are in a form now, name is FormA, there is a button b...

Comments 0 | Views 2052 Read More

Convert ms access report to PDF without programming!

March 20, 2014 | Harun | In Report

This tutorial for convert ms access report to PDF without programming. Following this tutorial you can convert your ms access report to PDF. This method can be apply for any ms access versions. Not only report convert as PDF file but also convert your any table data,form out looking. Follow these steps for converting your ms access report to PDF<...

Comments 0 | Views 231 Read More

Dynamic report name

March 13, 2014 | Harun | In Report

In access you can set the report name dynamically. Generally we set a report name statically. This tutorial goes to describe how to set a report name dynamically. 1. Open your report and go to report property and create an event of Report header with Format [caption id="attachment_127" align="alignnone" width="338"]Report header property Comments 0 | Views 636 Read More

sample of dynamic report name

| Harun | In Sample database

This sample database for dynamic report name. You can see the tutorial of Dynamic report name


Comments 0 | Views 1187 Read More

Number to string

March 12, 2014 | Harun | In Module and VBA

This function module will convert your currency number value to string. You can apply this function module of your ms-access database simply following the few steps.

1. Create a new modules and paste the code

Function ConvertCurrencyToEnglish(ByVal MyNumber) Dim Temp Dim Dollar, Cent Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Th...

Comments 0 | Views 1126 Read More

Disable shift key bypass

March 7, 2014 | Harun | In Module and VBA

Your access database security matter is shift key bypass. For disable the shift key bypass follow the instructions.  

  1. Make a new  module
  2. Paste the code

Public Sub SetBypassProperty() Const DB_Boolean As Long = 1 ChangeProperty "AllowBypassKey", DB_Boolean, False ' To re-enable shift bypass change the above line to True, hol...

Comments 0 | Views 1497 Read More

Run query by form

March 6, 2014 | Harun | In Form

We are usually use query to find data from database. Some times you will need run a query with form. Actually we can finish our task with simple query to search but if you do by this form it will be looking attractive and nice view.
  Follow these steps to do this : Here we will...

Comments 0 | Views 1194 Read More

Open form with data entry mode

February 28, 2014 | Harun | In Form

In access when we open a form for data entry it shows previous existing data. So that we click on new record button to add a new record.We can set the form for open with data entry mode.If we do that we need not click on new record button to add a new record.
Follow these steps to open a form default data entry mode:

Comments 0 | Views 634 Read More

Make Query base on two parameter

February 27, 2014 | Harun | In Query

Two parameter base query will help you to find out data from you database depends on your two parameter.
Follow these steps to make a two parameter base query:
1. Decide that on which are parameters i mean which fields will be base of your query. (here our example query has made with ID and city fields) ...

Comments 0 | Views 1342 Read More