Re: Limiting the times a record can be updated
Tech-Archive recommends: Fix windows errors by optimizing your registry
On Mon, 19 Sep 2005 16:15:19 -0500, "George Nicholson"
<JunkGeorgeN@xxxxxxx> wrote:
>John, didn't you mean to say the BeforeUpdate event?? (if not, how does the
>value get saved since the 2nd BeforeUpdate will cancel itself?)
Quite right! Mental lapse there - I was thinking of a Control's
AfterUpdate, rather than a Form's. BeforeUpdate it is (and I like your
Datefield idea even better).
John W. Vinson[MVP]
.
Relevant Pages
- Re: SQL queries from VB
... Therefore, I had thought I would, during the BeforeUpdate event, query the ... already exists, and if it does, VB would cancel the update. ... You need to add a reference to the DAO library. ... Dim rs As DAO.Recordset ...
(microsoft.public.access.formscoding) - Re: I want a field to save with 0.00
... the textbox changes. ... the BeforeUpdate event doesn't fire when the value is changed ... You can either call the BeforeUpdate event yourself in the ... will cancel the save if you choose to cancel. ...
(microsoft.public.access.forms) - Re: Cancel a new record
... True and the event will automatically cancel (this applies to any control ... Pivate Sub MyTextBox_BeforeUpdate ... > I am checking in the afterupdate event, I can try the beforeupdate event. ... > I decided not to use this route because the combobox really has to display ...
(microsoft.public.access.formscoding) - Re: Understanding Cancel
... > I need to better understand how the Cancel method works. ... > When the user enters a SpoolQty amount that causes the NetWeight ... what the BeforeUpdate code means, ... AfterUpdate has ...
(microsoft.public.access.formscoding) - Re: Problem Saving Changed Data
... The Macro or Function set to the BeforeUpdate or ValidationRule (I ... all you have to do is set Cancel = True to NOT ... By trying to call a refresh in this event you are ...
(microsoft.public.access.formscoding) |
|
