Hi ,
I need to get a number of rows in specific table to variable of type integer .
when i do the following :
Dim i As Integer
i = DoCmd.RunSql("select count(*) from myTable")

This throws me Exception . I know that this is not the smartest way to do this , but i just don't know other methods to accomplish the task .

Try

i = DCount("[PrimaryKeyField]", "myTable")

Where you replace PrimaryKeyField and myTable with their actual names.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks , It worked!