Copy Data Macro

[KarenK]

Can someone tell me how to write a macro so that I can copy a field and paste
it elswhere in a form when I push a command button. I am not a programmer, so
please be patient

Thank you

Karen

 

[Steve Schapel]

Karen,

It seems like an unusual thing to want to do. Maybe you could explain a
bit about your purpose.

Whatever, you can use a SetValue action in your macro to do this,
something like this:

Action: SetValue
Item: [NameOfYourElsewhereControl]
Expression" [NameOfControlCopyingFrom]

 

[Chris]

Steve,

I would like to know how I can automate data from access and export it into
excel, Formatted and editted already, using either a VBA or a macro. I ran a
query and would like to have that information automated into excel.

Karen,

It seems like an unusual thing to want to do. Maybe you could explain a
bit about your purpose.

Whatever, you can use a SetValue action in your macro to do this,
something like this:

Action: SetValue
Item: [NameOfYourElsewhereControl]
Expression" [NameOfControlCopyingFrom]

--
Steve Schapel, Microsoft Access MVP

Can someone tell me how to write a macro so that I can copy a field and paste
it elswhere in a form when I push a command button. I am not a programmer, so
please be patient

Thank you

Karen

 

[Steve Schapel]

Chris,

Please have a look at the OutputTo macro action, check the Help, and
then get back to us if you need more explicit advice.