Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SP3 Calculations (Access 2003)

    [GCO – Status] is a numeric field

    =Sum(IIf([GCO - Status]=4,1,0))

    This calculation works in Access 2003 SP2

    but gives me an error in Access 2003 SP3

    I'm getting seriously tired of uninstalling Access in order to go back to SP2.

    Any suggestions.
    Cheers,
    Andy

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SP3 Calculations (Access 2003)

    I don't know why you should be having any problems, but you could try this instead:

    =sum( abs( [gco - Status] = 4))
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Thanks Mark, but it wouldn't buy that version either. And speaking of versions, this is exactly what I have:

    Access 2003 (11.8204.8221) SP3

    This truly aggravates me. I know that as soon as I do the whole unload, reload, update to SP2, that this will work.
    As soon as I can stop those lovely auto-updates which insists that I need SP3, then maybe I'll get a little peache and quiet.
    Cheers,
    Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SP3 Calculations (Access 2003)

    Have you installed the post-SP3 hotfixes? They solve the most obnoxious of the numerous problems with Access 2003 SP3. See <post:=735,706>post 735,706</post:> for links.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Thanks, Hans,

    Unfortunately, that didn't work either. Can't believe anything that simple could be so screwy. Anyway, back to unloading and reloading. Just as a matter of curiousity, where exactly do I cut off these "Super" updates to SP3?
    Cheers,
    Andy

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SP3 Calculations (Access 2003)

    You can specify that you don't want to be reminded of a specific update in Microsoft Update.

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Thanks Hans
    Cheers,
    Andy

  8. #8
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Mornin' Hans,

    Just to bring you and everyone else up todate.

    I uninstalled MS Office 2003 SP3.
    I installed MS Office 2003
    I applied SP2 Update

    And ..... Had the same problem.

    So I reverted back to my usual solution, which I never seem to remember until I've gone through the full aggravation routine, and started a new form.

    Bingo! Old form was corrupted. How one uncorrupts an old form without the whole rebuild process is something that I'm unsure of.

    So, I was at fault and not necessarily the presence of SP3, although I still feel that it has an influence in turning what was a working form into garbage.
    Cheers,
    Andy

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SP3 Calculations (Access 2003)

    Good afternoon.

    I've never been able to "repair" a form once it has become corrupt. Recreating it from scratch is the only dependable method that I know of.

  10. #10
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Hans,

    That was also my feeling. In actual fact, when I started the new form, I was able to "copy in" 90% of the corrupted one without a problem. I kept saving a "newer" version after each partial addition. I eventually got to the point where the only thing I had to do was create new calculation fields that I had caused me the problem in the first place.
    Cheers,
    Andy

  11. #11
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Hans,

    Another day, another wrinkle!

    I was quietly entering my little formulas ( =Sum(Abs([gco - Status]=1)) , etc.) like a happy little programmer and saving after every couple of entries, until I entered . . .

    =Sum(IIf([GCO - Status]=2 And [GCO - Student]=11,1,0)))

    And behold, nothing but ERROR in ALL of my calculated fields.

    There was no format warning, just wall to wall ERROR. Where, in you opinion, did I screw up this time,
    Cheers,
    Andy

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SP3 Calculations (Access 2003)

    You have two opening parentheses and three closing parentheses.

    Try

    =Abs(Sum([GCO - Status]=2 And [GCO - Student]=11))

  13. #13
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Hans,

    Correct observation re parentheses. That was a typo. I did try my original formula again with the correct parentheses and it crashed.

    And I cut and pasted your =Abs formula . . . and it crashed!

    I created a new text box just to make sure my original one wasn't "funny", with the same crashing results using the =Abs formula.

    Very strange.
    Cheers,
    Andy

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SP3 Calculations (Access 2003)

    There's no way I can offer further help without seeing the database.

  15. #15
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP3 Calculations (Access 2003)

    Do you have any conditional formatting going on here?

    There was also an issue with calculated controls in continuous forms with Access2003 IIRC (though it was supposed to have been fixed by the Service Packs)

    Just a couple of SWAGs...
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •