calculation proccess doesn't ends in the form

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
i'm using the interval of the timer in the form,
one of my issues are that there is contact calculation that doesnt stop
and its influancing the textboxes that are working on queries.
any suggestions?
 
Hi all,
i'm using the interval of the timer in the form,
one of my issues are that there is contact calculation that doesnt stop
and its influancing the textboxes that are working on queries.
any suggestions?
Click to expand...

Could you explain what this calculation is, and what influence the
time is having on it?

John W. Vinson[MVP]
 
Huh?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Huh?
Click to expand...

I was responding to Thread's (cryptic, to me) post:

Hi all,
i'm using the interval of the timer in the form,
one of my issues are that there is contact calculation that doesnt
stop and its influancing the textboxes that are working on queries.
any suggestions?

I can't tell what calculation "doesn't stop", why one would expect it
to stop, and what "influence" she or he is talking about.

John W. Vinson[MVP]
 
Cryptic to me, too, John! That's what the "Huh?" was directed at, not you!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
I'm using the OnTimer function and activating interval time
from some reason its proccessing the calculation without stoping or
stoping after some time

missinglinq via AccessMonster.com ëúá:
 
I'm still not sure exactly what you're doing, but if yo mean that you have a
calculation that is run off of the timer event, it's going to keep running
unless/until you set the Timer Interval to zero.
I'm using the OnTimer function and activating interval time
from some reason its proccessing the calculation without stoping or
stoping after some time

missinglinq via AccessMonster.com כתב:
Cryptic to me, too, John! That's what the "Huh?" was directed at, not you!
Click to expand...
[quoted text clipped - 5 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
 
it is a big minus as i'm using this timer interval to preform a form
questing regarding the form's frame,i think maybe becaouse the interval
is too fast,its making this problem,i changed it to 1000 instead of 100
and now its working but still i dont understand why it suppose to
influance as most of microsoft softwares are basing on questioning

missinglinq via AccessMonster.com ëúá:
I'm still not sure exactly what you're doing, but if yo mean that you have a
calculation that is run off of the timer event, it's going to keep running
unless/until you set the Timer Interval to zero.
I'm using the OnTimer function and activating interval time
from some reason its proccessing the calculation without stoping or
stoping after some time

missinglinq via AccessMonster.com ëúá:
Cryptic to me, too, John! That's what the "Huh?" was directed at, not you!
Click to expand...
[quoted text clipped - 5 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
Click to expand...
 
it is a big minus as i'm using this timer interval to preform a form
questing regarding the form's frame,i think maybe becaouse the interval
is too fast,its making this problem,i changed it to 1000 instead of 100
and now its working but still i dont understand why it suppose to
influance as most of microsoft softwares are basing on questioning
Click to expand...

Please post your code, and explain what you expect it to do. There is
a word "questing" but it refers to journeys in search of a goal, and
is not used in Access. I cannot for the life of me figure out what you
are asking!

John W. Vinson[MVP]
 
Me either, John, and I've been trying to uderstand it since yesterday!

John said:
Please post your code, and explain what you expect it to do. There is
a word "questing" but it refers to journeys in search of a goal, and
is not used in Access. I cannot for the life of me figure out what you
are asking!

John W. Vinson[MVP]
Click to expand...

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
please see below the relevant function:


Private Sub Form_Timer()
'freezing for screen culomns in form view
If FrameFlag <> Me.CurrentSectionLeft Then
FrameFlag = Me.CurrentSectionLeft
If Me.CurrentSectionLeft < 0 Then
country.Left = (Me.CurrentSectionLeft * -1) + 300
MIP_SIP.Left = (Me.CurrentSectionLeft * -1) + 200 + 1200
group3.Left = (Me.CurrentSectionLeft * -1) + 300
group3_combo.Left = (Me.CurrentSectionLeft * -1) + 300
group4.Left = (Me.CurrentSectionLeft * -1) + 300
group4_combo.Left = (Me.CurrentSectionLeft * -1) + 300
group5.Left = (Me.CurrentSectionLeft * -1) + 300
group5_combo.Left = (Me.CurrentSectionLeft * -1) + 300
group6.Left = (Me.CurrentSectionLeft * -1) + 300
group6_combo.Left = (Me.CurrentSectionLeft * -1) + 300
group7.Left = (Me.CurrentSectionLeft * -1) + 300
group7_combo.Left = (Me.CurrentSectionLeft * -1) + 300
Filtering.Left = (Me.CurrentSectionLeft * -1) + 300
Text90.Left = (Me.CurrentSectionLeft * -1) + 220 + 2325
Label291.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Label217.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Label218.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Label219.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Label213.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Text290.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Text256.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Text257.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
Text259.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
text944.Left = (Me.CurrentSectionLeft * -1) + 220 + 13320
If FrameFlag <> Me.CurrentSectionLeft Then
End If
Else:
group3.Left = 120
group3_combo.Left = 120
group4.Left = 120
group4_combo.Left = 120
group5.Left = 120
group5_combo.Left = 120
group6.Left = 120
group6_combo.Left = 120
group7.Left = 120
group7_combo.Left = 120
Filtering.Left = 120
Text90.Left = 2325
Label291.Left = 13320
Label217.Left = 13320
Label218.Left = 13320
Label219.Left = 13320
Label213.Left = 13320
Text290.Left = 13320
Text256.Left = 13320
Text257.Left = 13320
Text259.Left = 13320
text944.Left = 13320
End If
End If
End Sub
missinglinq via AccessMonster.com ëúá:
 
the function is just responsible of dynamicly change the place of the
control base on checking if the control is in the frame of the screen
or not se-tu

John Vinson ëúá:
 
the function is just responsible of dynamicly change the place of the
control base on checking if the control is in the frame of the screen
or not se-tu
Click to expand...

I'm sorry, but we're not communicating. I assume it's a language
barrier. "The frame of the screen" is not terminology that I've ever
used in Access; "se-tu" doesn't mean anything to me either.

I can see that you are attempting to resize or move controls, though
why you would want to do so every tenth of a second (or every second)
baffles me completely.

John W. Vinson[MVP]
 
i'm trying to implement the freeszing of culomns like it appears in the
datasheet view

John Vinson ëúá:
 
Hi
John can you please contact my email?
Click to expand...

I'm sorry; I'm a self-employed consultant, donating my time on the
newsgroups. Private EMail support is reserved for paying customers,
and I'm booked up currently, and not in a position to take on
additional work. Your project is also outside my area of expertise -
I've never needed to dynamically redesign forms at runtime, though I
know that it can be done.

Perhaps you should post a new message, as a new thread, explaining -
first - *what you are trying to accomplish* (maybe there is an easier
way!), how you've tried to accomplish it (repost the code), and what
specific problems you're having.


John W. Vinson[MVP]
 
Hi John,
that is true that i'm trying to re-design the form during the
run-time,i found some solution for this.
the issue is that i have alot of field that needs to implemented nicly
on a form and to be devided to 2 groups,i'm using a suming as well but
it doesnt metter in this current time,
until now there was a suggestion to put the data in a tab control
do you have more example how to easier this or implement it more user
friendly?

John Vinson ëúá:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Calculations 2
Calculatting Time difference 1
Mark calculations 1
How to calculate form field 1
calculation based on query 1
multi-field query 2
Calculated field in a table 6
Form Timer 2

Back
Top