Search results

Hi Simon, Sorry I have been distracted by an Excel project this week. Thank you for your answer. I do just have a couple of questions, given the 3 tables below as suggested, how would I illustrate the relationships between Primary Suppliers, Secondary Suppliers, Packhouses & Growers...

Hi Wm. It is basically a chain of contact. Me > Primary Supplier > Secondary Supplier > Packhouse > Grower. In your second paragraph, you have hit the nail right smack bang on the head. Thus my logic of a Junction table. I suspect the only option might be to force all Primary Suppliers to...

Hi Simon, Thank you for that, but I think if I have understood what you are suggesting correctly, I would end up with an awful lot of duplicate data. My response to wmphoto below might change things slightly. Thank you Rowan

Hi All, Im hoping you might be able to help, as I have a bit of a dilemma and I'm not sure of the best way forwards. I have the following tables: Tbl_PrimarySupplier - PK SupplierPrefix Tbl_Secondary Supplier - PK SecondarySupplierID Tbl_Packhouse - PK PackhouseID Tbl_Farms - PK...

Hi David, Thank you for your help, I haven't done any coding for a long time so I am struggling here. The checkbox is called: chkDetection and the subform is called: Residue Analyses Subform. If i use this code: Residue_Analyses_Subform.Visible = me.chkDetection Should this work...

Hi All, I need some help. I have a main form with a single subform. I want to enable / disable (and make invisible) that subform using a check-box on the main form. That I can do - Using the Current category on the MainForm and the AfterUpdate category on the Check-box. My problem is, that...

Hi Gents, Apologies for not coming back to you, how rude, I completely forgot I had posted! The database was actually put on hold briefly but I am back working on it now. Thank you for the tips, I have disposed of the checkbox and will be using a query / report to highlight expired audits to...

Hi guys, First post to the forum, I have just started developing a database for work, and its been about 5 years since i've even touched the program. I need some incredibly basic help ha! I want to Auto-Check a CheckBox when an audit expires. I have the controls: ExpiryDate (Date), Expired...