Recent content by nekkev4
-
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... -
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... -
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... -
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...