Dear Matt,
Thank you for your reply.
The problem was solved before I read your comment. It is
right for Access by default it put the variables as
variant.I don't understand when I produce the bills for
400 consumer and it complet 50% than MsgBox("Overlow")
apear.It mean that 200 consumer come through my module one
by one without any problem.
So I try to solved it by debug step by step and finally
found that it stop at point DebtID("UNT").As you saw my
module it have a lot of functions to call, I think this is
the case so I remove it and write it in the place where I
call and after that my programs is working sucessfully
100%.
Anyway I would like to said "Thanks you" to you for your
help.
As we contact with a fews message I'm not yet khnow above
you.For me, I work as IT Manager of Electricity of
Combodge.
Regards,
Thay
Quote:
>-----Original Message-----
>Kan:
>Pasting code into the body of posts is preferrable to
attaching
>documents because some ISPs don't allow binaries in non-
binaries
>groups and because the archives won't show what was in
the attachment.
>I took a quick glance at the code, and saw several
variables declared
>as Integer. From my perspective there's nothing else to
look at.
>It also looked like lots of variables weren't
specifically declared as
Quote:
>any type at all. I'm not sure what Access does in that
case (probably
>Variant), but I'm thinking that's not sound practice.
IMHO.
>If you get rid of all the Integers and Singles and still
have the
>problem, try to more precisely narrow down the line on
which the
>error is occurring. If you do so, I think more people
would be
>willing to lend assistance.
>Good luck!
>-Matt
>On Wed, 27 Nov 2002 00:04:09 -0800, "Kan Thay"
Quote:
>>Thank you for the answer. But accualy it is not that
case.
>>The attached file is the module for generating the bill
>>and it is working for 3 months already, the problem just
>>starting this month. For the number of consumer in the
>>sequence are only 400.
>>If you can spent a litle time to check and tell me what
>>wrong with it.
>>Yours Sincerely,
>>>-----Original Message-----
>>>This most commonly comes up when you put a really big
>>number in a data
>>>type that can't hold it. This comes up sometimes when
>>using Int
>>>rather than Long or Single rather than Double.
>>>If that doesn't help, give us a little more info.
>>>-Matt
>>>On Tue, 26 Nov 2002 17:00:26 -0800, "Kan Thay"
>>>>Dear all
>>>>I have a problem with my application on OVERFLOW
dialog
>>>>box message appear during my program are on progress,i
>>try
>>>>to solve the problem unfortunately my effort fail so
i
>>>>decide to request your help ,how can i solve it.
>>>>thank in advance
>>>.
>.
OVERFLOW message