advise on how to....???

[Jean-Paul]

Hi,

I have a list of firms.
I pick a firm, enter the date I want to visit it and the time I want to
spend there (from... untill...)

Finally I want a screen with a week view:

mon 12/01 thu 13/01 wen 14/01
8:30
9:00
9:30
10:00
10:30
11:00
...............

What is the most efficiant way to get this "coded"
Finally I think I will have a database with records like:
FirmA, 13/01/09, 9:00, 10:30
FirmB, 13/01/09, 11:00, 12:00
and so on...

Any idea how to get these data in a week-view? Should I redesign the
table-structure....

Thank you all for the ideas

 

[strive4peace]

Hi Jean-Paul

You can use three subforms. Each can use the same SourceObject -- just
change the LinkMasterFields and LinkChildFields to this:

for subform1:
LinkMasterFields --> FirmID, VisitDate1
LinkChildFields --> FirmID, VisitDate

for subform2:
LinkMasterFields --> FirmID, VisitDate2
LinkChildFields --> FirmID, VisitDate

for subform3:
LinkMasterFields --> FirmID, VisitDate3
LinkChildFields --> FirmID, VisitDate


VisitDate1, VisitDate2, and VisitDate3 are calculated

pre-2007, you can assign these in the code or let the user pick them and
they can be used in the LinkMasterFields even though they are not bound

In 2007, I think you need to update the Recordsource with the values and
make them bound controls



Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*