Replies

Thanks for all your help Hans…for future reference what would I use if it were a variable instead of a field?

Thanks for all your help Hans…for future reference what would I use if it were a variable instead of a field?

BusPros is the name of the field
qryBLSD is the name of the query

BusPros is the name of the field
qryBLSD is the name of the query

Sorry to be such a pain in the butt on this stuff, but once again I’m stuck. I’m trying to change a text box’s Control Source when a button is clicked. I know I’m missing a + or ” here and there, can someone help? Here’s what I’ve got:

Text5.ControlSource = “=DCount(” + [BusPros] + “,” + [qryBLSD] + “,” + [BusPros] = 1 + “)+”

Sorry to be such a pain in the butt on this stuff, but once again I’m stuck. I’m trying to change a text box’s Control Source when a button is clicked. I know I’m missing a + or ” here and there, can someone help? Here’s what I’ve got:

Text5.ControlSource = “=DCount(” + [BusPros] + “,” + [qryBLSD] + “,” + [BusPros] = 1 + “)+”

Well, after trying to get the db down to 100KB, I somehow got the code working…so I’ll play around with it some more

Well, after trying to get the db down to 100KB, I somehow got the code working…so I’ll play around with it some more

Its a number field

Its a number field

i tried your way, but entering “1” still returns “10, 11, etc”…btw, thanks for all your help Hans

i tried your way, but entering “1” still returns “10, 11, etc”…btw, thanks for all your help Hans

Got another question on DCounts….I’m picking out all of the fields where the data is 1, 3 and 5…but its returning all of the records? This is what i’ve got:
=DCount(“[DataManager]”,”[tblMain]”,”[DataManager]=1″ And “[DataManager]=3” And “[DataManager]=5”)

Got another question on DCounts….I’m picking out all of the fields where the data is 1, 3 and 5…but its returning all of the records? This is what i’ve got:
=DCount(“[DataManager]”,”[tblMain]”,”[DataManager]=1″ And “[DataManager]=3” And “[DataManager]=5”)

First one worked, thanks