Recent content by Hunter666

I am using Access2002 XP. Surley there must be a very easy and simple way of counting these records... What i am trying to do is create some sort of Database statistics. i.e. there are so many companies on the database with so many email addresses and so many of the companies havnt been...

I am using Access2002 XP. Surley there must be a very easy and simple way of counting these records... What i am trying to do is create some sort of Database statistics. i.e. there are so many companies on the database with so many email addresses and so many of the companies havnt been...

Can you tell me more about the Dcount()method?? Paul

I cant seem to open any form of recordset. Ive tried both tables and queries and all i get is a Type Mismatch

Thanks for pointing that out. I have done it like. that i have just made a typo putting it up on the BBS. But still Type Mismatch.

I am trying to open a recordset from a query and count the number of records in it. Very simple task you might think. However every which way people tell me to do it dosnt work. The code so far is as follows: 'Note EmailCount is the Query Name Dim DB As Database Dim RS As Recordset Dim...

The Email field is Text Default is Null and yes the query normally works fine. Paul

im trying to count the email addresses in this example. the table is called "Contacts" the field storing the email addresses is called "Email". The Select query im using to select only Email >"" is called "EmailCount". The way ive been doing it before this is to open a form with "EmailCount" as...

I have counted the number of records without using much code. However i want to create a more extensive report on the database. i.e. there are X amount of companies with X amount of contact and X amount of email addresses and so on.... I have now added the reference and its no recognising the...

Im still having a little trouble with this. The code above dosnt seem to work for me. it complains that "Dim db as Database" is not a valid variable. Can anyone help? Paul

Many thanks to you both for your help! Paul

Thank you. Do you have an example? Paul

i need to capture the data from a query in a record set and then count the number of records in the set......can anyone help me??

The problem you will have with autonumbers is when you create a replica of your database. When you do this the autonumbers no longer run in order.

I need to be able to filter by selection using VBA but havnt got a clue. i need to search a field (no problem) find the data i want to filter and then filter it. Can anyone please help???