Copy subform

[Infinite]

Hello! I have a subform that has my daily sales per show, and what im trying to do is, click a button, and have it copy the daily sales for that show, so I can easily paste it else were. I know its possible, I just dont even know were to start looking to begin. I looked some, and the problems most of them have is that it doesnt copy just the filtered subform, it copy's all of the subforms data.



Thanks for your help in advance!

 

[Infinite]

Okay, I got that done. Now what?

Its a query that has its Criteria field set the the Show ID that is open in the form that I would copy the data from.

 

[Infinite]

The entire database, or the SQL for the query?

 

[Infinite]

I dont think im going to be able to get that button then...Your code has lots of "this = that" so im all confused on what "this" is when its really "that"


I am going to keep trying sometime tomorrow. My head hurts after looking at that all

Thanks for your current help though! After using your example data base, I at least know its possible.

 

[Infinite]

Okay, I am able to copy and paste the data now, but the problem is the format its in.

Hootin n Hollerin Gainesville 09-2015 Day 1 $86.85

That is what I want, but, I have multiple days, and its only copying the first record.

As you can see in the image, that it still only copys one when I push the button, even though there are 3. Here is the code I use to copy it.

  Call ClipBoard_SetData(Me.Form![SubShowByDay]![EventID] & " " & "Day" & " " & Me.Form![SubShowByDay]![Date] & " " & Format(Me.Form![SubShowByDay]![Total_Sales], "Currency"))

 

[Infinite]

Show Name	Date	Total Per Day Sales
Hootin n Hollerin Gainesville 09-2015	1	$86.85
Hootin n Hollerin Gainesville 09-2015	2	$468.74
Hootin n Hollerin Gainesville 09-2015	3	$892.75

As you see, its usable, buts its not how I wanted it.

 

[Infinite]

Truth be told, I just want a button to do it, that ways it faster, quicker, and much easier for the user. I was thinking of using .column but it doesnt seem to want to accept that...

 

[Infinite]

How can you tell the button the destination if you don't know it in advance?

Not sure what you mean there.

 

[Infinite]

http://www.access-programmers.co.uk/forums/showpost.php?p=1458662&postcount=10

That is what im trying to do. I have 3 records for that show, but when I click the Copy button, it only copy's the FIRST records for that show. What I need, is for it to copy all 3 records.