Crash of MSACESS 2003

  • Thread starter Thread starter Damien Dutreil
  • Start date Start date
D

Damien Dutreil

MS Access 2003 is always crashing on the follwing request:

INSERT INTO TRI ( CIV, NOM, PRENOM, ADR1, ADR2, ADR3, CP, VILLE, PAYS,
ACA, SYND, TYP_ENS, DADH, NB, CODECAT, CODEDISC )
SELECT DISTINCTROW INDIVIDU.CIV, INDIVIDU.NOM, INDIVIDU.PRENOM,
INDIVIDU.ADR1, INDIVIDU.ADR2, INDIVIDU.ADR3, INDIVIDU.CP,
INDIVIDU.VILLE, INDIVIDU.PAYS, ETBRNE.ACA, INDIVIDU.SYND,
INDIVIDU.TYP_ENS, INDIVIDU.DADH, INDIVIDU.NB, INDIVIDU.CODECAT,
INDIVIDU.CODEDISC
FROM INDIVIDU INNER JOIN ETBRNE ON INDIVIDU.NUMETAB = ETBRNE.NUMETAB
WHERE (((INDIVIDU.CIV) Like ([FORMS]![TRI]![CIV] & "*")) AND
((INDIVIDU.CP) Like ([FORMS]![TRI]![CP] & "*")) AND ((ETBRNE.ACA) Like
([FORMS]![TRI]![ACAD] & "*") And (ETBRNE.ACA) Not Like
([FORMS]![TRI]![EXCLACA] & "*")) AND ((INDIVIDU.SYND) Like
([FORMS]![TRI]![S1] & "*")) AND ((INDIVIDU.TYP_ENS) Like
([FORMS]![TRI]![TYPENS] & "*")) AND
(((INDIVIDU.DADH)=[FORMS]![TRI]![AN1] Or
(INDIVIDU.DADH)=[FORMS]![TRI]![AN2)]) And ( (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN1] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN2] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN3] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN4] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN5] & "*"))) AND ((INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT1] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT2] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT3] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT4] & "*")) AND ((INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC1] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC2] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC3] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC4] & "*")) AND ((INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC1] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC2] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC3] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![FIDEL] & "*")));


It seems that it is not OK with AN1 and AN2.
How to solve the issue ?
thanks for your answers
 
Damien said:
MS Access 2003 is always crashing on the follwing request:
Click to expand...

Sorry but here is the error message:
FORMS!TRI!AN2)], 8 [Unknown] = [FORMS!TRI!AN2], 9 [Unknown] =
[FORMS!TRI!AN3], 10 [Unknown] = [FORMS!TRI!AN4], 11 [Unknown] =
[FORMS!TRI!AN5], 12 [Unknown] = [FORMS!TRI!CAT1], 13 [Unknown] =
[FORMS!TRI![CAT2], 14 [Unknown] = [FOR
 
Damien Dutreil said:
MS Access 2003 is always crashing on the follwing request:

INSERT INTO TRI ( CIV, NOM, PRENOM, ADR1, ADR2, ADR3, CP, VILLE, PAYS,
ACA, SYND, TYP_ENS, DADH, NB, CODECAT, CODEDISC )
SELECT DISTINCTROW INDIVIDU.CIV, INDIVIDU.NOM, INDIVIDU.PRENOM,
INDIVIDU.ADR1, INDIVIDU.ADR2, INDIVIDU.ADR3, INDIVIDU.CP,
INDIVIDU.VILLE, INDIVIDU.PAYS, ETBRNE.ACA, INDIVIDU.SYND,
INDIVIDU.TYP_ENS, INDIVIDU.DADH, INDIVIDU.NB, INDIVIDU.CODECAT,
INDIVIDU.CODEDISC
FROM INDIVIDU INNER JOIN ETBRNE ON INDIVIDU.NUMETAB = ETBRNE.NUMETAB
WHERE (((INDIVIDU.CIV) Like ([FORMS]![TRI]![CIV] & "*")) AND
((INDIVIDU.CP) Like ([FORMS]![TRI]![CP] & "*")) AND ((ETBRNE.ACA) Like
([FORMS]![TRI]![ACAD] & "*") And (ETBRNE.ACA) Not Like
([FORMS]![TRI]![EXCLACA] & "*")) AND ((INDIVIDU.SYND) Like
([FORMS]![TRI]![S1] & "*")) AND ((INDIVIDU.TYP_ENS) Like
([FORMS]![TRI]![TYPENS] & "*")) AND
(((INDIVIDU.DADH)=[FORMS]![TRI]![AN1] Or
(INDIVIDU.DADH)=[FORMS]![TRI]![AN2)]) And ( (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN1] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN2] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN3] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN4] & "*") And (INDIVIDU.DADH) Like
([FORMS]![TRI]![AN5] & "*"))) AND ((INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT1] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT2] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT3] & "*") Or (INDIVIDU.CODECAT) Like
([FORMS]![TRI]![CAT4] & "*")) AND ((INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC1] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC2] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC3] & "*") Or (INDIVIDU.CODEDISC) Like
([FORMS]![TRI]![DISC4] & "*")) AND ((INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC1] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC2] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![DISC3] & "*") Or (INDIVIDU.FIDEL) Like
([FORMS]![TRI]![FIDEL] & "*")));


It seems that it is not OK with AN1 and AN2.
How to solve the issue ?
thanks for your answers
Click to expand...

What exactly does it say????
 
Brian wrote:

What exactly does it say????
Click to expand...

FORMS!TRI!AN2)], 8 [Unknown] = [FORMS!TRI!AN2], 9 [Unknown] =
[FORMS!TRI!AN3], 10 [Unknown] = [FORMS!TRI!AN4], 11 [Unknown] =
[FORMS!TRI!AN5], 12 [Unknown] = [FORMS!TRI!CAT1], 13 [Unknown] =
[FORMS!TRI![CAT2], 14 [Unknown] = [FOR

and send a report to Microsoft with all the values.
 
Back
Top