Search results

THIS!!!!!! :D Thank you!!!

I think my best bet for what i need a Sum of weights. A typical shift will produce no more than 10 Bales.... and no more than 1 parts. So a product field for them to choose the given product = Cotton and 10 fields for them to enter each weight. They may only produce 8 Bales so 8 figures...

You raise a very good point, i have not used Combo box as its not something i knew about, i haven't had any training on this so everything i know if from playing with it. I shall have a play with the combo box.

Hi Arnelgp, Really sorry to ask what you may think simple. So i have put an unbound Field on the Form Footer Right hand click and head over to expression builder. I have no experience with the expression categories or expression values :( I find the record source in expression values but am...

Hi All, Thank you for your replies, my knowledge isn't great on Access, so i would imagine there are simpler ways of doing what i have done, but basically how it works is i have a Table which contains a product field, and next to this field i will have 10 other fields for the user to enter...

Hello Ladies and Gents.. Quick question, i hope somebody can help. I have a Form and have multiple values being entered, i have a report which uses the below in a text box and works well for me. =Sum([Part Weight -1]+[Part Weight-2]+[Part Weight]+[Part Weight-3]) to give a total. These same...

Hi Grumm, This worked perfect for me, my program isn't intended to be a large scale thing, only 4 people will be using it to enter in shift data so this method saves me a lot of hassle. thank you very much.

:banghead: i don't even know why i didn't think of that. Of course i need to add my button names, really sorry. Thank you for this. i will hit the computer on my dinner break and hopefully have it working so i can get it up and running. Thank you

That's an amazing idea, i would never have thought to even look at something like that. So put the code in on the onload event and removing the password one, i have kept it all and replaced grumm with the windows username - Kay Private Sub Form_Load() Dim sUser As String sUser =...

Hi Grumm, This is most interesting, thank you very much, so i would assume that i would need some form of user login for the program?

Hello Ladies and Gents First allow me to say i have not had any training or study in this so i am very limited to what i know. My work places asked me to make something that our production would use as a program,so i took to Access and have done so. My problem is that i have my program...

Hello ladies and Gents. Little info about me, my names kieran and im 28 from Nottingham in the UK. I haven't had any Microsoft access training, no study no qualifications but the reason im here is being the youngest and more computer savvy person at my work place, i was tasked with making a...