Create a new sub called "wait" (or watever you like). I would like some kind of delay or pause here to allow the window to open properly before the calculations below.Ĭcombo(2) = Me.c2combo.Column(1, Me.c2combo.ListIndex)Ĭcombo(3) = Me.c2combo.Column(1, Me.c3combo.ListIndex)Ĭcombo(4) = Me.c2combo.Column(1, Me.c4combo.ListIndex)Ĭcombo(5) = Me.c2combo.Column(1, Me.c5combo.ListIndex)Ĭcombo(6) = Me.c2combo.Column(1, Me.c6combo.ListIndex)Ĭcombo(7) = Me.c2combo.Column(1, Me.c7combo.ListIndex)Ĭcombo(8) = Me.c2combo.Column(1, Me.c8combo.ListIndex)Ĭcombo(9) = Me.c2combo.Column(1, Me.c9combo.ListIndex)Ĭcombo(10) = Me.c2combo.Column(1, Me.c10combo.ListIndex)Ĭcombo(11) = Me.c2combo.Column(1, Me.c11combo.ListIndex)Ĭcombo(1) = Get_PostCode_Score(Replace(Me.TextBox1, " ", ""))ĭoCmd.Close acForm, "calcsinprog", acSaveNoĪny help at all will be greatly appreciated Is there any way to delay the calculation in VB so that my window will display correctly? The calculation can then take place after this. It seems as though Access cannot handle displayinging my window whilst the calculation is being caried out. The problem I am having is that this window will not display properly until after the calculation is completed.
Rather than the user having to stare at the same screen and wonder what is happening, I have another form which pops up to tell the user the calculations are in progress. This all works fine but does take some time for the calculation to complete due to the size of the datasets.
ARIA MAESTOSA ADD PAUSE DELAY BEFORE PLAYING CODE
The form accepts lots of user inputs and these are then grabbed by my VB code to calculate a result. I am having trouble with an Access form which runs some VB code behind it.
0 kommentar(er)
