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.
8  7170  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?
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.
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
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
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
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.
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.
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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,...
|
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
|
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...
|
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
|
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
| | |
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...
|
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...
|
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...
|
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"
|
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,...
|
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...
| | |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
