How do you think I should do this?

[PrincessBretti]

I have a database that can have any number of appointments booked for each client.

Thing is how do I neatly display all of these appointments?

I thought I would use a tab control, that would self build based upon the number of appointments.

This I have done quite easily however I now need the data to be displayed on each of these self built pages.

Should I create a subform on each page or is there a way of creating a page and copying it using VB code, instead of using the createcontrol command?

Also when I use that command how can I create the subform on the page of the tab control, instead of on the form?

A bit long winded I know

Princess

 

[Rich@ITTC]

Hi Princess

I would be wary of trying to create aditional tabs for each appontment. This might be fine for someone with 3/4/5 appointments, but what happens in 4-5 years time if that person has got up to 20 or 30 appointments - is it realistic (or even feasible) to have 28 tabs?

Why not have a subform (perhaps on a tab for appointments) that is a continous form or datasheet view based on a query drawing up appointments in chronoligcal order (most recent at the top?)? You could then set up a double-click event on the fields for each row that would open another (popup?) form to add specific details on the appointment.


HTH

Rich Gorvin

 

[PrincessBretti]

Thanks for the reply,
Unfortunately the ppl who will be using this, are not computer literate and not too bright

so I wish to steer away from any non visual displays(datasheets), and multiple windows (can you imagine the clutter?).

I think that you have made a good point however and that the form should show only a range of dated appointments, and that previous ones to this can be accessed via another route (ie the datasheet version that you suggested).

Thanks again

Princess

 

[dreamdelerium]

you know, i has a similar issue, so i created a form that was a calander. i created it so taht by clicking on each date you could add an appointment, which would be stored in a table. everyone loved it, although it was a bit time consuming to create but worth it

 

[DCrake]

Simple Software Solutions

Princess??

What is feasable is to have a self generating Microsoft Forms 2.0 (see activeX Controls) but make sure you set the property of the multi row to False. What happens then is that the tabs that cannot be seen become virtual tabs similar to Excel tabs at the bottom of a spreadsheet. You can use the appointment date as the text for the page(s). Now when you want to display data for each appointment you do not have to create a subform for each page. Simply position the one subform below the tab strip and resize it over the area containing the appointment data area.

Your next would be to create a function that runs on the tab strip click event to read the index number and get the page caption (the Appt Date) this would then give you the criterion for which to display the details on screen.

CodeMaster:http://www.icraftlimited.co.uk