Showing posts with label access. Show all posts
Showing posts with label access. Show all posts

How To Disable/Enable the Shift Bypass Key in Microsoft Access:

To Prevent a user bypassing the start-up options you will need to apply the following function and code to a command button (or ideally a hidden option,such as to the double-click event of a label or graphic).
This will prevent anyone without the password bypassing the start-up by using the Shift key.
The below function and command button code will allow you to use a password protected input box to determine if the Shift key can be disabled or not.
You might have to set your "References" in the VBA editor to DAO 3.6.
When you are viewing a Module, click the Tools menu » References. Browse for Microsoft DAO 3.6
Select "Files of type: Executable Files (*.exe; *.dll)"
C:\Program Files\Common Files\Microsoft Shared\DAO)
Then explicitly dimension yourcode, i.e. Dim db As DAO.Database, prp As DAO.Property

MS Access Accounting Software- Free Download and OPEN SOURCE


I was in search of good and free accounting solution for me and my online business. Having businesss studies in past I learned to maintain accounts to avoid any financial mishap.

After a long search on google and other search engines, i found many softwares and accounting solutions but those were not actually free. Some were web application  scripts and some were desktop applications.

Besides all, although microsoft business ledger template is good enough to have single account, but as i told, i needed full accounting solutions which offer complete accounting cycle itself. Like,

  1. General journal
  2. Ledgers
  3. Cashbook
  4. Trial Balance 
  5. Income statement
  6. Balance Sheet


All my searches was insane. In the end I personally decided to use my Microsoft access 2010 skills and determinations towards hardwork i came to get a comprehensive solution of my accounting problem.

I would like to share that to you and would really like to get comments so that I will be motivated to make it better.

Here is simple description about accounting application

This application requires Ms Office Access 2010 or greater to run itself as it is developed in office 2010. so you should have Office 2010 installed in your super fast computer. This application allow you to create genereal accounts and cash account.

The best thing is, Its Open Source and Free Application.

You can change and let me know also if you find it helpful.


Here are some Screenshots


Here you make your cash account. it allows only one cash/bank account
Here you make your general accounts.
This form is to make geneal entries between genearl accounts

this form is to make cash book entries

Here you can see ledger reports with range and or single ledger .
Note: if search box is empty then show all ledgers

you can see trial balance report

YOu can set your settings

this is open source