DoCmd.RunSQL uses what library?

I'm in the process of removing all DAO code from a ADP project. I had
a bit of it sprinkled through the thousands of lines of VBA code.
To start with, I'm trying to decide whether or not I have to remove or
change this line of code...
DoCmd.RunSQL "SET NOCOUNT ON"
For one, does RunSQL use DAO? If not, what does it use?
For another, if this does use DAO, what is the appropriate replacement
that uses ADODB?
Thanks!
Maury
RunSQL should be part of the Access object library.

Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Maury Markowitz" wrote:
> I'm in the process of removing all DAO code from a ADP project. I had
> a bit of it sprinkled through the thousands of lines of VBA code.
> To start with, I'm trying to decide whether or not I have to remove or
> change this line of code...
> DoCmd.RunSQL "SET NOCOUNT ON"
> For one, does RunSQL use DAO? If not, what does it use?
> For another, if this does use DAO, what is the appropriate replacement
> that uses ADODB?
> Thanks!
> Maury

DoCmd.RunSQL uses what library?

I'm in the process of removing all DAO code from a ADP project. I had
a bit of it sprinkled through the thousands of lines of VBA code.
To start with, I'm trying to decide whether or not I have to remove or
change this line of code...
DoCmd.RunSQL "SET NOCOUNT ON"
For one, does RunSQL use DAO? If not, what does it use?
For another, if this does use DAO, what is the appropriate replacement
that uses ADODB?
Thanks!
MauryRunSQL should be part of the Access object library.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Maury Markowitz" wrote:
> I'm in the process of removing all DAO code from a ADP project. I had
> a bit of it sprinkled through the thousands of lines of VBA code.
> To start with, I'm trying to decide whether or not I have to remove or
> change this line of code...
> DoCmd.RunSQL "SET NOCOUNT ON"
> For one, does RunSQL use DAO? If not, what does it use?
> For another, if this does use DAO, what is the appropriate replacement
> that uses ADODB?
> Thanks!
> Maury

Docked Headers

Can I set my page header to stay visible on the screen while scrolling thru
the detail lines below it? Thanks.Exporting to Excel provides this facility, but not in other rendering formats.
So how you are planning to implement ?
Amarnath
"Larry" wrote:
> Can I set my page header to stay visible on the screen while scrolling thru
> the detail lines below it? Thanks.|||Hello Amarnath,
Thanks for the reply. I didn't think there was a way to keep the headers on
the screen within Reporting Services. I will tell my users they can do it in
Excel. Thanks.
Larry
"Amarnath" wrote:
> Exporting to Excel provides this facility, but not in other rendering formats.
> So how you are planning to implement ?
> Amarnath
> "Larry" wrote:
> > Can I set my page header to stay visible on the screen while scrolling thru
> > the detail lines below it? Thanks.|||You can also do this with the HTML and Winforms renderers in RS 2005. Set
the Table property "Header should remain visible when scrolling".
Best,
-Chris
SQL Server Reporting Services
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:2A1AB41D-D78E-4EA4-B6BF-89236035E530@.microsoft.com...
> Hello Amarnath,
> Thanks for the reply. I didn't think there was a way to keep the headers
> on
> the screen within Reporting Services. I will tell my users they can do it
> in
> Excel. Thanks.
> Larry
>
> "Amarnath" wrote:
>> Exporting to Excel provides this facility, but not in other rendering
>> formats.
>> So how you are planning to implement ?
>> Amarnath
>> "Larry" wrote:
>> > Can I set my page header to stay visible on the screen while scrolling
>> > thru
>> > the detail lines below it? Thanks.