Recent content by datsun100a

Basically to record all items to make product X I made a form with all the items available. Those items are serialized and you can only use them once. Once you have selected all your items I want to make all the items which have been used to make product X unavailable, to do this the form...

I am trying to change records in several tables. I have several tables for products as they could have the same serial number, when an item is used in an assembly I do not want to be able to select it again in another so I have a field for availability and want to set it to 'no' when it has been...

I want to update several record entrys in a access sql statement but as I am not an expert, I don't know the correct syntax. Basically I want to update a record then another then another etc within the same statement.. if possible. I have tried THEN or / to seperate the update statement but no luck.

thanks for the help, I new it would be simple.

I have written an sql update query but do not want access to tell me it is going to change x amount of records. I can't seem to remember if these prompts can be turned off.

When using applications accross a windows nt network, file transfer is very fast on both 95 and nt machines but on new dell 8100 series machine with nt 4, files transfer fast but applications run very slow. Anyone have an idea on this one!