VBA question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you :)

Andreas said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

when to update and when to leave alone 5
Copy record in one form into a new pop-up form 0
Access 2003-Date() = 12/30/1899 not 06/15/2009 why? 3
Import files into access 1
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
vba macro that allows insertion of symbols at cursor 0
allow additions confuses user 2
How can we convert OST to PDF file format? 1

Back
Top