Macros to copy and paste between fields & reset values

[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?

 

[Steve Schapel]

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.

 

[Nigel M]

The best way to do this is with an Update Query.

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!

 

[Steve Schapel]

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.

 

[Nigel M]

it is much preferable to cross-post (i.e. to address the
post to both groups simultaneously), rather than multi-post

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.