Search results

Hi, I want to enable a button on the form based on either 2 values If txname.value = " vb- 99453037" or "43331954" then Button. Enabled = true Else Button. Enabled = false It only works for first value (vb-99453037)and not for both any suggestions??

Well if they is no other way to fix this I guess will have to use two controls to show count for pending and blank records!!!

Well I still get a zero value with the above formula... Please help out

I'm not sure plog... Are you suggesting to make changes to the last part of the formula?!! Ie; with regards to null value..

Sure will try with this.. Thank you

I'm still getting the #error in the field... posting the control source formula ..please advise what's missing. =DCount("adviserall","tblmain","[queue type] ='MSCCBR' and [status] = 'Pending' or Is Null) I'm sure there might be comma error somewhere, please guide..

For status here I'm using [status] = "pending" or [status] IsNull Still getting #error... Please advise

Sure will give it a try.. Thank you all..

How about if the field is null and I want to count that as well.. I can enter " pending " but what about a null field?

OK thank you both.. Will try out

That link is for dlook up.

Hi, Hope some one can help me with the dcount formula for a text box on form. I want to count the number of items pending or left blank for a particular queue for the user. User is fosusername() Table is tblmain Fields are queues, status. The formula should count for that user from that table...

What about ODBC connection will that help?

Hi, I have an excel file with few records the last record is titled status. I've an access form which gets these records. My question is how can I make changes to a field on form so that is gets automatically updated on that excel sheet. Ex. When I select "resolved" on the status field on...

What I meant was under control property of the two labels that I mentioned I want the dcount function to count total records in the table and the total records based on the criteria of another text box. Hope this explains.

Hi, Just wanted to check what would be the control property for dcount function.. Which 1) will count the total records based on user field. 2) will count the total records based on user them self. ( customized based on user) This I want to set as two labels titled as below on the form banner...

Great thanks for this.. Will get back soon

Will it take care of vbyes also.. ie; to continue with update even if it's duplicate?

I'm sorry but I wanted this as a label on the banner... Active users: (count)... For this label what should be the control source. Just please confirm me the code to be pasted there.

I don't think that's a resolved post!!!