Recent content by timbl

Thank you very much for all your help, I'm getting there. Will post db when I think I have got it working satisfactorily. Thanks

I understand that I don't need cloth remaining on the cloth table etc. I've been trying to create a query that shows current cloth stock QryCLothStock It shows Remaining after cut which uses the module and the InitialRollAmount but it would be good to show the InitialRollAmount of cloth from an...

All seems to be working for now. Just got the issue of the Cloth remaining module reporting 0 when a new roll has not had anything cut from it. It would be handy to have that info on the FrmCloth form. Also Where would it be best to put the Requery command so that the records on the subform...

Thank you again. Did you look at the immediate window to see how the starting amount is adjusted for each useage of cloth? Not quite sure what was meant by this? I take on board your recommendation for removing the TotalUsed Calculated value. Also not creating entries for a new Cloth in the...

Many thanks for the help, I would not have known where to start with the module!! I have modified the module to work with my tables I as I want to carry on down that road as it seems to work perfectly for what we want. I do however have a couple of issues. 1. When I add a new Cloth using my...

Ah - yes we do. Any suggestions to what I have done to change that easily? I have been working on the form FrmUseage and it is pretty much there. It seems to work with the functionality I wanted. Its getting late here so I am stopping for now before my brain fries.

I have managed to put the fields from the query into my form but they are not updating when I add a new job or change the values in existing jobs. The values are correct when I close the form and reopen it but there is no "live" update. I have added a Refresh Button to manually refresh the form...

Thanks very much, I feel like I am getting somewhere now. I have changed your query "ClothUsedToDateAndRemainingByClothID" so that it uses my table "TblUseage" and it seems to work although it does not update straight away when I add a new job using my FrmUseage. How do I get the...

So I have created the DB with a couple of "rough and ready" forms and a query. In the query you will see a "RollingTot" calculated field, but it does not work like a running total, instead just a total for each cut job and does not take into account the quantity of cloth cut in previous jobs...

Thanks for your help. You seem to understand what is required but... As I said I am not a programmer and so would like to know from a technical point of view exactly how to do this. I can create tables and relationships etc but can not see how to create what is needed to calculate and show on a...

Not all rolls of cloth are the same width. Multiple rolls of different cloth could be used for a single job. A roll of cloth will be used for multiple jobs. It is primarily to be a cloth database to record the stock level and which job numbers the cloth was used for. All I'm trying to do is...

I have been battling with this for hours and made no headway. I anyone can help it would be most appreciated. I have attached the very basic db. Thanks

Okay, thanks I will not store totals in tables. How then do I calculate the values needed? What is meant by "You use the transactions to get totals."?

I Have my tables already defined... tblCloth ClothID BatchNo RollNo DelDate Supplier ClothName TblUseage UseageID ClothID RunningTotal JobNo AmountUsed AmountLost CutBy Created forms etc. I just don't know how to get the RunningTotal field to calculate and update after I enter the amount...

We are sailmakers and have stock of different rolls of fabric which is used to cut for new sails. All I want to do is to create a database to record the amount of cloth cut for each job and to keep a record of the amount used and the amount left on each roll. No need for anything else such as...