Browse by Tags

How to fill a Word Table from a MS Access Recordset

Hi Experts, I am trying to fill a Word table from MS Access by using a Recordset. This is an automation that uses MS Access to record data and Word to display reports according to a specific format or template. The Word table has three columns and as many lines as records... This is part of my code Set...

Posted to Access (Forum) by microsoft on 08-26-2009
MS Access VBA - closing recordset after executing make table query from recordset.Open method

Hi, Quick question here. I am executing some make table queries by opening a recordset as shown below.... is there any need to close the recordsets when done..... I get an error when the recordsets try to close. It appears they are already close. Any feedback is appreciated. Thx. Run time error 3704...

Posted to Access Coding/Macros (Forum) by microsoft on 07-13-2009
RecordSet to Table?

Is there a simple way to output or write a RecordSet to a Table?

Posted to Access (Forum) by microsoft on 06-17-2009
Problem: Replicate the structure of a DAO recordset in a table

I have a task to write a function which will replicate the structure of a DAO recordset (under VBA in MS Access 2003) in a table and then write the contents of that recordset into the created table. The problem is that the structure of the recordset is not known in advance and must be aquired during...

Posted to Access Coding/Macros (Forum) by microsoft on 06-09-2009
Problem: Create Table or Query from Open Recordset?

I have a continuous form that the user can sort and filter to the nth degree. They need to print a report that is based on the forms underlying recordset after they have filtered and sorted it the way they want it to look. Is there an easy way to create a table or query from the form's recordset...

Posted to Access (Forum) by microsoft on 06-08-2009
Problem: RecordSet to Table - Access

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. Code Snippet: 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...

Posted to Access (Forum) by microsoft on 06-01-2009

Page 1 of 1 (6 items)

Browse by Tags

How to fill a Word Table from a MS Access Recordset

MS Access VBA - closing recordset after executing make table query from recordset.Open method

RecordSet to Table?

Problem: Replicate the structure of a DAO recordset in a table

Problem: Create Table or Query from Open Recordset?

Problem: RecordSet to Table - Access