Macros to copy and paste between fields & reset values

  • Thread starter Thread starter Nigel M
  • Start date Start date
N

Nigel M

Although I can get by with SQL, I'm new to Access Macros. I want to
incorporate two macros onto a form, as follows:

[1] A macro to cut the first 11 characters from a given field in the
current record, and paste the first 10 of these into another field.

[2] A macro to reset all the Yes/No values in a table to No, and (if
possible) add the current date for each change from Yes to No into
another field.

FYI, these are both related to eBay: [1] is to move the item number into
the correct field, [2] is to reset the "Print this label on merge" flag.

Is it possible to do this, or should I keep doing it manually?
 
Nigel,

The best way to do this is with an Update Query. If you want to
automate it with a macro, set up the Update Query as required, and then
use an OpenQuery action in your macro to run the update.
 
The best way to do this is with an Update Query.
Click to expand...

Thanks you, I've been told the same in another group. I looked up
"Update Query" in Help - I can't even find the button it mentions.

I think I'm a no-hoper!
 
Nigel,

Regarding "I've been told the same in another group", just a hint for
the future... if you feel it is important for your post to go to more
than one group, it is much preferable to cross-post (i.e. to address the
post to both groups simultaneously), rather than multi-post (i.e. send
the same message separately to more than one group). Thanks.

I am not sure what button you are referring to. The way I make an
Update Query is via the Query menu of the query design window.
 
it is much preferable to cross-post (i.e. to address the
post to both groups simultaneously), rather than multi-post
Click to expand...

Yes, sorry, I should have explained. I didn't get a reply in the other
group, so I posted here, then I got a reply to the OP!

I'll try your suggestion, thanks.
 
Back
Top