Recent content by chnj

  1. C

    Catch an action on subform

    Private Sub Form_BeforeUpdate(Cancel As Integer) Forms![Main Form]![Sub form].Form.Form_AfterDelConfirm (Status) Forms![Main Form]![Sub form].Form.Form_BeforeUpdate (Cancel) End Sub This way it doesn't work. It doesn't show error either. Appreciate your help!
  2. C

    Catch an action on subform

    What would be the best way to call this from main form if it is intention to use it only from the main form and not from the subform?
  3. C

    Catch an action on subform

    Forms!FormName!ChildName.Form.Form_AfterDelConfirm(Status) Forms!FormName!ChildName.Form.Form_BeforeUpdate(Cancel) If this is the part of the procedure it will work in your opinion?
  4. C

    Catch an action on subform

    I understand first 2 steps, but could you explain the third step in more detail? How to put the quoted code - as it is or as a part of another piece of code?
  5. C

    VBA code to put backups into a folder named by a date

    Thank you MarkK! This works perfectly. I appreciate your help
  6. C

    VBA code to put backups into a folder named by a date

    I tried but it somehow keeps just appending the filename and giving me error that the path is wrong. Simply can't think of a way how to call that newly created directory
  7. C

    VBA code to put backups into a folder named by a date

    Sorry I did not understand what do you mean by that. It works now - just that it creates a folder and creates a backup next to the folder (and not in the folder like I need it). Also, if I open the database again and have the folder already created - error message pops up.
  8. C

    VBA code to put backups into a folder named by a date

    Done this way but it doesn't put the file into the TargetDir and if it happens that the dir already exists it gives me an error Function fMakeBackup() As Boolean Dim Source As String Dim Target As String Dim retval As Integer Source = CurrentDb.Name Set objFSO =...
  9. C

    VBA code to put backups into a folder named by a date

    I tried putting it like this but I get an error Compile error: Duplicate declaration in current scope and this part gets highlighted: Dim objFSO As Object In the original target path the last part "backenddb" is part of a file name. I still want that the files keep the same naming convention...
  10. C

    VBA code to put backups into a folder named by a date

    Hello, This is the code that makes the database to backup on open. Any idea how to make it to put files from a specific date (let's say Sep-06) into a folder called 2016-Sep-06? Function fMakeBackup() As Boolean Dim Source As String Dim Target As String Dim retval As Integer...
See more
Back
Top Bottom