473,698 Members | 2,181 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subform Totals Very Slow Access 2007

Hello Everyone,

I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event, which
gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low, on
Forums, google etc.

Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd love
to know!
Elias Farah.

Oct 21 '07 #1
8 7165
el*********@scw .com.au wrote:
Hello Everyone,

I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event, which
gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low, on
Forums, google etc.

Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd love
to know!
Elias Farah.
Not having any experience with 2007, I'll toss in my two cents. With
such a radical change in speed from 1 second to 60 seconds, somethings
wrong. I'd also wonder why a field calculation is taking one seond in
the previous system, can that be speeded up? Maybe 2007 is more strict
in 2007 and looser in 2003 on some process you are doing in the
calculation? Could you roll something up here, tuck something there
that could make the calc fly? IOW, maybe you need to rewrite the
calculation, maybe a couple of more queries to speed it up?
Oct 21 '07 #2
On Sat, 20 Oct 2007 17:14:56 -0700, el*********@scw .com.au wrote:

Just out of curiousity: what is the ControlSource of the totals field?
Probably "=sum([somefield])
Even though it's not elegant, you may want to replace with a DSum
function call.

Can you reproduce the behavior with (a small modification of) one of
the sample applications?

You're not in an ADP by any chance? If yes, this hotfix may apply:
http://support.microsoft.com/kb/936519

-Tom.
>Hello Everyone,

I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event, which
gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low, on
Forums, google etc.

Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd love
to know!
Elias Farah.
Oct 21 '07 #3
I have to print a series a labels. Each record selected may have from 1
to 10 labels to output. Being new to Access and VB I'm unsure of the
best direction to take for this. Should I use a query to build a query
table that contains a listing for each label or should I use a report
that outputs a label for each record? I believe the most desirable way
would be with a report. However, I'm really not sure of how to put in
the necessary code to break out each single record into the multiple
records needed for the labels. I spent the last 12 years programming
Pick style (Universe) databases with databasic and it isn't a big deal
there. I suspect it's the same case here but I'm lost.

Any advice or direction would be much appreciated.

BTW, I've learned a lot from just reading the forum.

Robert Martin

--
I am using the free version of SPAMfighter for private users.
It has removed 15409 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Oct 21 '07 #4
Well, a little searching and I found out how to do this. Allen Browne's
web site of tips and ticks had just the ticket and it works great.

Thanks!

Robert Martin

"Robert Martin" <ki************ @yahoo.comwrote in message
news:Dp******** *************** *******@giganew s.com:
I have to print a series a labels. Each record selected may have from 1
to 10 labels to output. Being new to Access and VB I'm unsure of the
best direction to take for this. Should I use a query to build a query
table that contains a listing for each label or should I use a report
that outputs a label for each record? I believe the most desirable way
would be with a report. However, I'm really not sure of how to put in
the necessary code to break out each single record into the multiple
records needed for the labels. I spent the last 12 years programming
Pick style (Universe) databases with databasic and it isn't a big deal
there. I suspect it's the same case here but I'm lost.

Any advice or direction would be much appreciated.

BTW, I've learned a lot from just reading the forum.

Robert Martin

--
I am using the free version of SPAMfighter for private users.
It has removed 15409 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
--
I am using the free version of SPAMfighter for private users.
It has removed 15409 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Oct 21 '07 #5
Are you running the 2003 version with access 2007 or did you upgrade
the front end completely to the 2007 version?

In all versions, upgrades don't always work 100%. Go into your code
window and try a compile....

You might need to refactor your code as mentioned.

Are there lots of subforms and many tabs etc?

Regards,
Tom Bizannes
15 years spent with access and many more to go....
Sydney, Australia

Oct 21 '07 #6
ARC
I'm having a customer with the same issue with Access 2007. Please post if
you find an answer, and I'll do the same. The only thing I've found that is
close on MS's site is:

http://support.microsoft.com/kb/891176/en-us

However, the article refers to long file names / folder names, as being the
culprit, and converting to a standard 8.3 file name conversion. However,
with Access 2007, and the extention: .accdb, I'm not sure how the extention
would convert to a short filename.

Andy
<el*********@sc w.com.auwrote in message
news:11******** **************@ i13g2000prf.goo glegroups.com.. .
Hello Everyone,

I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event, which
gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low, on
Forums, google etc.

Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd love
to know!
Elias Farah.
Oct 21 '07 #7
On Oct 21, 11:19 am, "ARC" <PCES...@PCESof t.invalidwrote:
I'm having a customer with the same issue with Access 2007. Please post if
you find an answer, and I'll do the same. The only thing I've found that is
close on MS's site is:

http://support.microsoft.com/kb/891176/en-us

However, the article refers to long file names / folder names, as being the
culprit, and converting to a standard 8.3 file name conversion. However,
with Access 2007, and the extention: .accdb, I'm not sure how the extention
would convert to a short filename.

Andy<elias.fa.. .@scw.com.auwro te in message

news:11******** **************@ i13g2000prf.goo glegroups.com.. .
Hello Everyone,
I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).
The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.
Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals). Under
Access 2003, this was perhaps under 1 second, basically instant. I've
compacted the database, I've compared properties with forms/controls
etc that work Ok. I can't work it out!
I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at all.
(ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event, which
gave BLANK/Null display).
Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display the
Subform Totals Instantly. Only the Vista/Office 2007 take 100 times
as long to display the form Totals. Basically, the XP/2003
Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low, on
Forums, google etc.
Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd love
to know!
Elias Farah.
Last week I had a totals query take about a minute to return an
average, using Access 2003 connecting to a sql server back end.

I found that the query was not seeing the primary key of the linked
table, which was being used in a join

Relinking the table fixed the issue. Perhaps that may help.

Oct 21 '07 #8
"ARC" <PC*****@PCESof t.invalidwrote in
news:M5******** *********@nlpi0 69.nbdc.sbc.com :
I'm having a customer with the same issue with Access 2007. Please
post if you find an answer, and I'll do the same. The only thing
I've found that is close on MS's site is:

http://support.microsoft.com/kb/891176/en-us

However, the article refers to long file names / folder names, as
being the culprit, and converting to a standard 8.3 file name
conversion. However, with Access 2007, and the extention: .accdb,
I'm not sure how the extention would convert to a short filename.

Andy
<el*********@sc w.com.auwrote in message
news:11******** **************@ i13g2000prf.goo glegroups.com.. .
>Hello Everyone,

I'm having some very weird behavior on a couple of Access forms.
(Not all forms, just some of them).

The forms have been working for years, under Access XP/2003 etc,
and last week upgraded from Windows XP/Office 2003 to Vista
x64/Office 2007.

Under Access 2007, a couple of forms are now taking 60 seconds to
calculate a total field in a subfoirm. (ie, Invoice Totals).
Under Access 2003, this was perhaps under 1 second, basically
instant. I've compacted the database, I've compared properties
with forms/controls etc that work Ok. I can't work it out!

I Initially thought there must be some change in 2007's form
properies, as I thought the total was just not calculating at
all. (ie, put msgbox(InvoiceT otal) in the form's OnCurrent Event,
which gave BLANK/Null display).

Ok.... When I updated to Vista/Access 2007, Some of the terminals
remained (and still do) on Access 2003. These terminals display
the Subform Totals Instantly. Only the Vista/Office 2007 take
100 times as long to display the form Totals. Basically, the
XP/2003 Terminals give the totals instantly like they should.
I'm interested to hear from others. I've searched high and low,
on Forums, google etc.

Totally weird.
Thanks for listing! Any similar experiences or resolutions, I'd
love to know!
Elias Farah.
Last week I had a totals query take about a minute to return an
average, using Access 2003 connecting to a sql server back end.

I found that the query was not seeing the primary key of the linked
table, which was being used in a join

Relinking the table fixed the issue. Perhaps that may help.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 22 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
12602
by: deko | last post by:
I have two subforms within a particular form. The one on top is a datasheet of transactions; the one on the bottom is a summary of totals. I would like to have the datasheet fill the entire parent form until a command button is clicked, then have the datasheet form shrunk to half it's original height and have the totals summary form appear below it. The totals summary sheet, then, would not be visible until the command button is clicked,...
1
4436
by: phaddock4 | last post by:
Being fairly inexperienced at Access 2000, i've been reading many posts here for the last several days, and testing myself to find the best approach to do the following in A2K: SET UP: I have created a MainTable (and related form), which has an associated SubForm (popup) along with its underlying, separate Table. The tables' relationship is one to many respectively. The primary key
7
6258
by: Ken Mylar | last post by:
First a quick background on the form: I have a form that is normally viewed in Single form mode. It has a subform on it that is in datasheet view. The main form is for work orders and the subform is for parts used on the work order. On the main form I have a LaborTotal (from main form), PartsTotal (from subform) and TotalCost (which is Labor + Parts). All works fine as is. Now to the question: I have a button on my main form to browse...
2
2703
by: BerkshireGuy | last post by:
I have the following code: Dim strSQL As String Dim DB As DAO.Database Dim RS As DAO.Recordset Dim intNumOfPaid, intNumOfHypoed, intNumOfNotTaken, intNumOfDeclined, intNumOfWasted, intNumOfApproved As String Dim QDF As QueryDef Dim PARAM As Parameter
2
3767
by: Mike | last post by:
I have a parent form with two subforms on it. Each subform lists certain records and then totals up one of the fieldsd. The parent form then totals up the two text boxes. The problem is that if there are no records for one of the subform's query, then I get an error (obviously you can't add a value from a text box if it does not exist...): Subform 1: ItemX 10 ItemY 5
4
2014
by: aqua404 | last post by:
I know this has been discussed, but I can't find a resolution. I have a subform on a form. The table with the data for the main form has 15,000 records. I am opening and then setting recordsource so as to only pull 1 record. The table where the subform data comes from has 130,000 records. There is a parent/child link. Indexed on those fields. I have set the datasource to the table, SQL statements and a number of different queries...
4
2241
by: Steve_s | last post by:
Hi I am having problems totalling a particular field in a subform.I am using Access 2003. The subform is based on a query which selects records with various financial information. I have 5 text boxes in the form footer which total certain fields. I have no problem totalling 4 of the fields, but one field which is a calculated field ( ie gross cash - commisions= nett) rounds the figure down ie 175.85 becomes 175.00... I have tried...
10
2843
by: rdemyan via AccessMonster.com | last post by:
I have a subform that displays around 10 fields. Most of the values shown result from some complex calculations. To make it easy, I have stored the results in a temporary table and then all I need to do is set the recordsource of the subform equal to the table. However, it would be very nice if the last row in the subform showed the totals of the previous rows (of course where applicable). If it were a listbox (that didn't require...
14
1868
by: David Grist | last post by:
Hello, Any help would be appreciated!!! I need to sum AMOUNTTEND on a receipts subform that meet a certain criteria. It has to be something like. =sum() where ="tour installment"
0
8598
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9152
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9016
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8856
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6515
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4613
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3037
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2321
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1997
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.