Search results

  1. A

    Stop subform creating blank record

    Hi there, I'd suggest you to set the Allow Additions = No property in Form | Data in that way, you'll be free from blank new record :-)
  2. A

    Active Page on Tab-Control

    where is it in the archive ? I need to know the current active tab page so that I can enable a specific button in the form. (if the user opens the Letter tab, the delete letter button will become active) any idea ?
  3. A

    ComboBox to CheckBox

    Thanks for your quick reply Rich, what I'm about to do is to replace the ComboBox with CheckBox to display the data as well (in a Maintenance screen). is that possible ?
  4. A

    ComboBox to CheckBox

    Dear All fellow members, I'd like to know how a checkbox can be set according to the query result ( Y / N only) ? I've tried to use any different approach but seems endded up with "You cannot sign a value to this object" error. I can do it with combo box but Its not suitable I think for...
  5. A

    Buttons

    any idea of why I get "TheRunCommand action was canceled" error message when deleting a record ?
  6. A

    Delete Error - TheRunCommand action was canceled

    I got an error message in deleting some rows in Access 2003. I don't know why this could be happened to me ? but in some rows it works fine deleting the rows. Here's my Delete Button code: Private Sub btnDeleteLocation_Click() On Error GoTo Err_btnDeleteLocation_Click If MsgBox("Are...
  7. A

    Conditionally saving a record

    Hi mate !, you're procedure looks great with the Screen.ActiveControl.Value thingy, but when I apply it on my code, your procedure isn't working or conflicting with my close button code which is: any idea ?
  8. A

    Delete confirmation button ?

    yes, but doesn't give us what the exact position of our cursor at the moment eg. when our current mouse cursor is clicking in "Item X", it should says that Item X is about to be deleted. any idea ?
  9. A

    Delete confirmation button ?

    Hi everyone, I'd like to ask a question in regards to Deletion message. how to display the warning to user about currently selected row in a continuous form ? for example: my mouse is now "clicking" on top of "Item x" textbox, when the user click delete button, how to display in the...
  10. A

    Delete Record and Close Form

    Uhm... do you mean like this ? If Me.Dirty = True Then Me.Undo Cancel = True End If DoCmd.Close acForm, Me.Name
Back
Top Bottom