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

[Guest]

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

 

[Wolfgang Kais]

Hello Klaus.

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?

First of all, you need to have a form.
The form should be base on the table.
This form can contain a command button.
And it should contain a textbox bound to the field eurovalue.
The textbox seems to be very important if using Office 2003 SP3.
It this was txtEuroValue, then the event procedure of the command
button should contain "Me.txtEurovalue = 0" (without quotes).

 

[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]

 

[Guest]

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