D
Dickie Black
Hi,
I find myself once again returning to a problem project I have been so far
unable to finish...
I have a table of teaching session data and another of teachers, with a link
between the two. I have an unbound form with 20 labels (4 x 5 arrangement
for each teaching session in a week) that when clicked open a data entry
form for the specific session clicked on (eg monday, 9:30 am).This part
works fine.
What I would like is for the labels for each session to be updated with a
text string summarising each session once a week has been selected from a
combo box. I vaguely know what I need to do but require some help in the
specifics.
I know I could do this using 20 different record sets, eg:
OpenRecordSet("Select * FROM [SessionTable] WHERE [SessionTable].[Date] = "
& DateFromComboBox " & " AND [SessionTable].[StartTime] = " & StartTime &
";")
but would this create a significant delay accessing data accross a network?
Could I instead create one record set for the whole week (possibly using a
temporary table) and then search within that?
Any comments would be greatly apprectiated,
Dickie Black
I find myself once again returning to a problem project I have been so far
unable to finish...
I have a table of teaching session data and another of teachers, with a link
between the two. I have an unbound form with 20 labels (4 x 5 arrangement
for each teaching session in a week) that when clicked open a data entry
form for the specific session clicked on (eg monday, 9:30 am).This part
works fine.
What I would like is for the labels for each session to be updated with a
text string summarising each session once a week has been selected from a
combo box. I vaguely know what I need to do but require some help in the
specifics.
I know I could do this using 20 different record sets, eg:
OpenRecordSet("Select * FROM [SessionTable] WHERE [SessionTable].[Date] = "
& DateFromComboBox " & " AND [SessionTable].[StartTime] = " & StartTime &
";")
but would this create a significant delay accessing data accross a network?
Could I instead create one record set for the whole week (possibly using a
temporary table) and then search within that?
Any comments would be greatly apprectiated,
Dickie Black