Ask a Question related to Microsoft Access, Design and Development.
Dickie Black #1
Should open multiple recordsets, or just one?
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
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
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 Guest
OK, I know there has to be a better way to do this, hopefully someone can shed some light on this subject. Using SQLServer 2000 and VBscript...
Does anyone know how to place two or more INDEPENDENTLY PAGEABLE different sized recordsets on the same output page using DM8/ASP? I have created...
I'm using a stored procedure that returns multiple recordsets (it contains multiple select statements) in a vb.net dev environment. The problem is...
Hey all I'm not sure if there's anything that can be done about this or not. I'm displaying the contents of two different tables (using Access for...
I am using ASP 3.0/ADO to call an SP. The SP has multiple SELECT statements so I need to get the multiple return sets but I cannot find the right...