Search results

this is the query that creates my subform you can see the stocklist cost which I will change I have now got the product cost in against the part how do I tell the query to only bring the records that are to the nearest to date1 and start date /enddate of the product cost I should only see 7...

hi thank you all for helping me , I have created a table called product cost as suggest in the last post and copied all the fields described , I have form "quote" and a subform called "order details subform" these are attached to a navigation form. in the quote form there is a date from when...

yes , I can have but if it is 20 £ today and 1 want to say sell for 20% profit £24 but next year it goes up 20% for the part so I put the cost in the stocklist form to 24£ and sell it for say 26£ if I look back at order "1" it will say I sold it for 24£ but the profit was zero as the...

hi , I have a form ( stocklist) that has stone sixes in it for example description = "2000*100*500 stone red sand" and part number is "srs215" and let say that parts cost 20£ when I select the part from the stocklist the part , description and cost populates into my orders form so...

thank you all ok now steve

hi I have 3 event procedure with 3 buttons to make them run I would like to create another button that can run all procedures togehter if I copy one of the procedures how do I tell it to run the other 2 thanks steve

thank you now working

hi, i am going to use the autonumber as an order number but I want " SC2015 in front of it so i end up with " sc20151 , sc20152 but next year i want it to change the year SC201650 could you please explain how to put the sc2015 in my report without any input from the user i did try scyear()...

hi , forgive me as I am new to this VBA but where in my code would I put that information and do I need to delete anything steve

Hi the code below sends 3 reports to a folder that the vba creates if needed. I would like to change it so the 3 reports go to different folders and creates a folder with the customer name in each of the below folders if needed at present it looks table with one folder address is...

hi, I have a report that comes from a query. on the report I use the group function on a field called assemble part number and select no duplicates in the property field . so I don't get that part number on every line below that group when I print the report it gives me the assembly part...

allparts contains all items to make any assembly parts table contains parts to manufacture a complete item I have the table relation but it don't work for this query can I put the lookup I the report

HI , I have 3 tables 1. allparts 2 parts 3 assembly numbers I also have a query of which looks at these 3 tables. when I query a part from the assembly parts table it looks at the description in the allparts table against that part and allocates that description( this is ok the...

hi , I have a report that sums all my costs for work done or forecast to be done = sum([cost]) what I would like to do is also just sum the costs that are forecast to do I have a field called " completedtasks" that is a tick box ( yes/no) how can I ask it to sum the cost for all...

hi , I have a table called schedule maintainence in that table I have a "date" field is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintainence to be done. thanks steve

hi I managed to find the problem why it did not let change the assemble detail number when it was not a duplicate and still keep this field as no duplicates the "allow value list edit " was set to NO

hi , I must be confused I cannot allow duplicates , I cannot allow someone to create assembly part number 1111 , with 4 parts attached to it , then maybe 6 months later someone creates another BOM with 1111 with a different 4 parts attached to it steve

the table is indexed and with Yes (No Duplicates) and the field is not the PK

hi , if I remove the pk and just put no duplicates if will still not let me change it

ok for example I have to make a car wheel . the allparts table has all the parts in it to make any type of wheel and there is no duplicate part in it let say " 1111" , " 2222" " 3333" are in it then I want to make a wheel for "ford" the assemble number for that wheel is 1111...