Submit form and update database

[hehe001]

Dear Expert,

I want to have a form (sheet forms) which will automatically update the other sheet (db).

Sheet forms, any user can open this form.
- field sequence number will follow the last number from sequence_no in sheet db, readonly
- name, user can put any character
- department and title will follow sheet setup, i want it on drop down list.
if department is Sales the the title will follow the according to the department
- access_to_pos : if YES then field POS_LEVEL will be changeable
POS_LEVEL: Cashier, Admin --> this field will be readonly if access_to_pos is YES
- Access_to_door and access_to_admin is YES,NO dropdown list.

submit button : once clicked will show yes/no conformation
yes: the form will update sheet db accordingly, and send email to [email protected] sheet "forms" attached
no : back to form

cancel buttom : once clicked show the yes/no confirmation
yes : will cancel all the form and close the spreadsheet.
no : back to form

sheet db and setup : only able to open/accessed with password

I believe to that things will use vb programming or macro, i have been searching the best practice but getting more confuse.

Please need your favor.

regards,

[Neil_]

Here you go. Enter admin in the name box to go into admin mode. You will be requested a password which you can change in the setup sheet. the current password is "pass".

[hehe001]

Hei @Neil
awsome, thats good.

do you have chance to explain how to build that?

[Neil_]

Not sure what you mean as it's a working build. If you want to add any more fields, go into admin mode and Copy / Paste existing fields in the cells below. Give the new fields names in the name manager, then amend the code behind the submit button to reflect the added fields. Yo would also need to change the html in the SendMe sub to add the new fields.

Let me know if you want anything in the form changing and I'll be happy to do it for you.

[hehe001]

Not sure what you mean as it's a working build. If you want to add any more fields, go into admin mode and Copy / Paste existing fields in the cells below. Give the new fields names in the name manager, then amend the code behind the submit button to reflect the added fields. Yo would also need to change the html in the SendMe sub to add the new fields.

Let me know if you want anything in the form changing and I'll be happy to do it for you.

Yes it works, I mean: If I would like to start build from scratch with above scenario, where do I begin?

[Neil_]

To describe the work it took and to explain the methods would take the chapter of a book.

To get the basic look and feel of the form:-
Select all the cells in the form sheet, right-click and check the properties to see they are locked. Colour the form grey.
Go through each of the input boxes and colour them white with a darker grey top and side to give a 3d effect.
Give each of the input boxes names using the name manager. Right-click and check the properties to see they NOT are locked.
Protect the sheet so that only unlocked cells can be selected.

The code is more complex. You can study it by pressing Alt-F11 and viewing the sheets and modules through the project explorer on the left.