G gregtank Registered User. Local time Today, 22:50 Joined Apr 25, 2005 Messages 13 Apr 28, 2005 #1 how can i assign a formula to a command button? also can anyone give me specific advice about calucalating the % of check boxes ticked across multiple records. thanks in advance
how can i assign a formula to a command button? also can anyone give me specific advice about calucalating the % of check boxes ticked across multiple records. thanks in advance
G gregtank Registered User. Local time Today, 22:50 Joined Apr 25, 2005 Messages 13 Apr 28, 2005 #2 anyone????
Mile-O Back once again... Local time Today, 22:50 Joined Dec 10, 2002 Messages 11,304 Apr 28, 2005 #3 Don't you think "bumping" a post after 15 minutes is a little impatient?
Mile-O Back once again... Local time Today, 22:50 Joined Dec 10, 2002 Messages 11,304 Apr 28, 2005 #4 gregtank said: how can i assign a formula to a command button? Click to expand... What do you mean by this? also can anyone give me specific advice about calucalating the % of check boxes ticked across multiple records. Click to expand... Use two DCount functions - one without criteria and one with criteria. Divide the latter by the former and you have the percentage.
gregtank said: how can i assign a formula to a command button? Click to expand... What do you mean by this? also can anyone give me specific advice about calucalating the % of check boxes ticked across multiple records. Click to expand... Use two DCount functions - one without criteria and one with criteria. Divide the latter by the former and you have the percentage.
G gregtank Registered User. Local time Today, 22:50 Joined Apr 25, 2005 Messages 13 Apr 28, 2005 #5 Don't you think "bumping" a post after 15 minutes is a little impatient? Click to expand... since no one had looked at it, no. What do you mean by this? Click to expand... so that when you click the command button a formula is run (i guess in the form of a macro)
Don't you think "bumping" a post after 15 minutes is a little impatient? Click to expand... since no one had looked at it, no. What do you mean by this? Click to expand... so that when you click the command button a formula is run (i guess in the form of a macro)
