Search results

i know access to a point, but have never tried to create this kind of database. ill give a brief run down of "the business". we manufacture aluminum windows and doors 1)an order is received from a customer. 2)it is booked in and given a job number 3)our lead time is always approx 4 - 6 weeks...

Hi All we use excel to run a small manufacturing factory. it works OK, but is not at all clever or fancy. it would be magic to have it in access to be able to change things quickly / run reports etc. attached is a PDF of the excel sheet. left columns are job number and customer/job details...

ive added a VERY rough screen layout in the first post (Image) the database is wuite simple and works, other than trying to sort the plots and then plot details below that. i would like to be able to somehow list a range of plots ti show how many are on the order(at a later date make them...

Hello. Added more info in bottom Post - an image of what i am trying to do. - seems so simple - but i cant get it to work i am trying to create a database that logs all our orders... simple !! other than i want to be able to click on the order and it shows all the details of the order. under...

thanks for that - i get what they are saying, but its a little beyond my capabilities at the moment. i'm learning as i create...:confused: i used to use access 95 !! loads, but have only recently started using access 07

yeah sorry it is a bit vague - - makes perfect sense to me :p ill post some details later or tomoz if ok - not in office at the moment. many thanks. p.s - boxes will be same size approx 8mm square (big enough for a manual tick) basically it is getting access to print 1 x box for each item on...

thanks for reply the number of boxes will be supplied by a number in a field in the orders table eg. Qtyframes this could be up to about 80 per order line but there could be 4 or more lines of product type - so from 0 - 80 on each line windows doors curtainwall ancillaries

i wish to produce a delivery note which needs to print an empty box for manually ticking. i need a box for each item quantity i.e 5 items on the job print 5 boxes. 20 items print 20 boxes. i have been able to use very crude code if there is only a few items, using if qty =1 then / 1/ else if qty...

These forums are great - i hope to learn and give some great knowledge