Re: Export query to Excel

From: MGFoster (me_at_privacy.com)
Date: 03/01/04 

Date: Mon, 01 Mar 2004 19:33:33 GMT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you tried "Remove Filter/Sort" from the pop-up menu & then save
the query. Then open the query & see if the Export feature can work.
If it can then try filtering by form & try the Export feature again.
If that doesn't work you may wish to compact the Access file.

My reasoning is that there are a lot of temporary queries/filter
criterias in temp memory & that is causing the Export feature to fail.
  By removing the filter/sort and/or compacting the file will remove
all these temp things.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEOQFYechKqOuFEgEQKRUgCeKlVtTNk85FMjkKno3ONuU7CJj7MAn2u5
YtDSN4rCH5AztgGGIYs/jUrY
=85BM
-----END PGP SIGNATURE-----

JudyB wrote:

> We have a query which we have been using to export data to Excel. The query
> opens with many records (over 12M). We use the Filter by Form feature to
> isolate the few records we need. For the past several months it has been
> working fine. Suddenly now our File, Export feature is no longer working if
> the filter has been used, or any sorting has been done. Our only solution
> currently is to go the design view, change the criteria as needed. Save and
> close the query, and then reopen it to show a select number of records. We
> cannot sort or filter anymore, just go directly to File, Export. Any ideas
> on why this would be occurring? We would like to be able to use the
> filters, because the criteria changes so frequently (different fields each
> time).

Relevant Pages

  • Re: Display if count = 5
    ... criteria line of the field that is being counted, ... And, if you count something in the design grid in a query, ... if you have designed a complicated filter. ...
    (microsoft.public.access.queries)
  • Re: other table that stores data differently than ADO.Net datatable?
    ... >> would suggest making some sort of a "search" type of screen and filter ... >> criteria for your where clause, that will help slim down your list. ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Near Suicidal!
    ... box to filter by pressing a button on the form where the list ... By pressing on the button I want to pass a parameter (or ... to the the query the list's rowSource is based on. ... example) into the fldChargeType's criteria row and ...
    (microsoft.public.access.formscoding)
  • Re: Query only showing specific records - i need all - please help
    ... If the data is in the table but not in the form, you may have a filter on ... If the form is based on a query, then, when you look at the ... have a criteria in the query that filter out those records. ... You could also have use a Format to format the NULL values as displaying ...
    (microsoft.public.access.queries)
  • Re: access 2003
    ... the "ChooseJob_AfterUpdate Event" uses this filter ... the form to show a new set of records: For, as you know, the query points to ... the two combo boxes for criteria information. ...
    (microsoft.public.access.conversion)