Skip field in export specification

[fbs]

I run a query that I export out to a tab delimited file. This text file is used for another application. The problem I am having is if I select "skip field" in my text "export specification" it still exports out that piece of data, even though I have selected "Skip Field". The data type on this field is a number and field size is integer.

I thought I read in another access newsgroup that this is a known bug? Is that true? Is there a fix? I am anxious to fix this because, I have 90 query's that I export to text and I would hate to have to go to each query and select "Not Show" that field.

Help?

 

[Pat Hartman]

90 queries based on the same spec? I see a problem with that. Wouldn't one query with a parameter do the job?

I thought I read in another access newsgroup that this is a known bug? Is that true? Is there a fix? I am anxious to fix this because, I have 90 query's that I export to text and I would hate to have to go to each query and select "Not Show" that field.

I have never run into this bug, probably because I always adjust the query if the field list changes. However, if there is a "fix", make sure that your service packs are up to date. You can then check the knowledge base for "hotfix". This should give you a list of emergency fixes that the team has made. Generally it is recommended that you only install a hotfix if it will solve a problem you are currently experiencing.

 

[fbs]

I am running Access 2002 SPK3.

As far as using a parameter query, not sure how that would work? I have never used a parameter query....

Some background information, this data is used in our publishing environment and each query represents a published table for one of our magazine issues. The query handles the ranking of a company, based on their reported revenue amount for a particular market. Each query also contains the pagination instructions for a Quark Xpress template, the exported results (.txt file) are then flowed into the appropriate text box within the Quark Template completely formatted for Quark Template.

 

[Pat Hartman]

each query represents a published table for one of our magazine issues

rather than hard-coding the selection criteria, make it a parameter:

Where SomeField = [Enter Some Field];
When the query runs, you will be asked to provide a value for [Enter Some Field].

Did you search for hotfixes?

 

[fbs]

Pat,

Thanks, I will take a look at the Parameter Query option.

I have not looked for the hotfix's yet