Search results

Hi all Attached is a copy of the database with the form present and working. However, i require two further combo boxes from two tables which i cannot get working for the life of me. :banghead: If i add in the wizard(yes im not able to quickly write the source *yet) then a: i lose the ability...

Further to my original post regarding multiple many to many relationships I have started a fresh and am relating my data to the customer/product/supplier/order model that most tutorials are based on. For the basics it fits my purpose, well, as far as I've got anyway and is helping me create the...

Thanks for the help on this guys. Thanks to your comments I believe I have sorted this now by A: sorting out the relationships and including a multitude of transactional tables between my many to many relationships B: Moving certain fields into the transaction tables - I believe entity...

Firstly apologies if this is in the wrong place, I have a sub form with a combo box that selects from another table, if not in the list it gets added to the source table as follows: Private Sub Combo8_NotInList(NewData As String, Response As Integer) Dim strTmp As String 'Get...

Right, So we are a refrigeration company. Part of our work involves removal and addition of refrigerant gases to fridges/freezers etc into or from a cylinder. Under the regulations we have to log certain information and keep these records. At present this is just filled in folders with excel...

I did say it had been along time (6th form 15 years ago) Thanks for the pointers Having a read online(prob not the best tuts) most of the emphasis was breaking the data down as easier to bring back together, hence the web :( Thanks for the help. So for example: Cylinder_a could be picked up...

Current setup attached. So here is a quick breakdown: Collection note - collection of a or multiple cylinder/s from a supplier by an engineer (initial weight of contents discovered at this point) return note - return of a or multiple cylinder/s to a supplier by an engineer consignment note -...

I'll be home in hour so I'll post the database setup to show more. Thanks for looking guys and feedback. Most appreciated

A consignment note is for destruction of refrigerants as hazardous waste, 1 consignment note can transfer multiple cylinders each containing a weight of refrigerant present on the consignment note(this is where the weight is specific to a cylinder). Ie: Consignment note number: abc123 (pk)...

Hi all, a long time since I've used access but having to build a database to store our company refrigerant logs and whilst I have the majority suss'd im struggling in one area which I hope somebody can shed some light because my brain is going into meltdown. The purpose of the database is to...