Search results

  1. C

    Calculate Profit margin and place in table as %

    Greg, That worked perfectly, However, it is readin 0.25%...is there a way I could have it read just 25%???
  2. C

    Calculate Profit margin and place in table as %

    Number/Long Integer
  3. C

    Calculate Profit margin and place in table as %

    I am trying to use the code below to determine profit margin, However, I want the sum to show as a percent in the table and Form. Please Help! Me.Margin = (Me.Quote_Amount - Me.Cost) / Me.Cost / 100 This is returning a "0" in the field
  4. C

    If 2 conditions are met, then change field, if one of those is not met, Then leave.

    sorry, Im new to the forum
  5. C

    If 2 conditions are met, then change field, if one of those is not met, Then leave.

    Thanks a bunch to both of you, Worked perfectly!!!!
  6. C

    If 2 conditions are met, then change field, if one of those is not met, Then leave.

    I am trying to make sure 2 conditions are met before changing the field. If one of those conditions is NOT met, Then I want the fields to be left alone. Here is my beginner, Feable attempt at doing this: Private Sub Quote_Amount_AfterUpdate() If Me.Quote_Amount.Value > 0 & Me.Job_Number.Value...
  7. C

    If Statement - when condtions are not met, then leave field alone

    Expected":)"
  8. C

    If Statement - when condtions are not met, then leave field alone

    Private Sub Quote_Amount_AfterUpdate() If (Me.Quote_Amount.Value > 0 ,If (Me.Job_Number.Value = 0,)) Then Me.Date_Bid_Sent = Now() Me.Status.Value = "Have Pricing" Else Me.Date_Bid_Sent = 0 End If End Sub This is still saying Compile Error Expected:) at the , I appreciate all...
  9. C

    If Statement - when condtions are not met, then leave field alone

    Rainy, I looked to quickly at the code, and missed the second IF...Sorry (I thought it was the same code I sent you)...My Bad! However, I am now getting a syntax error on this line: If Me.Quote_Amount.Value > 0 ,If Me.Job_Number.Value = 0, Then Me.Date_Bid_Sent = Now() Me.Status.Value =...
  10. C

    If Statement - when condtions are not met, then leave field alone

    I am VERY new at coding. Could you give me an example of what you are saying???
  11. C

    If Statement - when condtions are not met, then leave field alone

    I am trying to make sure 2 conditions are met before changing the field. If one of those conditions is NOT met, Then I want the fields to be left alone. Here is my beginner, Feable attempt at doing this: Private Sub Quote_Amount_AfterUpdate() If Me.Quote_Amount.Value > 0 & Me.Job_Number.Value...
  12. C

    double click on data sheet form and go to specific record in a form

    Thank you sooooooo much! it took me to the syntax problem and made it work perfectly!!!!
  13. C

    double click on data sheet form and go to specific record in a form

    I am new to Access, and am trying to go from a datasheet that is based on a query to a form that is based on a table. I want it to pull up the specific line I am double clicking on in the datasheet. PLEASE HELP Here is the code I am using: Private Sub Form_DblClick(Cancel As Integer) On Error...
View older results
Back
Top Bottom