Re: VBA question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you :)

"Andreas" wrote:

> You can use the condition column in your macro to check for the value.
> You will need 2 tests:
> - If the value is "archived", display a message box
> - If the value is not "archived", do what you currently do.
>
> Regards,
> Andreas
>
> Connie wrote:
> > Hi
> > I have created a macro that allows users to copy a number of fields/data
> > using the setvalue action from one form to another(i have a form with a
> > button called Copy data', and its onclick property executes this macro. This
> > works fine.
> >
> > However, i would like to display an error message if the field : Info
> > type=archived that says "will not copy data that is archived" and obviously
> > wont execute the macro that allows a user to copy data . Any other values in
> > the field will allow users to copy data.
> >
> > Thanks in advance
>
>
.

Quantcast