On 16 May 2007 23:04:13 -0700, Matuag <ma****@gmail.comwrote:
There is no need for these buttons.
Save: is automatic. Or click the recordselector if you're showing it.
Or move to the next record. Or close the form. Save will happen.
Cancel: use the Esc button.
Exit: Ctrl+F4, or click the X in the upperleft corner of the form.
You remind me of people who insist of implementing their own MoveNext,
MovePrevious, MoveFirst, MoveLast, and New buttons, and ignore the
fact that the navigation buttons already do that. Access is meant to
be a highly productive development environment, and that works best if
you use the tool the way it was designed to be used.
If you ignore the above and still badly wanted to do this, I doubt it
could be done with macros. A2007 macros are somewhat more powerful,
but VBA still reigns supreme.
-Tom.
>Hi All,
I want to create following command buttons on a Form which users can
edit.
Save ( Save Changes made)
Cancel ( Undo data changes)
Exit ( Close form)
I am using Macros for each of these commands and they work perfect.
Now I want to do following.
Step 1. Form Opens with only 'Exit' button visible
Step 2. On Dirty 'Save' and 'Cancel' are made visible, 'Exit'
disappears
Step 3. If we click 'Save' ; Form Data is saved; 'Save' and 'Cancel'
disappear; 'Exit' is visible
OR
If we click 'Cancel' , Form Data changes are not saved (Undo); 'Save'
and 'Cancel' disappear; 'Exit' is visible
Step 4. Back to Step 1
I do not know VBA scripting so please suggest me how this can be done
using Macros.
Cheers, Matuag