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 o...

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 topic...

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 on...

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 repo...

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.


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

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...

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 m...

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 para...

Comments 0 | Views 1342 Read More