Prev: Combo ?
Next: Form Search Parameters
From: gagecres on 25 Feb 2010 16:14
I'd like to grey out a button on my form if there are no records saved in the
database. Is there a way to do this?
From: ghetto_banjo on 25 Feb 2010 16:57
to make a command button "greyed out", or disabled, you can do it in
VB like:

me.buttonname.enabled = False



If you want to check if a table has no records you could do:

if DCount("*", "myTable") = 0 then
me.buttonname.enabled = False
Else
me.buttonname.enabled = True
end if


From: gagecres on 25 Feb 2010 21:42
In which object property do I insert this code?

"ghetto_banjo" wrote:

> to make a command button "greyed out", or disabled, you can do it in
> VB like:
>
> me.buttonname.enabled = False
>
>
>
> If you want to check if a table has no records you could do:
>
> if DCount("*", "myTable") = 0 then
> me.buttonname.enabled = False
> Else
> me.buttonname.enabled = True
> end if
>
>
> .
>
From: John W. Vinson on 26 Feb 2010 01:10
On Thu, 25 Feb 2010 18:42:01 -0800, gagecres
<gagecres(a)discussions.microsoft.com> wrote:

>In which object property do I insert this code?
>
>"ghetto_banjo" wrote:
>
>> to make a command button "greyed out", or disabled, you can do it in
>> VB like:
>>
>> me.buttonname.enabled = False
>>
>>
>>
>> If you want to check if a table has no records you could do:
>>
>> if DCount("*", "myTable") = 0 then
>> me.buttonname.enabled = False
>> Else
>> me.buttonname.enabled = True
>> end if
>>
>>
>> .
>>

The form's Current event property (it should say [Event Procedure] and you
would enter this code, appropriately edited, by clicking the ... icon and
choosing Code Builder).

If an entry in some other control should disable the button, put the same code
in the AfterUpdate event of that control as well.
--

John W. Vinson [MVP]
From: gagecres on 26 Feb 2010 09:31
Thanks to you both. This worked perfectly.

"John W. Vinson" wrote:

> On Thu, 25 Feb 2010 18:42:01 -0800, gagecres
> <gagecres(a)discussions.microsoft.com> wrote:
>
> >In which object property do I insert this code?
> >
> >"ghetto_banjo" wrote:
> >
> >> to make a command button "greyed out", or disabled, you can do it in
> >> VB like:
> >>
> >> me.buttonname.enabled = False
> >>
> >>
> >>
> >> If you want to check if a table has no records you could do:
> >>
> >> if DCount("*", "myTable") = 0 then
> >> me.buttonname.enabled = False
> >> Else
> >> me.buttonname.enabled = True
> >> end if
> >>
> >>
> >> .
> >>
>
> The form's Current event property (it should say [Event Procedure] and you
> would enter this code, appropriately edited, by clicking the ... icon and
> choosing Code Builder).
>
> If an entry in some other control should disable the button, put the same code
> in the AfterUpdate event of that control as well.
> --
>
> John W. Vinson [MVP]
> .
>
 | 
Pages: 1
Prev: Combo ?
Next: Form Search Parameters