Copy values in specific format to paste

  • Thread starter Thread starter Brennan
  • Start date Start date
B

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
 
Brennan said:
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.
Click to expand...

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.
 
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
 
Brennan said:
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.
Click to expand...


"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.
 
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
 
Back
Top