Min query virker tilsyneladne ikke?

Hvis du f.eks. bruger et kriterie som Forms!DinFormular!DitFelt, så kan der komme denne fejl afhængigt af hvlken eksport-funktion du bruger.

benytter du
docmd.Transferspreadsheet
eller
docmd.outputto?

DoCmd.OutputTo acOutputQuery, "qryNCN", acFormatXLS, "C:\NCN Report.xls"

WHERE ((([Non Conformity Report1].[NCR])=[Forms]![Non Conformity Report1]!NCR));

Det er [Forms]![Non Conformity Report1]!NCR)) jeg bliver spurgt om!

SELECT [Non Conformity Report1].[Non conformity with an ISM Procedure], [Non Conformity Report1].Complaint, [Non Conformity Report1].[Identified risk], [Non Conformity Report1].[Incident/near incident], [Non Conformity Report1].Accident, [Non Conformity Report1].[Serious damage], [Non Conformity Report1].[Occupational disease], [Non Conformity Report1].[near Miss], [Non Conformity Report1].other, [Non Conformity Report1].NCR1, [Non Conformity Report1].Date, [Non Conformity Report1].[Devision/Ship], [Non Conformity Report1].[Position of ship], [Non Conformity Report1].Procedure, [Non Conformity Report1].[Position/Rank], [Non Conformity Report1].[Detailed description], [Non Conformity Report1].Cause, [Non Conformity Report1].[Action proposed/taken], [Non Conformity Report1].[If already taken], [Non Conformity Report1].[If further], [Non Conformity Report1].[is further action], [Non Conformity Report1].[defective equipment], [Non Conformity Report1].[incomplete precautions], [Non Conformity Report1].[Ignorance of risk], [Non Conformity Report1].[incorrect use of tools etc], [Non Conformity Report1].[Delibrerate noncompliance with instruction], [Non Conformity Report1].[inadequate training], [Non Conformity Report1].[inadequate supervision], [Non Conformity Report1].[poor planning], [Non Conformity Report1].[poor instruction], [Non Conformity Report1].[poor design], [Non Conformity Report1].[communication problem], [Non Conformity Report1].[Organizational problem], [Non Conformity Report1].[documentation problem], [Non Conformity Report1].[standard related problem], [Non Conformity Report1].[procedure problem], [Non Conformity Report1].surname, [Non Conformity Report1].[date of birth], [Non Conformity Report1].injury, [Non Conformity Report1].[date of accident], [Non Conformity Report1].[time of accident], [Non Conformity Report1].sex, [Non Conformity Report1].nationality, [Non Conformity Report1].[position onboard], [Non Conformity Report1].[resulting absence], [Non Conformity Report1].[additional pages], [Non Conformity Report1].[if taken y], [Non Conformity Report1].[is further y], [Non Conformity Report1].[if taken n], [Non Conformity Report1].[is further n], [Non Conformity Report1].[Hospital required Yes], [Non Conformity Report1].[Hospital required No], [Non Conformity Report1].[Date Master], [Non Conformity Report1].Master, [Non Conformity Report1].[Falality FAT], [Non Conformity Report1].[Lost Work Day LWC], [Non Conformity Report1].[Resricted Work Case RWC], [Non Conformity Report1].[Medical Threatment MTC], [Non Conformity Report1].[Permanent Total Disability PTD], [Non Conformity Report1].[Pernament Partial Disability PPD], [Non Conformity Report1].[Quality Annotation], [Non Conformity Report1].days, [Non Conformity Report1].[Corrective Actions], [Non Conformity Report1].ekstra1, [Non Conformity Report1].ekstra2, [Non Conformity Report1].ekstra3, [Non Conformity Report1].ekstra4, [Non Conformity Report1].ekstra5, [Non Conformity Report1].security, [Non Conformity Report1].Verified, [Non Conformity Report1].VerifiedData, [Non Conformity Report1].HerningRecieved, [Non Conformity Report1].ISMCoordinator, [Non Conformity Report1].HerningDate, [Non Conformity Report1].NCR
FROM [Non Conformity Report1]
WHERE ((([Non Conformity Report1].NCR)=[Formularer]![Non Conformity Report]![NCR number]));


det er vist her

WHERE ((([Non Conformity Report1].NCR)=[Formularer]![Non Conformity Report]![NCR number]));

ja, jeg kan godt huske at jeg selv har haft problemer med dette.

Jeg kan ikke huske om Docmd.TransferSpreadsheet har samme problemer. Men du kan jo prøve den. Den fungere på næsten samme måde.

'kabbak' har ikke noget felt der hedder [NCR number] det hedder kun [NCR]

Ja men i din formular har feltet navnet NCR number, men det er ncr det indeholder

feltet øverst til højre

'kabbak' jeg har to felter [NCR](automumber) og [NCR1] (text) Det er [NCR] den bliver ved med at spørge om.

Schoesler->ja, det er fordi at det er NCR, som du spørger efter i forespørgslen, men det er [NCR number] som feltet hedder på formularen. Hvis du ændre forespørgslen til at der står [NCR number] i stedet for blot NCR, så skulle det virker.

/Thomas

'thomasjepsen' Det har jeg prøvet, det funker ikke her...?

ok, jeg forholdte mig også blot til det, som Kabbak skrev. Jeg kunne ikke selv downloade db'en fra det link, som du skrev....

'thonas' jeg vil gerne maile den til dig!

øh.. 'thomas'

tj@milla.dk

Den er sendt retur...

ØV, hvor pinligt "Det lod til, at du havde rodet lidt rundt i formular-navnet og tabelnavnet (Non Conformity Report/Non Conformity Report1).
da jeg fik det på plads, så virkede det." TAK FOR HJÆLPEN