D
D
Hello,
Firstly let me say I am not any kind of programmer and only have the
faintest understanding of programming However I am working my way
through creating an Access Database for use by a few users on a LAN. I
have reached a point where I thought I needed a macro to open a window
when a user changed data, asking them Yes to confirm it was correct or
a No for them to not save the changes if they had done it
inadvertently.
I found some VBA for doing this and was all set to put it in a Macro
but then I find that in Access 2000 writing Macros has been altered
into a kind of tabular arrangement where you pick various commands or
expressions and string them together in a table format to produce a
Macro, all be it in a different looking way to the indented code
subroutine way I was expecting. This made me think you could not use
code to do what I wanted and that I will have to learn the different
commands to use this tabular method. Then I read somewhere that you
can put code directly into the "beforeupdate" property for the Form. I
tried this but got a message saying I need to save the Macro first.
Now I am really confused because I cannot work out how to save this
code as a Macro in Access 2000 because when you got to design a Macro
this Tabular box thingy opens and invites you to use the individual
commands not a chunk of code. I am sure I must be being really thick
to you guys and will look back on this in fun when I get there, but
right now this bit seems as clear as mud.. Your help as always will be
most welcome, Regards,
David.
Firstly let me say I am not any kind of programmer and only have the
faintest understanding of programming However I am working my way
through creating an Access Database for use by a few users on a LAN. I
have reached a point where I thought I needed a macro to open a window
when a user changed data, asking them Yes to confirm it was correct or
a No for them to not save the changes if they had done it
inadvertently.
I found some VBA for doing this and was all set to put it in a Macro
but then I find that in Access 2000 writing Macros has been altered
into a kind of tabular arrangement where you pick various commands or
expressions and string them together in a table format to produce a
Macro, all be it in a different looking way to the indented code
subroutine way I was expecting. This made me think you could not use
code to do what I wanted and that I will have to learn the different
commands to use this tabular method. Then I read somewhere that you
can put code directly into the "beforeupdate" property for the Form. I
tried this but got a message saying I need to save the Macro first.
Now I am really confused because I cannot work out how to save this
code as a Macro in Access 2000 because when you got to design a Macro
this Tabular box thingy opens and invites you to use the individual
commands not a chunk of code. I am sure I must be being really thick
to you guys and will look back on this in fun when I get there, but
right now this bit seems as clear as mud.. Your help as always will be
most welcome, Regards,
David.