Setting a table field value to"0,00" after command button click

[Amateur]

Dear Sirs
- I have a trading.mdb.
- In this DB I have a table called "clientspool".
- In this table I have a field called "eurodeposit".

I would like that, with a click of a command button, the field "eurodeposit"
is set to "€ 0,00".

Can someone tell me how to do that?
Thanks very much
Klaus

 

[John W. Vinson]

Dear Sirs
- I have a trading.mdb.
- In this DB I have a table called "clientspool".
- In this table I have a field called "eurodeposit".

I would like that, with a click of a command button, the field "eurodeposit"
is set to "€ 0,00".

In... what? The current record on the form? If so, just set the Format
property of the field (which I hope is of Currency datatype: if not change it)
to the Euro display you prefer, and put

Private Sub cmdZeroDeposit_Click()
Me!Eurodeposit = 0
End Sub

in the Code Builder in the click event of the command button.


John W. Vinson [MVP]

 

[Amateur]

Sorry John, my mistake. I start again.

- I have a table named "clientspool"
- I have a field in this table called "eurodeposit"
- I have a main switchboard form with a command button, which is executing
already some tasks.
This is the code for the button until now:
Private Sub Command20_Click()
Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\cps208\writeinvoices.mdb"" /X invoicenumbersdelete", 0)
Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\cps208\trading.mdb"" /X endofday2", 0)
Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\cps208\trading.mdb"" /X endofmonth", 0)
Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\cps208\trading.mdb"" /X endofday2", 0)
End Sub

I would like that this command button as well sets my table values for the
field "eurodeposit" to "0" - so, somehow I have to tell that the field
"eurodeposit" in the table "clientspool" = 0 when I click the button.
Can you help?
Thanks very much
Klaus