473,320 Members | 1,868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to open Recordset and send the ouput to a report?

open a recordset using ado or dao and send the result to a report.

I tried using .name property but it doesnt accpet more than 80 characters

Expand|Select|Wrap|Line Numbers
  1. Report_open_event
  2. me.recordsource = rs5.name
  3. end
this doesnt work with my big query having lots of join
Nov 22 '10 #1
1 1381
NeoPa
32,556 Expert Mod 16PB
If you check out the Help for a report's RecordSource property, you'll find it doesn't support working with recordsets. A recordset is an object in your VBA code, whereas the report needs either the name of a recordset object (EG. a saved TableDef or QueryDef object from an Access database) or the SQL in a string.
Nov 22 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: kgs | last post by:
Problem exists on ms-access, ms-sqlserver using ADO (not in ODBC), visual Basic, C#, and VB.NET. Somethimes when I open second recordset in this same connection that first, it has EOF, but I know,...
2
by: pilar | last post by:
Hi All, I'm using a code somebody posted here. I extract the records from a query which gave me just the entries for the current date, there will be maximum 5-6 entries per days and I need to send...
4
by: Dalan | last post by:
I presume that using an open recordset method is the preferred method of accomplishing what I'm trying to do. Of course, if there are other options that would work, feel free to share them. I...
3
by: Andrew | last post by:
I've developed an interoffice system that has 2 generic interfaces; user and supervisor. What I'd like to happen is to have the user interface open directly to an input form (easily done) and have...
0
by: Kevin R | last post by:
Question: I have a situation where I would like to prepare a Recordset object within Visual Basic (6.0), and then use the MS Access COM API's to Show a report built off of the data in my...
1
by: PerryC | last post by:
I am able to create a script that will send a report as email attached rtf file. However, is there a way to make this attached file password protected? i.e. the recipient needs a password to open...
2
by: Kosmos | last post by:
I am opening the following connections as such although I am only referring to the first connection for this question: Dim con1 As ADODB.Connection Dim con2 As ADODB.Connection Dim recSet1 As...
0
by: =?Utf-8?B?UHVjY2E=?= | last post by:
Hi, My C# application trys to access directorycontext during Form loading. Try and Catch if there is an exception. I then output an error message and then "this.Close();" to exit the...
0
by: depash | last post by:
hi, I have a data report have created through vb6, I would like to biind it to a recoprdset at runtime so as to display user specific records from the database as opposed to displaying all the...
8
by: clloyd | last post by:
I have a report that loops through multiple records to combine one field with multiple results into one record. The code is as follows: Private Sub Report_Open(Cancel As Integer) Dim...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.