Search results for query: *

Thanks jonherman, while I havnt seen the light its possable you've given me a glimmer, mabye a form showing equipment and a subform showing locations and quantities, so that in a form - part a ( no badge) will show subform which displays location x and location y and location z - however...

Thanks hneal98 Can I dissagree with you on one point badge is a company issued number which put on any peice of equipment having a serial number, which simplifies identification of that particular item( think barcode ). A particular item has only one badge number and one serial number and...

The simple answer is to attache it to the event that causes the change?, - but perhaps its a little bit more complicated than that?. A little bit more datail perhaps

Having problems with a Stock control and movment database. Im gaving trouble with the relationships between defining stock and their locations. I have at the moment Table 1 PartID Autonumber, primary key) ModelPartID (type of equipment, defined in further table) Badge Serial Status Table2...

looks good to me, I'll start poking the code in tomorrow, thanks for all your help

thanks remou I think its the rs.Addnew was the bit i was looking for, however a small correction, its not two tables Im updating, its one table with subsequent records. - or rather it is two tables but let me explain The movment of a part of a single part updates the record for that part as to...

thanks for your quick responce Now the only problem is to understand it ;( cheers

Any way of updating two records in a table from one form ? There may be a simple way but i just do'nt see it. As background I'm generating an audit movment trail for repair parts, each part is required to have a movment record ie receiving - stock - local store - workshop etc. However 99% of...