Recent content by joe90

Thankyou for your reply. Much Appreciated I have created the tables and relationships you suggested but am a bit confused as to how it works. I have taken the liberty of sending you what I have done so far for you to see if I have understood correctly. I am starting to see how complex this...

ty boro for your input... I am asking a question. its no big deal...its not like if i dont fully learn how to manipulate access to fulfill my expectations I lose my job or anything,... this is something I have set myself to do......so thankyou anyway...but softly surely will be nice. not...

Thank you again for the speedy reply. I'm going to have a little play... I will post a reply..

Thank you for your response.. What would you suggest? as in table structure, and field names for tables. I really appreciate your help.. Jo

Hi Neil, I have been reading many of yor replies and they have been very helpful, so firstly thank you for your kindness. Its very nice. I posted a thread and thought it would be great if you personally could help me. I think I have bitten a little more than I can chew with this one...

Firstly can I thank you for reading this and helping in anyway you can. I have 2 tables (below), I am trying to find the best/correct way to return the desired results. I work for a small printers . I have been set a task to create (what I thought would be relatively simple) a database that...

Hi, I am trying to simplify a working process and would appreciate any help or light you could shed.. here goes... I work in the print trade, and with all new regulations and stuff I have been asked to record all paper usage that holds an FSC logo! (which is basically trees from managed forests)...

Hi, Kindest thanks in advance for any help you can give. I am trying to display the results of a query in a report that depends on a value I have entered into a form. Any help is muh appreciated Jo x

Hi, I am trying to establish how to overcome this problem. I have 4 fields in my Table: DT (Date/Time) Machine1StartFigure Machine1EndFigure Shift I am trying to use the data last entered into 'Machine1EndFigure' as a new value in the next records 'Machine1StartFigure'. So that when a...

Hi again I am having some trouble now which I hope you can help me with. For some reason the function has stopped working, This is the only code I have. Private Sub Form_Current() Dim LastShift As Date If Me.NewRecord Then Me.DT = Now If RecordsetClone.RecordCount = 0 Then...

Ive sorted the shift bit now. But on to the next problem you may be able to point me in the right direction with. I would like a total count for each machine to be displayed in the form and also update the table for each machine. So basically after I put in a value into lets say "M1EndFigure", I...

Hi Again, Well on the way now to finishing, But again I need your expertise if you don't mind? Firstly I would like for each shift to have there own form, rather than having to manually select 'Shift1,Shift2 or Shift3 from a drop down on a single form. Basically so that when I open for instance...

Top Banana, works a treat should of tried that really before I asked for your help again. I tried putting the whole code in for each machine rather than list it like above. Thankyou so much for all your help, I would not of been able to do it without you. Joe

Hi Again You probably guessed it wouldn't be long before I ask the next question. What you gave me worked well but after having a play with it all I soon realised that it works fine, but I have more than one machine. And from there on I've been scratching my head again. So whereas my first...

Done Exactly as you said and it only ****king works. Thankyou so much. I really don't know how to thank you enough, I can now get on with this little task I set myself, one I thought would be relatively easy. lol. You've obviously given it some thought and helped me for nothing other than...