Set a Yes/No value in Access & using onmouseover

[Mpatt]

Hi all,
I've got a button on an Access Data Access page, which has the following script behind it:

<SCRIPT language=vbscript event=onclick for=CloseIncident>
<!--

set network = createObject("wscript.network")
ClosedBy.value = network.username
DateClosed.value=now()
IncidentClosed.value= -1
-->

This successfully changes the DateClosed & ClosedBy values, but doesn't change the IncidentClosed value (which is defined in the table as a Yes/No value). Can anyone tell me what I'm doing wrong? I've tried all combinations of Yes/True/-1 with & without double quotes.

Also on the page when the user hovers the mouse over the button I'd like to display a description of the button, which will then dissapear when they move the mouse away or press the button. I've can get it to display a msgbox with text - but I don't want to display a box with a button.

TIA for any help.

M:

 

[tsuji]

Hello Mpatt,

Try vbYes and vbNo which is 6 and 7 respectively.

regards - tsuji

 

[Mpatt]

tsuji,
Thanks for the reply, but it didn't work.
For the benefit of anyone else who might pass this way what I need to do is:


IncidentClosed.checked=True