Recent content by Berkeleygerrell

Perfect thanks , that did the trick

Hi Arnel I have just tried this, no joy unfortunately

Perfect thanks CJ This seems to be working however i have to close and re open the form for this to take effect, is there an additional code i can add to the button to make the form refresh ?

Hi All, I am struggling to get an image to show based on the value of a check box, im trying to get the image of the approved stamp / Declined stamp to show based on the value of the check boxes below the buttons, Currently the vba code im am using is this Where commands are the approve/...

Thanks CJ, im almost there, one final question (i hope). If i want the buttons on my main menu to open the particular form would this be correct as i am getting a peramiter issue

Also thirdly can i use the reasons / shifts / part number as the PK?

Thank you CJ really appreciate this, A couple more questions, firstly in this lay out how would i split the shifts by machine? (index 1 and index 2) so i can show both of these at the same time ? secondly the actual list of failure modes is considerable longer, please see attached. Is...

Hi CJ, Thanks for your help so far, I have manage to delete most of the forms to bring the file size right down so i have been able to attach now, Could you quickly explain the layout of the sub forms that i would have to use ?

Hi CJ, Unfortunately i dont think i will be able to run it quite like that as i am trying to create a live running screen where i can click on the blue box for scrap and rework and it increments by one, please see attached screenshot , unfortunately the access file is too big to attach.

Thanks for all your help so far CJ_london, I wonder if you can help with part 2 of this. I managed to get this working via means of macro, however i now how the longest table in the world, I am hoping to be dramatically reduce the number of columns that i have now by making forms...

Hi CJ_London Thank you for this, I have now changed my attack. one question for you is there a method of having a button that when opening a form it will automatic create a record with that date, and then if you were to reopen that form it would search to see if a record existed with that...

Hello All I am brand new to the forum and hoping one of you can help. I am currently in the process of creating a rudimentary NCR database and I am struggling to do a couple of things, hopefully you can shed some light. I have attached the database for you guys to have a look at. there are 3...