Search results

but i dont know how to get the old and new description in the report as my query shows all the records for all stock items and how it knows i have just changed that materail id only

I have attached part of the database that i am trying to get the report from if you look at the query you will see there is a material id 4804 which is being used in 6 product . if i change the description on the material id to say stainless steel. how can i create a report that says...

I believe I have everything you are all saying . And yes the name is only entered once in the peoples take . And yes the peoples name is entered many times in the task table .let's say name Fred was on 10 tasks But let's say after a week or so I discover I spelt it wrong ie freb or I...

I am confused. It you had a table with peoples names in that's one table If you wanted to select a group of people to do tasks them people would now be in 2 tables ? And if a certain person was selected to do many tasks his or her name would be in a table many times? Or I am missing something?

Yes in 2 tables Stock list and product details The stock list Carrys All Items to purchase even non product related parts like pens. Paper paint etc The product detail table Carrys All the parts related to products that was selected from the stock list table

But, even though data is only changed in one place, the effects of that change can be seen in multiple places. Are you trying to capture that in the audit log also Yes that change will be in the stock list table and several places in the product details table. As it is related to the products...

i am only changing the description in the stocklist file. the stock item is then selected and placed into the product details , table i have used the drop down box ready to add another part to that product this comes from the stocklist

i do have a report that shows me which products use that stockid and it is a requirement that we have a full log on all the changes we do on a product. even the text change. add parts , delete parts etc but i need to then run a report that shows you what products that stockID got changed...

how would you trigger that that part has been changed in the say in the stocklist table ( which automatically changes the part in the product details table as you can see line 2 part is used in product id 36,19,103, 43,22,23,30 so for example if i change the description of the part in...

hi , the form below shows that i have 129 different products that contain parts taken from the stocklist. the product below shows there are 21 items to produce that product . if we take line 1 for example it has a stock number 7505048-01 . this stocknumber could also be used in other products...

hi this macro is what sends my report to others but the view is not good this macro views the report of which is correct when looking at it how can i get the report i send to show it in report view thanks steve

i have a stock list and in the stocklist they have been putting words in that just suits them , then from the stocklist they created BOMS from that stocklist each bom is for an assembles part let says 20 stock items per assembly at this time the database that i along with everyones help...

MaterialPUR Insulation board for EC4272M2 with recess for terminal head(Dwg TBC) Film mPP 11.7 µm x 62.5 mm DEM 2.5 - High Isotactic - dwg 9504 Film pPP 9µm x 35mm PPDC (W Room ) just to put you in the picture this company uses excel and word for all there systems and i have been...

the text is short text , can we show the words that i mentioned if they are not in quotes ? steve

when he has finished entering any of the words in that field is ok

sorry i have mislead you, the words that i want to highlight is the words that i have put in quotes these are the words he could type into the sentence . not that he is modifying the sentence

i have a table called stocklist and within that table i have a field called Materialpur. if possbile i would like a message to appear if the user uses certain words within a sentence for example he could and is doing tying words in like 1. FILM to be in the "w room" 2 CAN to be...

Thank you. works great ,

I put this is my query "Not Like "*dwg*" and it works fine and dont return any records with that word in. but i have now discovered there are other records with the word "tbc" in . i have tried to add "Not Like "*tbc*" also to the same field in the query so i get no records with any of...

on the form below i used a table with the "*" and the drop down box " find batch number works ok , i have now tried to use the query without the "*" and the drop down box did not work i have tried to add another one drop down box and you can see i only get 2 option . if i change it back to...