Search results

although i have stopped the navigation form from being accessed i can still right click on the main form and it will say "design view" how can i stopped that from being seen thanks steve

thanks , all ok , i was worried then

the 2 screen shots below open up in sql . yet the last 2 screen shots dont . any idea why and does it make any difference ? thanks steve

thank you , that works great . each line has an order for a part ( assembly) with a date for when it is going to be completed , each assembly has a bill of materials . the system looks at all the parts for the next month and collates all the materials to purchase . these materials are...

if its the wrong record , they would have to tell admin who then could hopefully undo it in the table ? unless we could password it to unlock it ?

i have a tick box on each order line when i have ordered the parts i tick the parts ordered box . how can i prevent anyone from removing the tick. thanks steve

Pat i have managed to do the query and it works but i need to only work if the field = ordered in the "supplier p/o details " form thanks steve

i am not sure if i should use another post or not but now the people using this database seen the amount of time it saves them after looking at the modifications Arnelgp did on the database he attached on his Post .they have asked if the same thing can be done on the form called " purchasing...

thanks to all of you arnelgp is working great , saved a lot of time steve

hi , i cannot open it

hi . i think i have done what you said but i am getting error messages the query is called material details 91 days not purchased ( append query} the orginal query before appending it is copy odf material details 91 days not purchased the form is called frm91daysnotpurchased of which is where...

Pat, this is the sql i use as i also use it for other information and the form only uses part of it as you can see the yellow field is only an a check for the operator to see what the allocation would be after running this query . although it is not needed . it is just , the reqdqty being...

if i press the top button i get the first error if i press the second button i get the second error

THE form below shows the items from a product that done need to be purchased because there is enough in stock . but this form allows me to update the allocation for that part . so for example the reqqty for stock number 3096B0010 for this product is 68.8 therefore when i press the update...

Thank you

Having never used a continous from before i am a little confused as to why my vertical scroll bar in not being seen in my subform { the one with the 4 line items ) yet my horisontal one is yet the are both set to be shown as they are in the design view steve

there are 2500 products on an old database and each product has stockparts attached to it. the total number of stock parts is say 10000 . i have transfer say 100 products to a new database and 625 stockitems to fullfill the requirements for them products if i need to use a new product on the...

i have 2 tables one called stocklist and another called stocknumber of which the stocknumber table could vary with data what i want to do is copy data into the table called stocknumber and then do a query that will tell me the stock numbers that are not in the table called stocklist but...

yes , i dont want them going to purchasing, stores, quality , finance forms , etc, but if each computer had say the same 40 forms on them is that slower than having there own say 12 forms on them ?

the issue is i really would prefer them not to be able to go to any other form/forms that dont relate to them thats why i closed the navigation pane off. each department is pass worded i just did not know if you had a form with a few navigation forms on the same form it slowed it down or...