Multiple User Access to Same Record Issues?

[darkstar257]

I have created a unit converter and I have a text boxes that output weight or length based on the calculation below. However, sometimes the text boxes won't display the calculated value despite clicking on the solve button. Could it be an issue with multiple users writing to the same record at the same time? How can I prevent this? I intended for this to be a single record form.

I tried changing the Weight and Length variables to custom properties as shown here:
http://msaccesstips.com/2009/11/creating-using-form-custom-property/

How should I redesign this database to make it into a single record database yet not have multiple users editing the same record at the same time? These two things sounds conflicting no matter what! Would it solve the issue if I split it into a BE and FE?

Private Sub Solve_Click()
........
...
'Conversion Equations
        Select Case inputType
        'Case Statement ft^2/lb/mil -> [lb] / [ft]
            Case Is = "ft^2/lb/mil"
            'Solve for weight [lb]
            If outputType = "lb" Then
                Weight = Round((vsheet * widthTemp * Length / matFactor * (Thickness / 0.001)), 2)
                WeightUnit = "lb"
            ElseIf outputType = "ft" Then
            'Solve for length [ft]
                Length = Round((vsheet * matFactor * Weight / (Thickness / 0.001) / widthTemp), 2)
                LengthUnit = "ft"
            Else
                MsgBox ("Unknown Input Type")
            End If
            
 .....
....
        End Select
....
...

 

[DavidAtWork]

What are the various inputTypes or is "ft^2/lb/mil" the only valid value where a calculation is performed.
Also in your Private Sub Solve_Click you use several variables (or are they supposed to be text boxes on your form), are these declared globally with constant values, if not these variables won't have any values and these calculations will be zero or error if diving by a zero or null value. If they refer to text boxes, you need to reference the objects correctly
David