Search results

  1. M

    AutoIncrement (by 10) at change in Field

    Hello, I have an issue that may or may not be an easy fix. Either way, I am at a loss and would appritiate ANY help!!!!! I import data from excel in order to cleane and format it to migrate it. One field is blank but needs to be auto numbered 10, 20, 30, etc at each change in Order number...
  2. M

    End Of Statement Error

    Hello All, I have an SQL statement behind a report that is giving me an "Expected; End of Statement Error". I can put the first part (blue) in a separate query and it runs fine. When I add the rest of the statement behind the report (Red), the errorr message selects "Yes". The report has a...
  3. M

    pie Chart Colors

    Hello, I have a chart that is, for the most part, working. Just one issue. I want to colors to remain constant. Ex: Yes = Red, No = Blue, N/A = Yellow. If there are no "YES" answers, "No" and "N/A" should remain blue and yellow. Is very anyway to assign chart points based on value? I...
  4. M

    Save changes when closing

    Hello All, I have a close button on my form that if the user has made changes, a message box pops up asking if they want to save the changes. That works fine. See below... Private Sub cmd_Close_Click() If (Me.Dirty = True) Then If MsgBox("Do you want to save your changes?", vbYesNo +...
Back
Top Bottom