Need Help with VBA Saving DATA to another sheet

I have been using a workbook I found online and been making small changes. Now with the changes I made it will not function. And I'm just not understanding i Guess the Macro to Modify it.
Can Someone Help? Basically we enter data on the User form and save it to the Database. I'm just not that great with the coding.

Hello,

OK I have been working on your worksheet. And acknowledging all the work its original creators have on it and that can be found following this link www.excel-it.com I modified it a little to fit your needs.

Basically the problem you were having was that the code was pointing to a difference cell.

Hope it helps. I also performed added some extra features I believe helpful; Attachment 262467

Thanks

Thanks I had already figured out my original problem before I seen your answer. I like the added features Thank You! I'm not a VBA guy. I had to go with the Date and time that way I could not find a picker that was dependable also fo Math reasons!

I have everything working correctly except 2 final things:
1. Cells E2:E10 must all have data in them E2-E9 based on selections corresponding to them or it will not save to the database and give an error message. For instance (All Cells must be completed before saving)
2. Date and Time in E6 must be less than E8 and visa versa.

Your assistance is very much appreciated

can you provide a copy of the current file ?

thanks

I Would like to limit incorrect information.
1.So First of all E2:E11 all have to have Data in them before allowing saving.
2.E2:E7 based on Ccmbobox or time selected only.
3.E8:E10 Based on Text entered but not Blank.
4.E6 Must Be Date and Time must be Less Than E7 and Visa Versa

I Protect the DataBase Page and only Show the Form and Databease Tabs thats no problem. I'm Just trying to limt the shared users from doing anything but the Data Entry. I wish I could Lock out the Ribbon also on the Forms Page.

I appreciate all of your help!! Is there anything I might read to help me with issues like these?
Thanks Again!!!!

I'm Over 9K and it say it's to Large to Attach!!

Thanks I had already figured out my original problem before I seen your answer. I like the added features Thank You! I'm not a VBA guy. I had to go with the Date and time that way I could not find a picker that was dependable also fo Math reasons!

I have everything working correctly except 2 final things:
1. Cells E2:E10 must all have data in them E2-E9 based on selections corresponding to them or it will not save to the database and give an error message. For instance (All Cells must be completed before saving)
2. Date and Time in E6 must be less than E8 and visa versa.

Your assistance is very much appreciated

I'm Sorry I used the wrong description to go with the file.
I Would like to limit incorrect information.
1.So First of all E2:E11 all have to have Data in them before allowing saving.
2.E2:E7 based on Ccmbobox or time selected only.
3.E8:E10 Based on Text entered but not Blank.
4.E6 Must Be Date and Time must be Less Than E7 and Visa Versa

I Protect the DataBase Page and only Show the Form and Databease Tabs thats no problem. I'm Just trying to limt the shared users from doing anything but the Data Entry. I wish I could Lock out the Ribbon also on the Forms Page.

I appreciate all of your help!! Is there anything I might read to help me with issues like these?
Thanks Again!!!!

Hi,

Perhaps you should try a Userform for the entry instead of a sheet. This will limit the usability of the workbook while the form is running. and In my opinion will give the workbook a more elegant look.

For the sheet protection make sure the the cells you mention are locked while the rest are not.
then use the following syntax before and after your codes ( most likely you will not be able to do anything while the sheet is protected.)

Please Login or Register  to view this content.

Thanks

Hello,

I was working on a form to show you. please press the button that say "Show form" Its not finalized yet but I wanted to show you the difference.

Thanks

Attachment 264108

That's BEAUTIFUL !! Is everything configured the same as a sheet? Combo boxes etc? Transferring to the Data base? Getting dates and time to be enter correctly for the math is a pain.

Hi cpalmere,

No, not everything is configured. I just wanted to show you how it looks like. If you want I can continue programming it for you. I just want to make sure that's something you want. It will take me some time to work on it.

Thanks

No I understand! It would be great if you could also then I could see when its finished how you did it so next time I could do it myself. I really appreciate it!!!! The date and Time selection is tough right?
Thank you again !

Hello,

Here is the final file. Test it and let me know if anything suspecious comes up.

Attachment 264972

Thanks

I really appreciate it. Have been swamped just tried to reteive the file and getting error.

.
--------------------------------------------------------------------------------

vBulletin Message
Invalid Attachment specified. If you followed a valid link, please notify the administrator.

Hello,

There is something really macabre about this file. I did some clean up in my account this week and apparently my attachments got deleted. I went to reach my backpack to send you the copy I have and my USB flash is missing; I left it either at school or at work. I hope it was work and not school I have a lot of academic progress saved there.

I am so sorry.

I would recommend you to use what you have for now and wait and see if I can get the information back. the date can be easily transferred later. If I cannot retrieve it I will have to try and replicate my work.

Okay Thanks Again.

Hello,

Ok I have excellent news. I was able to recover my Flash drive with the workbook.

Find it attached here and let me know what you think.

MaintTracker5.xlsm

I am sorry for all the trouble.

I'm sorry I've been swamped at work. It looks great. I want to thank you for your assistance. I just need to go in and modify some lists and try to get the Date and time selection in there. For some reason some people have trouble entering the correct date and time.
Thanks again!!!