Search results

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???

Colin you are a supersonic superstar nice 1 m8

I need to find what user is logged into the computer. Can you help?

I need to be albe to read the registry or something to that effect, to be able to tell what User is currently logged into the computer or domain. Can anyone help??

one way you can do this is by creating a button. in the button wizard goto application, and then run application. Select c:\windows\IEplorer.exe http://./help/index.html this will open explorer and show what ever address you put after iexplorer.exe

Im using the following command to send emails from AccessXP through OutlookXP. My problem is that i cant get the email to open in outlook as a HTML format email. Even though i tell it the format is acFormatHTML it takes no notice and opens it in plain text. the command line is...