In Progress

Instant Marquees Event database

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 :

Date Booked

Booked By

Job Date

Job Day

Customer Name

Booking Contact

Booking Contact Phone Number

Booking Contact Mobile Number

Street Address

Suburb

Postcode

Melways Reference

Site Contact (called 'job contact' in table)

Site Contact Mobile number (called 'job contact mobile number' in table)

Arrival time

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

Final Confirmation date

Event Name

Event Type

Price (called 'job value' in table)

Deposit paid

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

Quote number

Order sent (checkbox on form gives a yes no result in the table)

Order number

Invoice sent (checkbox on form gives a yes no result in the table)

Invoice number

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)

Event type

Suburb

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.

Skills: Microsoft Access

See more: instant marquees, access report event database, microsoft access event database, access event database, microsoft access job, job values, job event, instant page, event database access, job street, event site, diary, balance job, customer details database, database invoice microsoft access, customer invoice report, invoice balance, adjust invoice, suburb postcode, phone number confirmation, entered values, event report, microsoft price list, checkbox required, access linked table

About the Employer:
( 1 review ) Malvern East, Australia

Project ID: #1160816

Awarded to:

AccuPro

Please check PMB.

$200 AUD in 7 days
(1 Review)
2.5

2 freelancers are bidding on average $225 for this job

mbartone

I have extensive experience in MS Excel and Access. I'm very interested in your project.

$250 AUD in 4 days
(0 Reviews)
0.0