Populating a database with a form via VBA code

[rplebuch]

Hello all,

I could really use some help on this issue. I have created 3 forms in my Workbook, each has a specific purpose that i need it to do.

The "New Task Form" i need to do the following in order (red is user input, green is computer input:

1. information is imputed (FORCED CAPS)
2. "SUBMIT NEW CADD TASK FORM TO DATABASE" button is pushed
3. information from "New Task form" is imputed into the "Task Database" under their respective column
4. a unique number called the "origin id" is created in the following format "MM-YR-###" (the third submittal to the database in feb 2015 would look like "2-15-003") and placed under the respective column on the "Task Database"
   
5. a PDF is created and emailed to my email address "richard.plebuch@parsons.com" with the "origin id" as the file name of the PDF
6. the same PDF is saved to a folder
7. the "New Task Form" is then cleared to default information

The "Task Change Form" i need to do the following in order (red is user input, green is computer input:

1. Origin code is imputed
2. "Populate" button is pushed
3. information from "Task Database" is populated into the "Task Change Form" using the unique "origin code"
4. User then changes what needs to change (forced uppercase)
   
5. "submit Task Change form to Database" button is clicked
6. Changes are populated into the "Task Database" and the origin code is updated to add a sub id example as "2-15-003-A"
7. a PDF is created and emailed to my email address "richard.plebuch@parsons.com" with the updated "origin id" as the file name of the PDF
8. PDF is saved to a folder
9. the "Task Change Form" is then cleared to default

The third form is "Task Removal Form"

1. Origin code is imputed
2. PDF & e-mail form" button is clicked
3. a PDF is created and emailed to my email address "richard.plebuch@parsons.com" with the "origin id-Removal" as the file name of the PDF
4. PDF is saved to a folder
5. the text in the row that corresponds to the "origin id" that is entered is turned to red in the "Task Database"
6. the "Task Removal Form" is then cleared to default

The link to the excel work book is: https://app.box.com/s/65kin8qhowz86plzk7tlur0plruoni5h

I could really use your help on this i have been trying for some time with no luck. I really appreciate all of the help i can get. Thank you for looking at my post!!

-Richard

 

[rplebuch]

bump

 

[DocAElstein]

bump

Hi,
. Hi thanks for the P.M. I did catch and take look at this Thread and the enclosed file. As I said in the PM it is just a number too high for me…

. Mr Excel is where the most of the Little Excel Knowledge and Forum Knowledge I have is.. so .:- .
. (- I welcome any comment from regulars on the three points here:- -)
. 1 ) - People like me may take up long difficult but not technically challenging Threads, like the sorting one I did for you . But that is a bit of a luck thing – For anyone trying to help you here on this project I expect based on the previous stuff I did with you there will be much time consuming back and forth checking details..
. 2) - The experienced regulars work amazingly hard giving freely ( and quick) giving Complicated formulas, short codes and solving particular problems in a code. They just do not have the time for a long project like the one you have outlined..
. 3) . I am not a Programmer at all by trade.. But it would appear to me that your Post #1 in this Thread is a very clear well written Summary of a Project that is very useful to have at the start as background…and a great improvement over your first Thread. So a very good start. (A file extra to the following is also helpful). :-
. - But for help on a free Forum I think you then need to take it further to break it down – make a start.

……… i have been trying for some time with no luck…… …

…………….Then when something specific does not work or goes wrong then..(after learning how to use the Forum Tools) Post clearly code extract in Code Tags or screenshot using the HTML make if appropriate showing a specific problem / error (Not something like a .jpg – it must be copyable to a spreadsheet) - using the HTML spreadsheet screenshot maker if appropriate.

. Sorry I cannot give more precise help. I do have it in mind. I will look in again if I can help with a specific problem. (Or look at the complete Project if I have lots of time free!)

Regards,
Alan