Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thread Dissapeared? (Access Lounge)

    I made a post toward the end of last week to which Mark L replied. On Friday I responded to Marks post but it has now all gone? any ideas

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Thread Dissapeared? (Access Lounge)

    Dunno. What was the thread on? Could it have been a duplicate of another thread? We don't normally remove a thread entirely without PMing the poster and any respondents to let them know about it.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thread Dissapeared? (Access Lounge)

    Hi Charlotte,

    I can't remember the name of the thread but my basic post was that I had 4 fields on a form pieces, pieces1, pieces2 and pieces3. Pieces3 takes its value form the other 3 (pieces+pieces1+pieces2) I then wanted pieces3 to compare its total to another field TotalPieces. I had tried myself and come up with

    Private Sub Pieces3_Exit(Cancel As Integer)
    If [Pieces3] < [TotalPieces] Then MsgBox "You Have Entered The Wrong Number Of Pieces", vbOKOnly, "Miscount"
    If [Pieces3] > [TotalPieces] Then MsgBox "You Have Entered The Wrong Number Of Pieces", vbOKOnly, "Number Miscount"
    End Sub

    Which puts the error message up whether the calculation inputs too many, too few or the right amount of pieces.

    Mark replied to say he was not flaming but this was against general normalization rules to have pieces, pieces1 etc.

    I responded and said that I realised this but on a form I have, people need to calculate the dimensions of an assortment of packages where all the dimensions could differ, to allow for this I have made 3 lines on which they can calculate and store the value on the form. The 3 lines are Length, Width, Height, Pieces (then each followed by 1 Length1 etc, and then followed by 2 for the next line). This calculates the volume fine but I just need to make sure they have calculated it against the right number of pieces.

    I have searched all through but can't find the thread anywhere?

    Thanks

    Steve (PS. The pop up Lex is neat)
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Thread Dissapeared? (Access Lounge)

    Sorry, Steve, but the <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=81468&page=0 &view=collapsed&sb=5&o=186&fpart=>Calculated Field</A> thread comes closest to what you described. One of the other Mods rummaged around through the digests of all your posts and Mark's around that period, and we didn't come up with anything else that fits that description. Are you sure it was and Access thread?
    Charlotte

Posting Permissions

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