khanman

Hi all -- this is my first post so bear with me. I am attempting to produce an access report through vb6. After I populate an ADODB recordset, I want to send it to an access report. The textboxes in the report are all unbound.
I get so far as:
set dbApp = New access.Application

strDB = "c:\SomeDir\SomeDB.mdb"

dbApp.OpenCurrentDatabase strDB ... ... ... then I'm lost.

I try to do: dbApp.DoCmd.OpenReport("SomeReport"), but all that happens is the report is opened for preview with no data (didn't get a chance to set the report to the recordset)

My questions are:
1. Do I need to bind the report in Access to a table (the recordset is a multitable query)
2. How do I set the textboxes in the report to the fields in the recordset

I probably have more questions regarding this matter but I hope the answers to these questions will at least give a good platform to figure the rest (let's hope)

Khanman

Robby

Try this... http://www.xtremevbtalk.com/show...Access+Reports

khanman

i'm not certain what exactly to put into the criteria...does the "Field1" represent a textbox on the report or a field in the recordset? The report itself is not binded to any table or query; should I bind it?...I was under the impression that I could use a "template" style report object. Also, the Detail portion is a listing of all dependent records associated with an employee.

Robby, I appriciate your assistance and input. Thanks

khanman

Robby

Field1 would be a Field in the recordset, Textbox1 would be a textbox on the VB form.

The critieria can look something like this...

sCriteria = "Field1 = '" & Textbox1 & "' AND Field2 = " & val(textbox2.text)

Field1 one being text based and Field2 being of numeric data type (notice the single quotes surrounding the text based data)

And you need to bind the report to a table or query, you can do it at run-time or design-time... by either puting the table/query name or a full SQL Select statement....

DoCmd.RecordSource = "Select * From myTable"

khanman

Robby, thank you for the holp, It works like a champ.