Need advice from Access Developers

[dawdy]

So I'm designing an Access 2003 database for a small handyman company. They need to be able to schedule Tradesmen for estimates and jobs. I was wondering what would be the best way to implement a schedule/calender in Access 2003.

 

[Traire]

Just start with the "Service Call Manegment" template and then tweak and customize it how the company wants it.

 

[KLin]

I've gotta agree with Traire. I just took a look at that template (downloaded from microsoft) and it looks like that's what you're looking for.

 

[dawdy]

Its kinda what I was looking for but its missing one important feature. The end-user wants to schedule a tradesman for a certain service call (work order) based on that tradesmans availability. I don't see a way of preventing double booking a tradesman for 2 different work-orders on the same day using that Template. How can I ensure that only available technicians can be chosen for a given work-order service date.

 

[Traire]

1. Add a date column to the "Workorder Labor"

2. Add a field to the "Workorder Labor" Form for the date field

3. Add a button to the "workorders" form that runs a macro that checks the "Workorder Labor" table for dublicate dates with the same employee. If it finds duplicates, prompt, if not, close the form.

 

[dawdy]

Muchas Gracias Traire =)

 

[dawdy]

Well I thought my Access book had instructions for making macros but it says to use VBA for handling events. Should I use VBA instead of a macro? And if I should use a macro is there somewhere on the web I can go to find a tutorial on building macros? Thanks for the help!

 

[snidy1]

you can learn macros in a couple hours, they are easy, and you can convert them to vb if you want to.