Counting records in Access DB using VB Code 
Author Message
 Counting records in Access DB using VB Code
I need to track the amount of records placed in an Access 2000 db.  I am
using VB6 sp4.  If I create an autonumber field, It counts ALL the records I
put in. How can I go about counting each recordset throughout the week so
that every tenth record will run a different form.

Thanks for all the help,

J



Sat, 10 Jul 2004 10:26:41 GMT
 Counting records in Access DB using VB Code

Hi,

Based on my understanding, you want to count the records which date are a
in a particular week. If so, you can open a recordset with a such a Select
statemnet:

Select Count(*) from table1 where mydate between '01/21/2002' and
'01/27/2002'

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)



Thu, 15 Jul 2004 19:42:34 GMT
 Counting records in Access DB using VB Code
Well actually,  I need to count record everytime an event procedure occurs.
When they click the command button, it will count the records.  Every tenth
record the procedure will fire off a different form than the regular form.
Can this be done?

J


Quote:
> Hi,

> Based on my understanding, you want to count the records which date are a
> in a particular week. If so, you can open a recordset with a such a Select
> statemnet:

> Select Count(*) from table1 where mydate between '01/21/2002' and
> '01/27/2002'

> Luke

> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)



Sat, 17 Jul 2004 07:34:48 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. appending records to ACCESS db with VB code

2. appending records to ACCESS db with VB code

3. Converting Access 2.0 DB to Access 97 DB in VB code

4. Possibility of creating MS-ACCESS DB using VB code

5. Trying to INSERT info from Access DB using VB 6.0 to SQL 6.5 DB

6. using SELECT COUNT(*) to count distinct records

7. Quickest way to code Copying/Moving a record key with VB/SQL using ADO

8. HELP: ...in converting 16-bit access db to 32-bit using VB not ACCESS 97

9. Getting to code in VB module for Access DB

10. Importing into an Access DB thru VB code

11. Opening a db within Access VB code

12. Saving Images To Access DB from VB code


 
Powered by phpBB® Forum Software