Recent content by jberry7285

Once again many thanks! Yu must dabble more than me Allan! And for the next part.......dont worry Allan, i will keep you busy for a few weeks!! The Command button that says yes/no Is there a way of displaying the result (yes or no) into the DB table? So when reports are done etc the Pallet...

Many Thanks once again. It wias confusing me because i was looking for the 10% and couldnt see it - didnt realise it was entered as a 0.01%!! All works fine now - Thank You! As you can probably grasp by now im not an Access Expert but trying my best! lol Heres another one for you... Is...

Where in the VB coding of the form you supplied can i change the percentage values? for example - if % of Major needs to be 1% rather than 4% and Minor 5% and Unacceptabel 5%? Regards Jon

Hi all, Can you tell me how to change the resolution of a form to fit a hand held device. I have created on my PC, when i access the DB via RDC on the handheld device it opens fine but is in a very small screen res. Is there a simple way to make the fields in the DB fit the screen size of...

Spot on! Perfect! Many many thanks for your help guys! Much appreciated! im sure ill be back on here with some more questions as the development of the db continues... thanks again Jon

maybe you need to attach it in a zip file?

Hi Poppa Smurf, I Cannot open the Db, I get this error (see attached) I have saved it locally and tried to open it but i get the same error. Regards Jon

Sorry!! I see how you have done it now! Thats great! Now for an extra bit.... If Major % is over 4% = NO (this works great) If Minor % is over 10% = NO If Major + Minor combined are over 10% = NO If Unacceptable has any value = NO Many thanks for your help much appreciated...

Hi Psmurf What you have wrote is the coding i need but when i extract the db from the zip file it doesnt work? the number of nets x cases checked calc works but none of the %? Are you sure you've uploaded the saved version? Regs Jon

Many thanks for your help Psmurf....But... The code you have written does not work It calculates number of nets x cases checked but brings nothing through into the percetage field or the command button. Any ideas.... Regards Jon

Morning all, I have created a "log on" screen form my DB - how can i display the "log on name" entered in the "log on page" on another page. For e.g If i entered "JB" as my log in name - I want the inintials "JB" to be automatically displayed on other forms within the DB? Any help...

Morning Damo, I have attached the form - i have took everything out of it apart from the relevant section i need the calcualtions on. Hence various errors now come up!! But still you get the idea! The calulations i need coding in are as follows: Calculations: Number of Nets * Cases...

Many Thanks Damo, Late afternoon on a Friday not the time to start this.....im done with VB for today!! Ill reply to this thread on monday to continue this many thanks for you help much appreciated! Jon

Hi Damo, can we pick this up on Monday?

Many thanks for your reply, I have tried to zip it down taking pretty much everything out of it but it stil is too big for this sites limit of 2MB If maybe you have the time, you could just write me the relevant code an an example DB? Many thanks for you help Regs Jon