We have a Microsoft Access database that we currently fill in with a small number of details for every event job that we do (approx 1600 per year).
I need the following:
Adjust the form so we can enter in all the details for each event (called frmjobsheet) - linked to the table 'Events_old'
I would like the look to be cleaned up with a button included to print the form onto 1 A4 page
I would like the sequence of each of the fields on the form to be kept the same.
I would like all the field names in the table to be kept the same and all data retained.
The fields I want included on the form are :
Booking Contact Phone Number
Booking Contact Mobile Number
Site Contact (called 'job contact' in table)
Site Contact Mobile number (called 'job contact mobile number' in table)
Set up by (called 'setup by time' in table)
Pick up time
Stock required (increase size of box on form by about 50%)
Order details (called 'stock details' in table, increase size of box on form by 50%)
Blocks (checkbox on form gives a yes no result in the table)
Sandbags (checkbox on form gives a yes no result in the table)
Steel weights (checkbox on form gives a yes no result in the table)
Water barrels (checkbox on form gives a yes no result in the table)
Pegged (checkbox on form gives a yes no result in the table)
Entered into diary
Entered into diary date
Entered into schedule
Entered into schedule date
Final Confirmation date
Price (called 'job value' in table)
Balance (I would like it to automatically compute 'price' minus 'deposit paid' to give this value)
Quote sent (checkbox on form gives a yes no result in the table)
Quote sent date
Order sent (checkbox on form gives a yes no result in the table)
Invoice sent (checkbox on form gives a yes no result in the table)
A form that allows us to enter a number of search criteria and presents the results in a report, with the ability to also click on individual search results to take you to that specific event
I would like the search criteria to include:
Between two dates
Customer Name (pulldown list of all customers in table)
Between two prices (or 'job value' in table)
If I don't enter a value for one or more of the criteria, then I would like all that criteria to be ignored and all value returned ie If I don't enter between 2 'job values' prices then the results include all 'job values' prices.