Select Count(*) question

In VB6 I have this code for returning data to a recordset via 2
Selects:

1. Select * from MyTable (98 rows of data are here)
rs.recordcount returns "98"

2. Select count(*) from MyTable
rs.recordcount returns a value of 1 - which is fine
Here, rs!results returns "98" - this is very helpful in other parts of
my app.

Thinking I could just copy the code from VB6 to Access 2003, I did
that.
But in my Access app, I found I cannot use "rs!results". (also tried
"rs.results" which did not show up in the intellisense)
My select count yields 1 row here too, but I need to return the results
of that count (that shows that 98 rows were counted) like I did in the
VB6 app.

Is there any way in Access to return the results of a select count?

Thanks.

.

Relevant Pages

  • Re: Validating "Orders" form
    ... IMO it would be a PITA to write an app in VB6 because of this 'limitation' ... I have a similar app and simply check for Order details when I close the Orders form. ... You should, however, be able to do a little more validation ...
    (comp.databases.ms-access)
  • Re: Passing an ADO recordset using remoting
    ... > I have inherited an existing Windows application written in VB6 with all ... DL embedded in the one app. ... > I have created a server component to return a disconnected recordset (not ... > dataset) to the client using TCP remoting. ...
    (microsoft.public.dotnet.framework.remoting)
  • RE: GetWindowsDirectory retrieves wrong directory under Terminal S
    ... We use the same api in VB6, I created a simple VB6 DLL and referenced it ... from my C# test app and also a VB6 test app. ... applications and needs to read the legacy application's INI file from the ... mapped to a Windows folder within their profile. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: General question about upgrade path
    ... While the app does just about everything I want it to, ... > wasn't worth the hassle of upgrading. ... Do I need to move to VB6? ... There is a close analogy between the Coke snafu 20 years ago and MS's ...
    (microsoft.public.vb.general.discussion)
  • Re: Advice Needed...
    ... items in a listbox). ... What about access controls is better? ... looking) is that they can handle multi-column data, where a VB6 listbox ... The only real issue is the problems when an app shuts down unexpectedly. ...
    (microsoft.public.vb.general.discussion)