Dcount Type Mismatch error

[jeskit]

Hi,

I am trying to build a macro which will run when a form opens. I am trying to create a macro which first ask for a number to be entered. Then take that number a count however records in a table with that member number are listed with a yes/no field called Disc check as yes.

However my code keeps getting a Type Mismatch error on the line highlighted below:

Please Login or Register  to view this content.

Can any help with this error? As I can not get it to work.

Thank you,

Jeskit

[Debraj Roy]

Hi Jeskit,

I think.. any D-Formula doesn't work with ARRAY.. it needs a range.. where we need to specify Conditions..

If it possible to store the DATA & Condition is a separate area in the gridsheet.. and in macro provide the complete range like "M1:O3".. hope it will work..

Please upload sample file with expected output..

Regards,
Deb

[arlu1201]

Is this an access question or excel?

[Cyclops]

Hi,

I am trying to build a macro which will run when a form opens. I am trying to create a macro which first ask for a number to be entered. Then take that number a count however records in a table with that member number are listed with a yes/no field called Disc check as yes.

However my code keeps getting a Type Mismatch error on the line highlighted below:

Please Login or Register  to view this content.

Can any help with this error? As I can not get it to work.

Thank you,

Jeskit

Access Question...


I would guess the problem is with

"Number] & [Disc]"

You are missing the bracket before number but I also don't know that you need or want two fields there. Pick a field that you know will have a value in it. Any value should do.

Maybe

Please Login or Register  to view this content.

Also see:

http://office.microsoft.com/en-us/ac...001228817.aspx

[Cyclops]

Actually I don't think that's quite right. The And needs to be part of the string too

Please Login or Register  to view this content.

If that doesn't work then try

Please Login or Register  to view this content.

You need the single quotes for text values not sure if you need them for numbers.