WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Microsoft Query gets stuck with more than one parameter

 
   Home -> Office -> Query DAO RSS
Next:  How to put VBA formula in Excel Sheet  
Author Message
Kayda

External


Since: Jun 05, 2007
Posts: 8



(Msg. 1) Posted: Wed Oct 31, 2007 9:36 am
Post subject: Microsoft Query gets stuck with more than one parameter
Archived from groups: microsoft>public>excel>querydao (more info?)

Hi:

I have an Excel 2003 workbook that uses a Microsoft Query to query an
Access database. I there are two parameters in the same spreadsheet
and the query is set to refresh based on these parameters changing.
Those parameters are a start date and an end date.

I have found that the following happens. Let's say the workbook has
been saved with the start and end dates as 5/1/2007 and 5/4/2007. If
you change the start date to, for example, 4/4/2004 and the quickly go
to the end date cell and change it to 4/4/2004, the query doesn't
refresh a second time. You have changed the end date cell, and the
start date and end date cells now read as 4/4/2004 and 4/4/2004, so it
should be one day's worth of data. But what the query shows is
actually as if the end date never changed (i.e. start date 4/4/2004
and end date 5/4/2007). It is because the end date was changed when it
was still refreshing the query based upon the start date change.

You might be saying "well, don't do that so quickly then". But I have
developed this for users and, while, I could explain the "don't do
that" workaround, in my mind this is a bug--why can't Excel "queue up"
this cell change, wait until the first refresh is done, and refresh
again based on the second change? Is this a known issue?

Thanks,
Kayda
Back to top
Login to vote
Bill Manville

External


Since: Jul 30, 2004
Posts: 810



(Msg. 2) Posted: Thu Nov 01, 2007 12:09 am
Post subject: Re: Microsoft Query gets stuck with more than one parameter [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Does it help if you right-click the query table > Data Range Properties
and change the state of Enable Background Refresh?

Bill Manville
MVP - Microsoft Excel, Oxford, England
Back to top
Login to vote
Kayda

External


Since: Jun 05, 2007
Posts: 8



(Msg. 3) Posted: Thu Nov 01, 2007 5:53 pm
Post subject: Re: Microsoft Query gets stuck with more than one parameter [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Background refresh is enabled. I want it enabled, right or otherwise
it won't refresh when I change the parameters--right?
Back to top
Login to vote
Bill Manville

External


Since: Jul 30, 2004
Posts: 810



(Msg. 4) Posted: Fri Nov 02, 2007 5:57 pm
Post subject: Re: Microsoft Query gets stuck with more than one parameter [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

No, I think it will still refresh on changes of parameter if background
refresh is disabled.

Background refresh means it does the query in parallel with other
actions. If it is enabled I am guessing that when you change the
second parameter it decides it is still executing the query in the
background and so doesn't initiate it again.

Give it a try.
I may be wrong.

Bill Manville
MVP - Microsoft Excel, Oxford, England
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Query DAO All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET