Hi all,
I am a newbie to access. I need an assistance on how to set a limitation of data entry into a database.
For Example
I have created a database, a form for data entry (with 2 button Save and Exit) and a switchboard.
Let me explain on how it works. At the startup of the file when double click, it will automatically goes to switchboard (I have successfully created it and created an option linked it to the form for data entry.
In this form there are few dropdowns and 2 buttons.
So i am having difficulty to run the program in such way as below:
Scenario:
Once i filled up the form, I will click the button Save and the program run to check number of record in the database and prompt msgbox saying I am not able to enter more data (Database limited to 3 records only)
This is the part I am not sure how to do. Would appreciate anyone could help me on this the simplest and understandable way as I am still new for access.
I am a newbie to access. I need an assistance on how to set a limitation of data entry into a database.
For Example
I have created a database, a form for data entry (with 2 button Save and Exit) and a switchboard.
Let me explain on how it works. At the startup of the file when double click, it will automatically goes to switchboard (I have successfully created it and created an option linked it to the form for data entry.
In this form there are few dropdowns and 2 buttons.
So i am having difficulty to run the program in such way as below:
Scenario:
Once i filled up the form, I will click the button Save and the program run to check number of record in the database and prompt msgbox saying I am not able to enter more data (Database limited to 3 records only)
This is the part I am not sure how to do. Would appreciate anyone could help me on this the simplest and understandable way as I am still new for access.