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
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
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
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"] Comments 0 | Views 636 Read More
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 codeFunction 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
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.
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
March 6, 2014 | Harun | In Form
Comments 0 | Views 1194 Read More
February 28, 2014 | Harun | In Form
Comments 0 | Views 634 Read More
February 27, 2014 | Harun | In Query
Comments 0 | Views 1342 Read More