Export Text Wizard

[mousemat]

I have a query which I run that allows me to export the data the a Foxed Length Format which uses a spec from our client.

The following code works fine:

Between #01/08/2003# And #31/08/2003#

The only problem with this is that I manually have to change the dates in the query for each month that I am doing.

What I am trying to do is have the query ask for the start date and the end date, all of which I can do with the following code:

Between [BeginDate] And [EndDate]

However using the second code I am not able to use the Export Text Wizard as it gives me the error of:

Too few parameters. Expect 2

What is wrong with the code and how can I get it to do what I want it to do?

 

[FoFa]

Typically the export wizard will rerun the query, but it is open already so it does not ask again, then gives you the error (or some such non-sense as that). What I do usually in this case is just create a form I can put the dates in, click a button and life is good. The query will pull the dates from the form fields.

 

[mousemat]

Thanks FoFa,

I have tried the froms option but still I cannot get the Export Text Wizard to operate correctly. I keep getting the same error message: Too few Parameters. Expected 2.

Any other ideas?

 

[FoFa]

You must change the query the export is based on to pull the data from the form fields rather than [enter some data]. So in your criteria in your query you woiuld have something like Forms!MyFormName!MyFormField