August 29, 2008 07:26pm pdt

1. capricorn1 2,357,876
2. DatabaseMX 1,578,962
3. LSMCons... 738,913
4. boag2000 655,583
5. peter57r 538,288
6. GRayL 451,989
7. harfang 437,453
8. jimhorn 322,342
9. cactus_d... 299,026
10. matthews... 256,874
11. TextReport 236,057
12. hnasr 232,150
13. ee_rlee 173,155
14. angelIII 163,304
15. puppydog... 149,767
16. jimpen 149,684
17. mbizup 147,354
18. jefftwilley 140,435
19. LPurvis 139,254
20. JezWalters 138,435
21. omgang 130,049
22. Rick_Ric... 126,252
23. koutny 122,251
24. tbsgadi 120,968
25. MikeToole 118,626

1. capricorn1 10,014,914
2. nico5038 5,704,781
3. rockiroads 5,409,687
4. peter57r 3,982,783
5. LSMCons... 3,475,503
6. DatabaseMX 3,462,423
7. LPurvis 3,398,221
8. shanesue... 3,288,317
9. harfang 3,054,286
10. stevbe 2,857,111
11. jimhorn 2,741,934
12. GRayL 2,611,833
13. flavo 2,111,583
14. mbizup 2,033,944
15. jadedata 1,964,977
16. jefftwilley 1,799,875
17. thenelson 1,697,869
18. matthews... 1,594,087
19. eghtebas 1,487,093
20. boag2000 1,338,327
21. puppydog... 1,329,230
22. Arthur_... 1,285,298
23. cactus_d... 1,271,815
24. jjafferr 1,265,357
25. dannywar... 1,260,596

04.02.2008 at 08:28AM PDT, ID: 23289651

	[x] Attachment Details

RecordSet to Table - Access

Asked by yankeej14 in Microsoft Access Database

Tags: recordset, table

I need some help dumping a recordset into a temporary table to be displayed in Access. Is this possible?

VBA code is used to perform a stored parameter query. The code is attached below.Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

           
           
             Private Sub Calendar0_DblClick()
 
'''Declare Variables
Dim qdf As DAO.QueryDef
Dim rst As Recordset
 
'''Get stored parameter query
Set qdf = CurrentDb.QueryDefs("WinnersQuery")
 
'''Fill in the parameters with the correct value
qdf.Parameters(0) = Calendar0.Value
 
'''Perform the query
Set rst = qdf.OpenRecordset
 
 
'''Send recordset data to temp table (***Need help here!***)
 
 
rst.Close
qdf.Close
Set rst = Nothing
Set qdf = Nothing
 
End Sub

           
         

	Title
1	VBA Code to copy to new record from…
2	Access VBA DAO recordset for use a…
3	RecordSet to Table?
4	Recordset to HTML
5	Using a report to print a recordset.
6	How to changes recordsets in access …

RecordSet to Table - Access

Asked by yankeej14 in Microsoft Access Database

Tags: recordset, table

About this solution