Udskrive rapport fra Access med parametre fra VB

I assume that you are automating Access to print your report?
There are a couple of solutions.
1: You could just get Access to prompt for the paramaters.
2: Alter the query's SQL before printing the report.

It is possible to give a query paramaters from your VB program, but then, as far as I know, its only possible to open a recordset based on the query result. This wouldnt be available to your report.

Another idea would to have a table which contains values which can be used as criteria to the query. Then just before printing the report you update the values in the table.

a bit of feedback makes it easier for us to help!

>>terry
Jeg har selv tænkt på, at lade Access hente værdierne i en tabel.
Jeg har prøvet at lade Access prompte for parametrene, men jeg er ked af, at man ikke kan nøjes med at se den dialogboks, der fremkommer, i stedet for hele Access.

/Søren

2: Alter the query's SQL before printing the report.

This example is how it is done directly in Access, its similar in VB and if you are automating Access then I think you will have an idea as how it needs to be modified

EXAMPLE:
Dim sSQL As String

    'Build the SQL in code. (You need a query named (in this example) qPRapport Data)
    sSQL = "SELECT [qPRapport Dato].Dato, .......[qPRapport 1a].Tilløbx AS [Tind 2003], ...."

    'Now modify the queries SQL (query MUST exist already)
    CurrentDb.QueryDefs("qPRapport Data").SQL = sSQL

>>terry
Nu har jeg oprettet en tabel med 2 felter, en startdato og en slutdato.
I min forespørgsel har jeg skrevet:

Between [tblStatDatoer]![Startdato] And [tblStatDatoer]![Slutdato]

men det virker ikke.
Hvad skal jeg gøre ?
/Søren

You can do this in a couple of ways. Either use sub selects

... Between (SELECT Startdato FROM tblStatDatoer) And (SELECT SlutDato FROM tblStatDatoer)

OR create a recordset selecting the fields from the table, and then you canuse these values in the next SQL

Det var SELECT, der gjorde forskellen. Tak for hjælpen
/Søren

selv tak