Hi
Just a question
I have a data entry form to enter data and copy with VBA to Database
To edit data ( employee is doing it ) what is the best route to go
Thanks
Hi
Just a question
I have a data entry form to enter data and copy with VBA to Database
To edit data ( employee is doing it ) what is the best route to go
Thanks
The details are going to be different for every case. There is no one answer to this.
Is your data entry form a UserForm? Is your database just the Excel file, or is there an external database management system?
Generally you should give the user a a form to identify what record they want to update. You need to determine what is the key for each record, and allow the user to input the data for the fields that make up the key. This is best done by lists or comboboxes, so the user chooses from existing data, rather than have them just type something in. Then you bring up a UserForm like what you have now, only already populated with the data so that the user can edit it. Then the updated record is saved.
If you would like help at a concrete level, including actual VBA code to do this, please attach your Excel file. It should include sample data, but no genuine private data. See yellow banner at the top of the page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks