RE: function doesn't return value - SOMETIMES!
- From: petery@xxxxxxxxxxxxxxxxxxxx (Peter Yang [MSFT])
- Date: Mon, 20 Jun 2005 03:26:22 GMT
Hello Kevin,
It seems the calling stack has some issues. This could occur if the
database is corrupted or if there is issues inside the function called
which overwrites the stack by mistake. Did you perform sth special in the
function? If not, I suggest that you create a new database, and import the
objects from the original one to test.
Also, pelase make sure you have installed the latest Jet driver.
More related information:
209137 ACC2000: How to Troubleshoot/Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137
247771 ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: function doesn't return value - SOMETIMES!
| thread-index: AcV06yzrdtoK6vATSa+xjdX7XvIMvw==
| X-WBNR-Posting-Host: 67.86.86.237
| From: "=?Utf-8?B?S2V2aW4gV2l0dHk=?=" <kdw@xxxxxxxxxxxxxxxx>
| References: <40161CD9-581C-4C61-944D-F9863EB213B4@xxxxxxxxxxxxx>
<8B83FB9F-4BCD-49F5-B02C-35551A34DF49@xxxxxxxxxxxxx>
| Subject: RE: function doesn't return value - SOMETIMES!
| Date: Sun, 19 Jun 2005 09:23:06 -0700
| Lines: 62
| Message-ID: <37E2D2B8-A0DB-4D55-9EAB-A4730F72D962@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.modulesdaovba
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.access.modulesdaovba:29903
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| Sparker -
|
| 'Far as I know, Long is an integer and doesn't handle decimals; Double
can
| handle much larger numbers, and DOES handle decimals. So I don't think
| that's it.
|
| Thanks anyway.
|
| "sparker" wrote:
|
| > Kevin,
| > I think I have seen something like that before when declaring a
numerical
| > variable as an integer only to find out later that it was not large
enough
| > and having to redeclare it as a long to handle the larger numbers. I
had
| > discovered this when a function returned zero. But if I am
understanding you
| > correctly. You are saying that you followed the code all the way
through to
| > the very end of the Public Function GetOrderDtlSummary() and at the end
of
| > the function GetOrderDtlSummary = the correct results and when the
calling
| > Sub received them all it received was a big fat zero? Hmmmm.... Well
the only
| > thing I can see is that you are declaring 3 of your numerical values as
| > doubles... are you sure that datatype is large enough to handle the
data? My
| > guess would be that when this code is not functioning it would be
because of
| > the declared Double data type not being large enough to handle the
data. And
| > when it does work correctly that would be because this data type is
| > sufficient in size to handle the data it contains. Also Note: I have
read
| > that you do not gain anything by declaring a double versus long so
maybe you
| > should try using the long data type... Can you reproduce the
circumstances of
| > Friday with the data type changed to a long and see what happens? Or
maybe
| > use the currency datatype? If that does not solve it can you place more
of
| > your code on here for review?
| > Take Care & God Bless ~ SPARKER ~
| >
| >
| > "Kevin Witty" wrote:
| >
| > > I have a function defined in a header which reads matching records in
its
| > > subform and updates fields in the the header recordset. (I know this
is
| > > non-normal, but the fields are needed for display and performance
reasons.)
| > >
| > > MOST of the time this routine works fine, but occasionally it
doesn't.
| > > Until Friday I was never able to catch it misperforming, but then I
caught it
| > > with its pants down. The line
| > >
| > > GetOrderDtlSummary("Dispatch", Nz(Me.RecordKey), Nz(tEstQty), _
| > > Nz(tActQty), Nz(tDollars)) & ""
| > >
| > > calls the function
| > >
| > > Public Function GetOrderDtlSummary(DispatchOrStanding As String, _
| > > OrderKey As Long, tDtlEstQty As Double, tDtlActQty As Double,
| > > tDollars As Double) As String
| > >
| > > which reads the detail records and returns tEstQty, tAcrQty and
tDollars,
| > > which I then use to update the header.
| > >
| > > On Friday I could watch this in debug mode, see the variables
calculated
| > > properly in the called function, and then RETURNED TO THE CALLING
FUNCTION AS
| > > 0. MOST of the time, this has worked fine.
| > >
| > > What might be causing this bizarre sporadic behavior?
| > >
| > > Kevin
|
.
- Follow-Ups:
- RE: function doesn't return value - SOMETIMES!
- From: Kevin Witty
- RE: function doesn't return value - SOMETIMES!
- References:
- function doesn't return value - SOMETIMES!
- From: Kevin Witty
- RE: function doesn't return value - SOMETIMES!
- From: sparker
- RE: function doesn't return value - SOMETIMES!
- From: Kevin Witty
- function doesn't return value - SOMETIMES!
- Prev by Date: How to press keyboard?
- Next by Date: Re: How to press keyboard?
- Previous by thread: RE: function doesn't return value - SOMETIMES!
- Next by thread: RE: function doesn't return value - SOMETIMES!
- Index(es):
Relevant Pages
|
