Category : Module and VBA

Number to string

March 12, 2014 | Harun | In Module and VBA

Number to string

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

Disable shift key bypass

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