Copy Data Macro

  • Thread starter Thread starter KarenK
  • Start date Start date
K

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
 
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,

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.

Steve Schapel said:
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
Click to expand...
Click to expand...
 
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.
 
Back
Top