I think you're talking about the Payslip sheet in the EPIF book.
A little bit about nomenclatures and definitions I use. Databases (In Excel) are tables with labels in Row 1 and/or each column is a Defined name range.
Reports are temprary and contemporaneous, that is they are designed to be a report of information about a specific time and are to be viewed or printed, but do not store any information. They are analogous to paper forms and are usually designed around an existing paper form. They can be on a worksheet or on a UserForm.
Forms are always UserForms. So if I were to say "you need a report for that" you can use a worksheet or a UserForm, but if i said "You need a Form," I mean a UserForm only. Forms are used to enter or edit or occasionally, view, (like a report,) records in a database.
UserForms only print as images, so it is usually best to use Worksheet reports for printing.
For now, hold off on designing any more forms or reports. The very first thing to design in any middling to large app is the database, because
Function Follows Data Structure
I'm attaching a list of all the input boxes on the main form. I leave it to you to understand what data they represent. You will need these to name the columns in the Database sheet. Just put the data names in the top Row as column labels. The Data names should be understandable by any trucker.
When done, the database sheet should have a column for each different piece of data. Don't worry if the table seems to be getting too wide, it's not really for humans to look at anyway. That's what Reports are for. Now I know that I said not to design any reports right now, but you do need to take a good look at all reports desired to make sure there is a data column for each bit on the reports.
Since you only have around 90 controls on the Form, I don't think that we'll run out of columns, even in my Excel 2002 version, so go ahead and group the columns with empty columns between groups, if you like.
One thing, the first column must be for the DATE of the entries. That is the main lookup for all entries, even though we'll be doing lookups on other columns, too.
