MS Access Query Export Error "Too Few Parameters. Expected 1"

[Punker]

Hi guys,

I am trying to create export specifications for one of my queries. Now when I run the query on its own, it works perfectly. However when I try to export the data I get back the error message "Too few parameters. Expected 1." Has anyone encountered this before? Below is my SQL statement in case it helps:


SELECT ClaimDetail.cd_ClaimId, BatchMaster.bm_BatchId, ClaimDetail.cd_BatchId, ClaimDetail.cd_ClaimNum, ClaimDetail.expectedResult, ClaimDetail.REC_CODE_IN, ClaimDetail.DATA_CENTRE_NUM, ClaimDetail.DATA_CENTRE_SEQNUM, ClaimDetail.PAYEE_NUM, ClaimDetail.PRACTITIONER_NUM, ClaimDetail.MSP_REGISTRATION, ClaimDetail.NAME_VERIFY, ClaimDetail.DEPENDENT_NUM, ClaimDetail.BILLED_SRV_UNITS, ClaimDetail.SERVICE_CLARIFICATION, ClaimDetail.MSP_ANATOMICAL_AREA, ClaimDetail.AFTER_HOURS_SERVICE_INDICATOR, ClaimDetail.NEW_PROGRAM_INDICATOR, ClaimDetail.BILLED_FEE_ITEM, ClaimDetail.BILLED_AMOUNT, ClaimDetail.PAYMENT_MODE, ClaimDetail.SERVICE_DATE, ClaimDetail.SERVICE_TO_DAY, ClaimDetail.SUBMISSION_CODE, ClaimDetail.EXPANDED_SUBMISSION, ClaimDetail.DIAGNOSTIC_CODE_1, ClaimDetail.DIAGNOSTIC_CODE_2, ClaimDetail.[DIAGNOSTIC_CODE_-3], ClaimDetail.DIAGNOSTIC_EXPAND, ClaimDetail.SERVICE_LOCATION_CD, ClaimDetail.REF_PRACT_1_CD, ClaimDetail.REF_PRACT_1, ClaimDetail.REF_PRACT_2_CD, ClaimDetail.REF_PRACT_2, ClaimDetail.TIME_CALL_RECD_SRV, ClaimDetail.SERVICE_TIME_START, ClaimDetail.SERVICE_TIME_FINISH, ClaimDetail.BIRTH_DATE, ClaimDetail.OFFICE_FOLIO_NUMBER, ClaimDetail.CORREPSONDENCE_CODE, ClaimDetail.CLAIM_SHORT_COMMENT, ClaimDetail.MVA_CLAIM_CODE, ClaimDetail.ICBC_CLAIM_NUM, ClaimDetail.ORIGINA_MSP_FN, ClaimDetail.FACILITY_NUM, ClaimDetail.FACILITY_SUB_NUM, ClaimDetail.FILLER_CLAIM_C02_RCD, ClaimDetail.OIN_INSURER_CODE, ClaimDetail.OIN_REGISTRATION, ClaimDetail.OIN_FIRST_NAME, ClaimDetail.OIN_SECOND_NAME, ClaimDetail.OIN_SURNAME, ClaimDetail.OIN_SEX_CODE, ClaimDetail.OIN_ADDRESS_1, ClaimDetail.OIN_ADDRESS_2, ClaimDetail.OIN_ADDRESS_3, ClaimDetail.OIN_ADDRESS_4, ClaimDetail.OIN_POSTAL_CODE
FROM BatchMaster INNER JOIN ClaimDetail ON BatchMaster.bm_BatchId = ClaimDetail.cd_BatchId
WHERE (((BatchMaster.bm_BatchId)=[Forms]![BatchMainForm]![bm_BatchId]));



I have 2 tables - Master/Detail

 BatchMaster 
---------------
bm_BatchId PK AutoNumber
bm_BatchNum Text
bm_Description Text
 
 
ClaimDetail
--------------
cd_ClaimId PK AutoNumber
cd_BatchId Number
cd_ClaimNum Text
etc.
 

As for forms go, I have 2 forms. The BatchMainForm contains a subform (ClaimDataForm) which is a datasheet.

Thanks guys, any help is appreciated.

---Punker

[PEB]

Hi,

Do You export your data using the export command in Access or you use a command in VB?

If it is in VB maybe you have to assign to the parameters their values!

And the export command in Access have to run normally???

Have a nice luck!