Calendar form? For Secutiry company db

[mulu]

Hi There

I hope someone can assist me. I am creating a database for a Security Company.

I would like to create a form (which looks like a calendar), where I can select the name of the client in a combo box on the top of the form, and then a calendar displays for that specific client. I must then be able to type in the name of the security gaurds (employees) who worked at that client's Premises on that specific day.

I must also be able to pull reports from that information, (eg, print the calendar per company and per month), and also a summary of how many shifts each employee worked during a specific period.

The form for this does not necessarily have to be a "Calendar', any suggestions on how else I could do this would also be greatly appreciated

Thank you kindly

Melissa

 

[Mike375]

I would like to create a form (which looks like a calendar), where I can select the name of the client in a combo box on the top of the form, and then a calendar displays for that specific client.

When you say "then a calendar displays for that specific client" do you mean a listing of dates/appointments/times etc of that person.

On the surface at least you are talking about a fairly extensive DB and a lot more than a pop up calendar.

Have you made any attempts to make the DB yet...such as tables or queries/forms

 

[mulu]

Hi Mike

I have attached an example of what I would the CalendarForm to look like. I found this example on the internet.

What I would like to do is put a comboBox on the top of this CalendarForm, and when i select a Client from this comboBox, the calendar "Inputs" need to only display for that specific client.

For eg. If i select the company 'ABC Trading" from the combo box, and type the Employee name: Edwin, in the block for 14th Feb09, it must save it. so when i select a different client from the combo box, "Edwin" must not appear in the block for 14thFEb09.

Then if i return to "ABC Trading", "edwin" must appear again.

I hope this makes sense...

kind Regards

Melissa

 

[Mike375]

Melissa

Your attachment only has a linked table.

 

[mulu]

Im terribly sorry, please find attached.....

 

[Mike375]

Melissa

To help out here it needs one of the members who is into unbound forms and SQL statements within VBA. and that is definitely not me

I think it would need something done to get the entry in the imput box to link with the Company table rather than just a lookup table.

I will be interested to see what someone comes up with. Personally, I have yet to see one of these calendar setups equal what we make for telemarketing DBs, however, they are virtually a complete DB within the DB. Looking at you first post I think there will be a fair bit of work to do.

I will watch the thread with interest because I am always on the lookout for diary systems and any improvement I can get.