Copy values in specific format to paste

[Brennan]

Can someone direct me to information on the VBA needed to copy values on a
form in a particular format so that I can paste them later? I appreciate any
help. Thanks

Brennan

 

[Marshall Barton]

Can someone direct me to information on the VBA needed to copy values on a
form in a particular format so that I can paste them later? I appreciate any
help.

Copy/Paste doesn't always deal with form data the way you
might want. Instead you should use code to save/set the
values.

If you'll explain **what** you are trying to accomplish
(instead of how you thought you could do it), maybe we can
suggest a way to reasonable way to do it.

 

[Brennan]

Of Course. I have a form that dynamically displays information. Some of my
users would like to be able to copy or export that data in a particular
format into Excel. I built a report with the same data, but the regular
export functionality in access isn't that great. Often, my users will have
to rework a sheet that comes from a report export to excel. I would like to
built a button that grabs certain data elements from the form and then
exports them into excel in a specific format. If I could accomplish this by
copying those data elements in a specific format, that would work as well.

Marshall, I appreciate your time and help. Thanks.

Brennan

 

[Marshall Barton]

Of Course. I have a form that dynamically displays information. Some of my
users would like to be able to copy or export that data in a particular
format into Excel. I built a report with the same data, but the regular
export functionality in access isn't that great. Often, my users will have
to rework a sheet that comes from a report export to excel. I would like to
built a button that grabs certain data elements from the form and then
exports them into excel in a specific format. If I could accomplish this by
copying those data elements in a specific format, that would work as well.

"in a particular format into Excel" can range from trivial
to extremely complex.

The easiest is to use TansferSpreadsheet on a query (the
form's record source? filtered?)

OTOH, if you want specific fields to be placed in cells that
are scattered all over a sheet, then you should use
Automation to set each cell.

 

[Brennan]

Thanks Marshall,

Could you provide an example of the automation that you describe below? I
have several queries that dump into this form so a spreadsheet transfer
wouldn't work. Thanks again for your help - it is very much appreciated.

Brennan

 

[Marshall Barton]

Could you provide an example of the automation that you describe below? I
have several queries that dump into this form so a spreadsheet transfer
wouldn't work.

That's a fairly big subject and I can't find an appropriate
example for a reply.

I suggest that you do some research with your specific
problem in mind. Try starting with the KB article:
http://support.microsoft.com/default.aspx?kbid=260410