Visual Basic, "Object Required" error

"Object Required" error

Author	Message
Allen J. Bennet #1 / 2	"Object Required" error I get an "Object Required" error on the second ampersand in the following statement--any idea why? Set rstDynasetAppointmentCalendar = ("Select * From Calendar where AppointmentDate = #" & Mh3dCalendar1.Date & "#") Allen J. Bennett
Wed, 17 Oct 2001 03:00:00 GMT

Greg #2 / 2	"Object Required" error Set rstDynasetAppointmentCalendar = mdb.OpenRecordset("Select * From Calendar where AppointmentDate = #" & Mh3dCalendar1.Date & "#") Did this help? greg Quote: >I get an "Object Required" error on the second ampersand in the >following statement--any idea why? >Set rstDynasetAppointmentCalendar = ("Select * From Calendar where >AppointmentDate = #" & Mh3dCalendar1.Date & "#") >Allen J. Bennett
Thu, 18 Oct 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]