Solved

Access 2007 Requery Not Working

Posted on 2011-02-22
6
270 Views
Last Modified: 2012-05-11
Hello,

I have a form with multiple subforms on it.  The original application was written in Access 2000.  I requery a form that has totals on the bottom of it.

For Example: Field is Sales
In the bottom of the form in the footer is a field total that is =Sum([Sales])

I run some queries to build the subform data and then refresh the subforms as follows:
 
  Me.Parent.PlanPat.Requery
    Me.Parent.PatColorHist.Requery
    Me.Parent.PatSizeHist.Requery
    Me.Parent.PatHistSColorSize.Requery
    Me.Include.SetFocus
    Me.cmdUpdate.Visible = False
    Me.FormHeader.BackColor = -2147483633

The first time I make selections and run it, all is well.  If I change the criteia and run again, all the sum fields disappear.  I can sit for 10 minutes and they dont display.  If I pop off Acces to another open application like Outlook and pop back, the fields display fine.

Never had the problem before "07"  any thoughts are appreciated.
0
Comment
Question by:vmccune
  • 3
  • 3
6 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34954118
You can try the basic stuff.
Create a blank A2007 accdb, then import all objects (except linked tables) from the A2000 mdb.

And even prior to this, just try a Compact and Repair on the ACCDB.

So ... you're saying it has never worked in A2007 ?

mx
0
 

Author Comment

by:vmccune
ID: 34954172
Been there, done those.

I just tried makeing a buttom on the main for and requiered without the parent and it still does not work.

Its not a big requery and the table soruce for the form has only 18 records.
0
 
LVL 75
ID: 34954241
So .... the data is there right, just not displaying until you change focus to another app window and back?

mx
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:vmccune
ID: 34954328
Yep.  Not only is the data there, all the records display fine and refresh EXCEPT the total buttons.
0
 

Author Comment

by:vmccune
ID: 34954377
I think I found the probelm.  One field is calulated and is looping.  I am awarding you the points for helping me.
0
 
LVL 75
ID: 34954427
glad you found it ...

mx
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now