dbTalk Databases Forums  

sr2 <>sr3

comp.databases.ms-access comp.databases.ms-access


Discuss sr2 <>sr3 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Georg
 
Posts: n/a

Default sr2 <>sr3 - 03-30-2009 , 01:22 PM






Hi,

I've updated my database from ac2003 professional SR2 to sr3.
now when if click on a general form to go to another form there is a delay
to open the new form of almost 10 seconds !
Before with the basicsversion of 2003 professional and with the sr2 there
was no delay. It's very ennoying to wait for action . In the statusbar i can
see a text eg : busy with calculation ......" but no mention with the kind
of calculation
my code :
'*********
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "order"
stLinkCriteria = "[OrderID]=" & Me![orderId]
Me.OrderProcess= -1
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmOrdersToDay"
DoCmd.Maximize
'***************************

Also a combobox is empty despite the keyfield of the combox is filled
properly.

what's diferent in Sr 3 and cause the problems as descibred above?

regards, georg



Reply With Quote
  #2  
Old   
Georg
 
Posts: n/a

Default Re: sr2 <>sr3 - 03-30-2009 , 02:43 PM






hi,
how i can know which field he is calculating ?
regards georg .

"Georg" <georg@sgreorgl> schreef in bericht
news:49d10da0$0$2856$ba620e4c (AT) news (DOT) skynet.be...
Quote:
Hi,

I've updated my database from ac2003 professional SR2 to sr3.
now when if click on a general form to go to another form there is a delay
to open the new form of almost 10 seconds !
Before with the basicsversion of 2003 professional and with the sr2 there
was no delay. It's very ennoying to wait for action . In the statusbar i
can see a text eg : busy with calculation ......" but no mention with the
kind of calculation
my code :
'*********
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "order"
stLinkCriteria = "[OrderID]=" & Me![orderId]
Me.OrderProcess= -1
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmOrdersToDay"
DoCmd.Maximize
'***************************

Also a combobox is empty despite the keyfield of the combox is filled
properly.

what's diferent in Sr 3 and cause the problems as descibred above?

regards, georg





Reply With Quote
  #3  
Old   
Salad
 
Posts: n/a

Default Re: sr2 <>sr3 - 03-30-2009 , 04:00 PM



Georg wrote:

Quote:
Hi,

I've updated my database from ac2003 professional SR2 to sr3.
now when if click on a general form to go to another form there is a delay
to open the new form of almost 10 seconds !
Before with the basicsversion of 2003 professional and with the sr2 there
was no delay. It's very ennoying to wait for action . In the statusbar i can
see a text eg : busy with calculation ......" but no mention with the kind
of calculation
my code :
'*********
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "order"
stLinkCriteria = "[OrderID]=" & Me![orderId]
Me.OrderProcess= -1
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmOrdersToDay"
DoCmd.Maximize
'***************************

Also a combobox is empty despite the keyfield of the combox is filled
properly.

what's diferent in Sr 3 and cause the problems as descibred above?

regards, georg


Did you also apply the hotfix?


Reply With Quote
  #4  
Old   
Georg
 
Posts: n/a

Default Re: sr2 <>sr3 - 03-30-2009 , 04:19 PM



hi Salad,

what do you mean with "apply the hotfix "
i ve doubleclicked on the exe-file of the download of sr 3 and afterwards i
turned off and restart my pc. the info of my access tells me that i've
"microsoft Office Acecss Professional Edition 2003 SR3".

regards Georg

"Salad" <oil (AT) vinegar (DOT) com> schreef in bericht
news:APydnSrDmOVFr0zUnZ2dnUVZ_gWWnZ2d (AT) earthlink (DOT) com...
Quote:
Georg wrote:

Hi,

I've updated my database from ac2003 professional SR2 to sr3.
now when if click on a general form to go to another form there is a
delay to open the new form of almost 10 seconds !
Before with the basicsversion of 2003 professional and with the sr2 there
was no delay. It's very ennoying to wait for action . In the statusbar i
can see a text eg : busy with calculation ......" but no mention with
the kind of calculation
my code :
'*********
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "order"
stLinkCriteria = "[OrderID]=" & Me![orderId]
Me.OrderProcess= -1
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmOrdersToDay"
DoCmd.Maximize
'***************************

Also a combobox is empty despite the keyfield of the combox is filled
properly.

what's diferent in Sr 3 and cause the problems as descibred above?

regards, georg


Did you also apply the hotfix?



Reply With Quote
  #5  
Old   
Salad
 
Posts: n/a

Default Re: sr2 <>sr3 - 03-30-2009 , 06:00 PM



Georg wrote:
Quote:
hi Salad,

what do you mean with "apply the hotfix "
i ve doubleclicked on the exe-file of the download of sr 3 and afterwards i
turned off and restart my pc. the info of my access tells me that i've
"microsoft Office Acecss Professional Edition 2003 SR3".

regards Georg

"Salad" <oil (AT) vinegar (DOT) com> schreef in bericht
news:APydnSrDmOVFr0zUnZ2dnUVZ_gWWnZ2d (AT) earthlink (DOT) com...

Georg wrote:


Hi,

I've updated my database from ac2003 professional SR2 to sr3.
now when if click on a general form to go to another form there is a
delay to open the new form of almost 10 seconds !
Before with the basicsversion of 2003 professional and with the sr2 there
was no delay. It's very ennoying to wait for action . In the statusbar i
can see a text eg : busy with calculation ......" but no mention with
the kind of calculation
my code :
'*********
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "order"
stLinkCriteria = "[OrderID]=" & Me![orderId]
Me.OrderProcess= -1
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmOrdersToDay"
DoCmd.Maximize
'***************************

Also a combobox is empty despite the keyfield of the combox is filled
properly.

what's diferent in Sr 3 and cause the problems as descibred above?

regards, georg



Did you also apply the hotfix?



Here's one link regarding the hotfix.
http://support.microsoft.com/kb/945674.

One paragraph seemed of interest "This hotfix package fixes the
following issues: (http://support.microsoft.com/kb/945280/ ) Combo box
controls and list box controls display no value or incorrect values in
Access 2003 after you install Office 2003 Service Pack 3..."



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.