<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<DIV><FONT size=2>Paul,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>One other thing. As you work in VB and ADO you will
have to "unlearn" some Access stuff. One of those things may be the
brackets in your SQL statements. I don't know if they are the problem, but
they are not required.</FONT></DIV>
<DIV><BR><BR>>>> paul.hartland@fsmail.net 03/14/03 02:42AM
>>><BR>To all,<BR><BR>Has anyone had any experience with Active Reports
v2.0 for Visual Basic, if so I wondered if someone could help me with somthing
(bearing in mind I only started using it yesterday). I have built a report
using the ADO connector and I need it to buils the recordset on the fly. So I am
trying to use the following
method.....<BR><BR>repPersonnelByOffice.dcRptData.Recordset = "SELECT * FROM
[tblPersonnel] WHERE [FinishDate] Is Null ORDER BY [Office],
[Surname]"<BR><BR>But I get the error Type Mismatch and the whole line gets
highlighted when I click debug. Now I can't see anything wrong with this,
can anyone point out my mistakes please.......<BR><BR>Thanks in
advance.<BR><BR>Paul
Hartland<BR><BR>__________________________________________________________________________<BR>Freeserve
AnyTime - Go online whenever you want for just £6.99 a month for<BR>your first 3
months, that's HALF PRICE! And then it's just £14.99 a month<BR>after
that.<BR><BR>For more information visit <A
href="http://www.freeserve.com/time/">http://www.freeserve.com/time/</A> or call
free on <BR>0800 970
8890<BR><BR><BR>_______________________________________________<BR>dba-VB
mailing list<BR>dba-VB@databaseadvisors.com<BR><A
href="http://databaseadvisors.com/mailman/listinfo/dba-vb">http://databaseadvisors.com/mailman/listinfo/dba-vb</A><BR><A
href="http://www.databaseadvisors.com/">http://www.databaseadvisors.com</A><BR><BR></DIV></BODY></HTML>