Search results

  1. N

    Create a custom Forms collection object

    Oops I guess I didn't think about it hard enough. For any one interested. Private Sub chkAllowEdits_AfterUpdate() Dim colForms As Collection Dim frmForm As Form 'Create a collection Set colForms = New Collection colForms.Add Me colForms.Add Me.subForm1.Form...
  2. N

    Create a custom Forms collection object

    Create a custom Forms collection object [SOLVED] Hi, I am trying to prevent code duplication such as: With Me.subForm1.Form .AllowAdditions = False .AllowDeletions = False .AllowEdits = False End With With Me.subForm2.Form .AllowAdditions = False .AllowDeletions = False...
  3. N

    DB design dilemma - "double" one to one relationship

    Re: DB design dilemma - "double" one to one relationship - SOLVED Yes thanks to both of you. I have put into a zip folder a very small db with working relations for anyone interested. So basically in the same way : A printer is compatible with many cartridges and a cartridge is compatible...
  4. N

    DB design dilemma - "double" one to one relationship

    Hi everyone. I'm working on a database and I've hit a difficulty I can't seem to get passed. Here is the current design: tblPrinter PrinterID ArticleID ModelName tblCartridges CartridgeID ArticleID lkPrinterCartridgeCompatibilities (Link table) PrinterCartridgeCompatibilityID PrinterID...
Back
Top Bottom