![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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? |
#4
| |||
| |||
|
|
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? |
#5
| |||
| |||
|
|
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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |