SQL question on error 3079

G

Guest

Hi,

I am using the below SQL based on a query that consists of 8 queries all
based on tables. The query has 3 conditions - between date - and 2 numbers
that are in a form on open the report.

Opening the query does not produce the error but in a report the error 3079
happens. The reports is imported from MSAccess 2.0

From the below SQL it is the "F_Timespecifikation.Dato1" that creates the
3079.
However building an expression using "Timespecifikation.Dato1" then will not
allow one to use the conditions needed.

Building a new report using the wizard in MSAccess 2003 solves the issue.

But is there some way to stop the 3079 error on open. On Error Goto 0 or
Resume Next does not stop the error from not opening the report.

Thank you for any suggestion.

Flemming Ast

This is the SQL

SELECT DISTINCTROW F_Timespecifikation.Dato1, F_Timespecifikation.Sagsnr,
F_Timespecifikation.Løbenummer, F_Timespecifikation.Advokat,
F_Timespecifikation.[Antal Timer], F_Timespecifikation.Afregnet,
F_Timespecifikation.Funktion, [F_Timer Form].Modtaget, [F_Timer
Form].Afsluttet, F_Timespecifikation.Kategori, [F_Timer Form].Klient,
[QFP_Print Timeregnskab JEK].[SumOfAntal Timer] AS JEK, [QFP_Print
Timeregnskab F].[SumOfAntal Timer] AS F, [QFP_Print Timeregnskab
LKJ].[SumOfAntal Timer] AS LKJ, [QFP_Print Timeregnskab H].[SumOfAntal Timer]
AS H, [QFP_Print Timeregnskab L].[SumOfAntal Timer] AS L, [F_Sagsnummer
Subtabel].Modpart1, [F_Sagsnummer Subtabel].Vedrørende
FROM (((((([F_Sagsnummer Subtabel] INNER JOIN [F_Timer Form] ON
([F_Sagsnummer Subtabel].Løbenummer = [F_Timer Form].Løbenummer) AND
([F_Sagsnummer Subtabel].Sagsnr = [F_Timer Form].Sagsnr)) INNER JOIN
F_Timespecifikation ON ([F_Timer Form].Løbenummer =
F_Timespecifikation.Løbenummer) AND ([F_Timer Form].Sagsnr =
F_Timespecifikation.Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab F] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab F].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab F].Sagsnr)) LEFT JOIN
[QFP_Print Timeregnskab JEK] ON (F_Timespecifikation.Løbenummer = [QFP_Print
Timeregnskab JEK].Løbenummer) AND (F_Timespecifikation.Sagsnr = [QFP_Print
Timeregnskab JEK].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab LKJ] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab LKJ].Løbenummer)
AND (F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab LKJ].Sagsnr)) LEFT
JOIN [QFP_Print Timeregnskab H] ON (F_Timespecifikation.Løbenummer =
[QFP_Print Timeregnskab H].Løbenummer) AND (F_Timespecifikation.Sagsnr =
[QFP_Print Timeregnskab H].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab L] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab L].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab L].Sagsnr)
WHERE (((F_Timespecifikation.Dato1) Between [Forms]![Timeprint]![Fra] And
[Forms]![Timeprint]![Til]) AND
((F_Timespecifikation.Sagsnr)=[Forms]![Timeprint]![Sagsnr]) AND
((F_Timespecifikation.Løbenummer)=[Forms]![Timeprint]![Løbenummer]));
 
G

Guest

You may want to make again the conditions that call other forms ( such as:
[Forms]![Timeprint]![Fra] And [Forms]![Timeprint]![Til]) ) with the new
access.
That had happend to me several times.

Flemming said:
Hi,

I am using the below SQL based on a query that consists of 8 queries all
based on tables. The query has 3 conditions - between date - and 2 numbers
that are in a form on open the report.

Opening the query does not produce the error but in a report the error 3079
happens. The reports is imported from MSAccess 2.0

From the below SQL it is the "F_Timespecifikation.Dato1" that creates the
3079.
However building an expression using "Timespecifikation.Dato1" then will not
allow one to use the conditions needed.

Building a new report using the wizard in MSAccess 2003 solves the issue.

But is there some way to stop the 3079 error on open. On Error Goto 0 or
Resume Next does not stop the error from not opening the report.

Thank you for any suggestion.

Flemming Ast

This is the SQL

SELECT DISTINCTROW F_Timespecifikation.Dato1, F_Timespecifikation.Sagsnr,
F_Timespecifikation.Løbenummer, F_Timespecifikation.Advokat,
F_Timespecifikation.[Antal Timer], F_Timespecifikation.Afregnet,
F_Timespecifikation.Funktion, [F_Timer Form].Modtaget, [F_Timer
Form].Afsluttet, F_Timespecifikation.Kategori, [F_Timer Form].Klient,
[QFP_Print Timeregnskab JEK].[SumOfAntal Timer] AS JEK, [QFP_Print
Timeregnskab F].[SumOfAntal Timer] AS F, [QFP_Print Timeregnskab
LKJ].[SumOfAntal Timer] AS LKJ, [QFP_Print Timeregnskab H].[SumOfAntal Timer]
AS H, [QFP_Print Timeregnskab L].[SumOfAntal Timer] AS L, [F_Sagsnummer
Subtabel].Modpart1, [F_Sagsnummer Subtabel].Vedrørende
FROM (((((([F_Sagsnummer Subtabel] INNER JOIN [F_Timer Form] ON
([F_Sagsnummer Subtabel].Løbenummer = [F_Timer Form].Løbenummer) AND
([F_Sagsnummer Subtabel].Sagsnr = [F_Timer Form].Sagsnr)) INNER JOIN
F_Timespecifikation ON ([F_Timer Form].Løbenummer =
F_Timespecifikation.Løbenummer) AND ([F_Timer Form].Sagsnr =
F_Timespecifikation.Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab F] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab F].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab F].Sagsnr)) LEFT JOIN
[QFP_Print Timeregnskab JEK] ON (F_Timespecifikation.Løbenummer = [QFP_Print
Timeregnskab JEK].Løbenummer) AND (F_Timespecifikation.Sagsnr = [QFP_Print
Timeregnskab JEK].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab LKJ] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab LKJ].Løbenummer)
AND (F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab LKJ].Sagsnr)) LEFT
JOIN [QFP_Print Timeregnskab H] ON (F_Timespecifikation.Løbenummer =
[QFP_Print Timeregnskab H].Løbenummer) AND (F_Timespecifikation.Sagsnr =
[QFP_Print Timeregnskab H].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab L] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab L].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab L].Sagsnr)
WHERE (((F_Timespecifikation.Dato1) Between [Forms]![Timeprint]![Fra] And
[Forms]![Timeprint]![Til]) AND
((F_Timespecifikation.Sagsnr)=[Forms]![Timeprint]![Sagsnr]) AND
((F_Timespecifikation.Løbenummer)=[Forms]![Timeprint]![Løbenummer]));
Click to expand...
 
G

Guest

Thank you for your answer.

The solution was not to use DoCmd. ApplyFilter OnOpen in the report.
The logic must be that the Report already has the recordset linked to
the Report and is "confused" when applying the same recordset again.

However above worked well in MSAccess version 2.0.

"Lina Manjarres" skrev:
You may want to make again the conditions that call other forms ( such as:
[Forms]![Timeprint]![Fra] And [Forms]![Timeprint]![Til]) ) with the new
access.
That had happend to me several times.

Flemming said:
Hi,

I am using the below SQL based on a query that consists of 8 queries all
based on tables. The query has 3 conditions - between date - and 2 numbers
that are in a form on open the report.

Opening the query does not produce the error but in a report the error 3079
happens. The reports is imported from MSAccess 2.0

From the below SQL it is the "F_Timespecifikation.Dato1" that creates the
3079.
However building an expression using "Timespecifikation.Dato1" then will not
allow one to use the conditions needed.

Building a new report using the wizard in MSAccess 2003 solves the issue.

But is there some way to stop the 3079 error on open. On Error Goto 0 or
Resume Next does not stop the error from not opening the report.

Thank you for any suggestion.

Flemming Ast

This is the SQL

SELECT DISTINCTROW F_Timespecifikation.Dato1, F_Timespecifikation.Sagsnr,
F_Timespecifikation.Løbenummer, F_Timespecifikation.Advokat,
F_Timespecifikation.[Antal Timer], F_Timespecifikation.Afregnet,
F_Timespecifikation.Funktion, [F_Timer Form].Modtaget, [F_Timer
Form].Afsluttet, F_Timespecifikation.Kategori, [F_Timer Form].Klient,
[QFP_Print Timeregnskab JEK].[SumOfAntal Timer] AS JEK, [QFP_Print
Timeregnskab F].[SumOfAntal Timer] AS F, [QFP_Print Timeregnskab
LKJ].[SumOfAntal Timer] AS LKJ, [QFP_Print Timeregnskab H].[SumOfAntal Timer]
AS H, [QFP_Print Timeregnskab L].[SumOfAntal Timer] AS L, [F_Sagsnummer
Subtabel].Modpart1, [F_Sagsnummer Subtabel].Vedrørende
FROM (((((([F_Sagsnummer Subtabel] INNER JOIN [F_Timer Form] ON
([F_Sagsnummer Subtabel].Løbenummer = [F_Timer Form].Løbenummer) AND
([F_Sagsnummer Subtabel].Sagsnr = [F_Timer Form].Sagsnr)) INNER JOIN
F_Timespecifikation ON ([F_Timer Form].Løbenummer =
F_Timespecifikation.Løbenummer) AND ([F_Timer Form].Sagsnr =
F_Timespecifikation.Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab F] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab F].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab F].Sagsnr)) LEFT JOIN
[QFP_Print Timeregnskab JEK] ON (F_Timespecifikation.Løbenummer = [QFP_Print
Timeregnskab JEK].Løbenummer) AND (F_Timespecifikation.Sagsnr = [QFP_Print
Timeregnskab JEK].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab LKJ] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab LKJ].Løbenummer)
AND (F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab LKJ].Sagsnr)) LEFT
JOIN [QFP_Print Timeregnskab H] ON (F_Timespecifikation.Løbenummer =
[QFP_Print Timeregnskab H].Løbenummer) AND (F_Timespecifikation.Sagsnr =
[QFP_Print Timeregnskab H].Sagsnr)) LEFT JOIN [QFP_Print Timeregnskab L] ON
(F_Timespecifikation.Løbenummer = [QFP_Print Timeregnskab L].Løbenummer) AND
(F_Timespecifikation.Sagsnr = [QFP_Print Timeregnskab L].Sagsnr)
WHERE (((F_Timespecifikation.Dato1) Between [Forms]![Timeprint]![Fra] And
[Forms]![Timeprint]![Til]) AND
((F_Timespecifikation.Sagsnr)=[Forms]![Timeprint]![Sagsnr]) AND
((F_Timespecifikation.Løbenummer)=[Forms]![Timeprint]![Løbenummer]));
Click to expand...
Click to expand...
 
Top