Thread Dissapeared? (Access Lounge)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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, “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)

Reply | Quote

Sorry, Steve, but the Calculated Field 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?

Reply | Quote