forms to validate data and finally save in access

[annajohn0503]

i would like to develop some form or wizard; to let users enter details [around 5 tables with hundreds of records]. The main thing is i need to validate the user inputs and save it in access database.

could someone please guide me different ways to do this?

i used to be using excel sheet. But the problem is many times data is not valid and i need to validate and ensure data is valid and finally import into access.
i would like to make this step easy. ready to learn and develop anything.
and i would like to give users some help info regarding what they are filling, which i was not able to in excel.
Access forms validation messages are not so user friendly which might not help.

your suggestions means so much to me.

Thanks!!

 

[theDBguy]

Hi. Welcome to AWF! In Access, you can create a form for data entry; and to validate the data being entered, you can use the form's BeforeUpdate event to check if the user's input is correct or not. It is usually easier to use bound forms because then you won't have to worry about saving the data into a table since Access will do it for you.

 

[GinaWhipp]

Hmm, well, after you build the Form have a look at...
https://www.access-diva.com/vba13.html

 

[apr pillai]

For your info: Excel Cells have some data validation features, which you can enable for required Cells to control data entry.

1. Select a Cell
2. Select Data from the Main Menu.
3. Select 'Data Validation' from the 'Data Tools' Group.
4. A Data Validation dialogbox will open.
5. On the Settings tab select the data Type in the 'Allow' control you want to allow in the cell.
6. Set the validation rule options given below the 'Allow' control.