Search results

HI, Not sure if this is possible but i would like to enter a "qty reqd" "ie 6 as highlighted in line one In the orders table and it would update the "on order qty " in the stocklist table .. ie from 1 to 7 thanks steve

did you hit the same problem as what i am getting ? i did an compact and repair and it still had the same problem

the problem happens when i am in the "purchasing form" and on the tab " supplier purchase orders " and i press the open qoute or open order buttons it never used to happen until the last couple of days now it does it most the time steve

hi , i have been developing a database for about 3 months now of which is only located on my laptop. i though i just about finished it when for some reason. when i test it it closes down and either gives me a backup or closes done and goes into record locking and even when i close my laptop...

this is the sales order for 1000 parts of the product i mention earlier which at this time calls up for 20 items from the BOM I then run a query which tells me how many parts there are and what the quantites are from this i then run an append query to tell me all the parts that need to...

i have hit a problem and i am not sure how to get out of it below is a parts list for a product called.DC4573M1 this is a capacitor. if an order arrives for one of these i run a query that looks at the stock for these items and if any need ordering it will show me the problem i have hit is...

thank you. all working ok just for info , only one person will have access to purchasing

the form below lets me select consumables to purchase with ticking the purchase field and pressing the button called " purchase consumables " what i need to be able to do is remove the ticks after the parts have been moved to the order form at the same time. is that possible thanks steve

Thank you. it was Transparent. now works steve

hi , i have put a conditional format on the field "ordered" to highlight it when the field say " waiting to order " see below . what i dont understand why it dont turn yellow until i select that field on the report this time my cursor is on the field before it turned yellow thanks steve

i managed to get snippest from posts on here and managed to do it like this thanks for your help steve Private Sub cmdEmailCustomer_Click() Dim strTo As String Dim strSubject As String Dim strMessageText As String Me.Dirty = False strTo = Me.[E-Mail address1]...

this shows the firstname in the suppliers table and the NCR detailsi would send

i would like to be able to put the suppliers contact name in this macro but i dont know where to locate ir i would to be able to say for example "paul" please find attached NCR thanks steve

is it possible to hightlight the data that is less than 0 for example in the qtyoutstanding field i have 5 results that i would like to highlight thanks steve

When i run the append query i get a message telling me i am about to run the query and then another one telling me how many lines will append is it possible to stop them messages for that query thanks steve

hi Pat , i already have but i have just been doing the reports for sales and purchasing and hit a problem see table with all the names in and the rows ID in it. so in my combo boxes , i ust the ID to ref the to that form /reports and each list shows as required to select from now please see...

it undone it all and started again and yes there was errors, ie i did use a numeric field (stupid mistake) and wen i followed Gasman and Pats instructions all worked great i want to thank you all for helping me steve

i have tried to change the data as you suggested but i only get numbers as shown below i even tried the wizard to do it but again it only shows me numbers thanks for your help steve

i did try this but it just shows me numbers not names query in dropdown box shows this but the drop box shows numbers not names so dont know how to get the names thanks steve

this is the table with the people in it i have assigned a code to to see if can get it to work rather than create 3 tables to ref them employees this sales form has a drop down box that at present just looks at list box with thier names in it as does the second form and third form which is...