blazonQC
07-06-2007, 02:56 PM
First off, thanks for viewing my post! As a forewarning.... There is a lot of pre-info that you may find unnecessary, so I labeled all the different parts of the post for simple navigation. :)
I just can't seem to focus and I'm having issues with my 'problem solving' skills today, so I could use a few suggestions to help me along. Here's the situation:
Pre Info:
I am a QC at a steel mill and my boss recently discovered that I have a relatively broad background in computers and he decided to make me the unofficial computer tech/programmer/network administrator. Anyway, he gave me a project that I need to get done by Monday and i've hit a roadblock.
The Simple Project:
A spreadsheet in the style of a printable request form to confirm changes to 'Shop Orders' issued to all mill operators. The information on the spreadsheet, once completed, must be verified and signed by supervisors dependant upon which changes must be made to the orders. i.e "Order Quantity Change - Production Supervisor Signoff".
The Advanced Project:
With the basic project completed I am attempting eliminate all of the actual paperwork involved with this. I would like to have electronic signature accounts set up for all the supervisors for the form on the network, so the user can only change/verify specific information according to their position ("Production, Sales, etc") . I would also like our department to be able to view see a list of pending request applications so we can make sure that everyone is verifying information as quickly as possible to expedite the process.
Completed So Far:
1) I have databases set up to store all information submitted through the request form.
2) A 'master' userform layed out just like the request spreadsheet.
3) eSignatures created for all users
The Underlying Problem:
I have everything basically set up for user input..... but the issue is with the method of setting/retrieving the information back and forth between the 'App' and the spreadsheets. Currently I am coding everything individually and can't for the life of me figure out how to simplify the situation. I have an array declared as a custom Type which stores all information for each change set up like so:
Type tree
active as boolean
cel as string
team as string
desc as string
end type
Public vArray(0 to 19) as tree
And i'm using this array type to store the information and pass it to and from the db/sheet. When I hit the 'submit' button I have a procedure that fills all of the information manually into the array, meaning that I have to type all of the cell values and 'link' all of the information between the text/combo boxes and the array by hand. There has got to be an easier way to do this? At this point I have realised that if I continue with this method my app is going to run slow as hell and i'm going to end up typing a lot of 'If Then' statements.
In Conclusion:
I am just looking for a few suggestions on how to perform these operations more efficiently. Any input is valued! :)
Thank you for your time and sorry for such a long and detailed post. I can give more information if need be.
Chad
I just can't seem to focus and I'm having issues with my 'problem solving' skills today, so I could use a few suggestions to help me along. Here's the situation:
Pre Info:
I am a QC at a steel mill and my boss recently discovered that I have a relatively broad background in computers and he decided to make me the unofficial computer tech/programmer/network administrator. Anyway, he gave me a project that I need to get done by Monday and i've hit a roadblock.
The Simple Project:
A spreadsheet in the style of a printable request form to confirm changes to 'Shop Orders' issued to all mill operators. The information on the spreadsheet, once completed, must be verified and signed by supervisors dependant upon which changes must be made to the orders. i.e "Order Quantity Change - Production Supervisor Signoff".
The Advanced Project:
With the basic project completed I am attempting eliminate all of the actual paperwork involved with this. I would like to have electronic signature accounts set up for all the supervisors for the form on the network, so the user can only change/verify specific information according to their position ("Production, Sales, etc") . I would also like our department to be able to view see a list of pending request applications so we can make sure that everyone is verifying information as quickly as possible to expedite the process.
Completed So Far:
1) I have databases set up to store all information submitted through the request form.
2) A 'master' userform layed out just like the request spreadsheet.
3) eSignatures created for all users
The Underlying Problem:
I have everything basically set up for user input..... but the issue is with the method of setting/retrieving the information back and forth between the 'App' and the spreadsheets. Currently I am coding everything individually and can't for the life of me figure out how to simplify the situation. I have an array declared as a custom Type which stores all information for each change set up like so:
Type tree
active as boolean
cel as string
team as string
desc as string
end type
Public vArray(0 to 19) as tree
And i'm using this array type to store the information and pass it to and from the db/sheet. When I hit the 'submit' button I have a procedure that fills all of the information manually into the array, meaning that I have to type all of the cell values and 'link' all of the information between the text/combo boxes and the array by hand. There has got to be an easier way to do this? At this point I have realised that if I continue with this method my app is going to run slow as hell and i'm going to end up typing a lot of 'If Then' statements.
In Conclusion:
I am just looking for a few suggestions on how to perform these operations more efficiently. Any input is valued! :)
Thank you for your time and sorry for such a long and detailed post. I can give more information if need be.
Chad