Antal records i query med parametre

Hi Hugo
"Det er ikke at bruge DCount - selv om den virker"

Where do you use dcount so that it works?


Just an idea which is not tested but I dont see why it shouldnt work.

Make a query which just selects count

SELECT count(*) FROM NameOfYourQuery

DCount is very slow when handling large recordsets.

Your suggestion might work - will test it (today is my 25th wedding anniversary - so it won't be today)

Hi Hugo
Congratulations on your 25th wedding anniversary, hope you have a good day.

The reason why I ask about dlookup is to try and understand why using dlookup works, although very slow, but your normal method doesnt.

An example of my query:
SELECT tblProductCategories.fldProdCat, tblFVproducts.fldProductName, tblFVdryP.fldTestDate, tblFVdryP.fldWeightL, tblFVdryP.fldWaterPrct, tblFVdryP.fldGlowLoss, tblFVdryP.fldAbsBASF, tblFVdryP.fldAbsBASF_Oil, tblFVdryP.fldSievePrct250, tblFVdryP.fldSievePrct90, tblFVdryP.fldSievePrct63, tblFVdryP.fldSievePrct45, tblFVdryP.fldpH, tblFVdryP.fldColorV
FROM (tblFVdryP LEFT JOIN tblFVproducts ON tblFVdryP.fldProductName = tblFVproducts.fldProductID) LEFT JOIN tblProductCategories ON tblFVproducts.fldNewProdCat = tblProductCategories.fldCatID
WHERE (((tblProductCategories.fldProdCat)=[Forms]![frmProduct_Category_Export]![txtCategory]) AND ((tblFVdryP.fldTestDate)>=[Forms]![frmProduct_Category_Export]![txtDato_Start] And (tblFVdryP.fldTestDate)<=[Forms]![frmProduct_Category_Export]![txtDato_End]))
ORDER BY tblFVproducts.fldProductName, tblFVdryP.fldTestDate;


MsgBox fhpQuery_Record_Count(strQuery) = 0
MsgBox DCount("*", strQuery) = 10

have you tried SELECT count(*) FROM NameOfYourQuery ?

Not working with saved query with parms.

I've just made a simple example where a query takes a parameter from a form. Then I made a query as suggested d. 24. marts 2009 kl. 19:22:44 and it works.

Is there any chance of a db with an example of your problem?

I will try and see if I can get one brewed together - it is a 40 mb frontend and a 45 mb backend I will have to splitt up :-)

No need for all the data, and only the relevant objects are necessary

Do you use 2007 Terry?
The app. is version 2007!

Yes I'm using 2007

I will send you a copy of the db with explantion of what the 'problem' is.

A year ago I didn't like 2007, but now I believe it to be the best Access so far :-)

Kom aldrig videre med dette problem.
Terry smid lige et svar så jeg kan lukke spørgsmål.

Take them yourself Hugo

Jamen så lukker og slukker vi.