Would Like someone to upgrade my database...will pay

[MickyB]

I was wondering if someone could change, ad to or rebuild this database I have created to include a scheduling calander and do everything else it currently does. It works fine but I would like it to create an appointment schedule from the customers and jobs inputed The Carpet Cleaning Pro.zip

[Bob Fitz]

MickyB

I would like it to create an appointment schedule from the customers and jobs inputed

Can you give us more details of your requirements

[MickyB]

I have created a database that creates job sheets, invoices, expenses, invoice payment tracking freports, customes etc. I would like it to create a job schedule calendar aswell from the data that is input....allocate times slots on a calander and set times for the different jobs but... I have no idea how to do this

[mike60smart]

Hi MickyB

Your table "JobDetails" is not normalised as it contains fields like"-

JobType1
JobType2
JobType3
JobType4
JobType5

as well as

JobDescription 1 through 5

&

Cost 1 through 5

This needs to be corrected before anything else is done.

Is this database in actual use?

[davegri]

I would like it to create a job schedule calendar aswell from the data that is input....allocate times slots on a calander and set times for the different jobs but... I have no idea how to do this

You're still not being clear as to what you want. How would you like the calendar to display - like a wall calendar with 30 days showing that you can type into the days?
Or do you mean you want a means to enter future jobs as recurring events in your job detail table? We can't help if we can't visualize what you want.
Simply repeating what you already have provided is no help.

[MickyB]

how do i correct them and what do i correct them with

[MickyB]

I want to be able to to see all bookings on a calendar month by month or week by week. Basically a database that we can input the customers and jobs and it shows them on a calendar and also creates job sheets, invoices, receipts, payment tracking, job reports, etc

[MickyB]

how do i correct them and what do i correct them with

[MickyB]

Yes this database is in use and works perfectly for me but I want to be able to see the appointments on a calander and perhaps be able to book jobs in from that calander view.

[davegri]

Do you schedule on weekends? Should the calendar show 7 days per week or just 5? How much data should show on the calendar - just the customer name and time or more? Not much space there. Typically how many jobs are scheduled on a given day?
How many people use the database? How many computers have access to the database?

[MickyB]

yes we schedule weekends. yes 7 days showing. Cusomer name and time showing. may be upto 5 jobs on any day. we run the database in a shared network folder so more that one can access it.

[davegri]

See how this works for you:
CCP2020-davegri-v01.zip

[ssanfu]

@davegri, Nice! I had started making changes, but I hadn't started on the calendar part - just fixing the object names, PK/FK names and figuring out the relationships (restructured a couple of tables).
Now I'm going to study your calendar addin.



@MickyB

) we run the database in a shared network folder so more that one can access it.

Do you mean that the dB is an all-in-one, is on the network and many people are in it at the same time?? If YES, then you are flirting with disaster!! This setup is a sure way to corrupt your dB.

The dB should be split into a BE (back end) that has only the tables and a FE (front end) that has all of the other objects. The BE would be on the network and (the tables) would be linked to the FE.
EACH used should have a COPY of the FE on their local computer.

IF the dB is an all-in-one and multiple people are using it at the same time, it is not a question of IF the dB gets corrupted, it is just a question of WHEN.

[davegri]

Did some more work on DB.
Cleaned up some reserved word usage in code.
Fixed problem with subform not always showing correct job.
Added search comboboxes for customer and company.

CCP2020-davegri-v02.zip

[davegri]

Still more refinements:
CCP2020-davegri-v03.zip

Added some remarks to VBA code
Increased size of calendar textboxes so that font size could be larger
Modifed field widths of listbox on frmCalendar
Fixed total amounts in listbox on frmCalendar
Added VBA code to Refresh button on job subform to clear filters and remain on current customer (was embedded macro)
Removed some commented out superfluous code
Toned down color of current day block in calendar
Added custom navigation buttons to main form with color indicator for filter on