Search results

Thank you for all the replies, I appreciate it. My database is a packaging database, with each package getting a unique ID and 10 items scanned into each package against the ID. Even if you close the database midway through an order it will resume where it left off. I have no idea how the user...

I will, I am over thinking it. Thanks.

Hi, I am back again looking for some help. Never encountered this before but have a new user that opened my database(accde) 10 times, and it made a bit of a mess of the data entry(nothing major and fixable). I would like to prevent this happening again. I have been trialing bits of code all...

I think I may be good. Found a rogue setFocus event in my code which I think caused my initial problem.

Thanks for all the responses. I probably have made a bit of an abomination of it. I am trying to have all the data entry by a barcode scanner. My aim was when the order was set to shipped, the person doing the packing would have the labels for the next order at hand and all they would have only...

Hi, Looking for some guidance as I am not really sure how to handle this. I have an event on my form with a loop, and I nearly have everything perfect (well in my eyes J ). I am not sure how to refresh/reload my form from within my code. The code below is what I would deem a successful event. '...

Thank you all for the replies and enlightenment on how to code more productively. I will take your suggestions on board.

Thanks CJ and Gasman for the responses. I think I am good. I have the following code which seems to be working. Never normally put an event of a form so wouldn't have thought about it. I will update the post later. Thanks again. Private Sub Form_Current() 'MsgBox Me.txtCount.Value...

Morning, Thanks for getting back to me. Tied that but it didn't work. Even changed the code to the following, but noting happens. Private Sub Form_AfterUpdate() MsgBox "Test message" Debug.Print "Packed Count: " & Me.txtCount.Value Debug.Print "Order Total: " & Me.txtQtyTray.Value...

Hi I am hoping someone can help as I seem to be stuck. I have the database 90% of the way to where I want it but I am stuck on some VBA that I want to trigger when 2 controls on the form are equal (outlined in red in the attached image). When these 2 controls are equal I want to change a field...

Thanks arnelgp that was it. Not the first time that has caught me. But I was looking up the wrong field ! I have been looking at this for too long! Don't know my left from my right at this stage :) Anyway I got sorted, and the code is doing what I need. Thanks again for all your help...

I am back again! The code above in post 8 works perfectly when there is a match, but when there is not a match is still highlights one of the rows which can lead to a user error. Tried the IF statements but no joy, so went down the Recordset route, which I am stuck on. Am I missing something...

I have 2 more questions I hope some one can help with? I now have an event on a combobox that takes in a BoxID and highlights MasterASN field on the corresponding row in the subform. (Borrowed arnelgp's code from another post :) ). I tried to write an if statement around the code below, i.e. if...

Thanks Arnelgp that is a great help.

Thanks for all your replies. I appreciate it. June7 The master Child links are set with the Part Number. I will attach the DB. There is noting confidential in it, just mock data. Apologies it is rough and ready. Pat I had thought of adding this flag you suggested. While there isn’t a field to...

Hi, Just wondering if I am going the right way about this and if someone could point me in the right direction? I have a main form and subform. The main form shows the master quantity e.g. 80 and then the subform shows the individual boxes of 8. Can I get the subform to filter to show only 10...

Thanks for the additional information, good to know how to test for again.

Thanks for all the quick responses. @Minty I had tried that but it didn't work. @Josef P. Thank you your code, it works. @The_Doc_Man You are correct warnings are disabled (I do an insert into table ). I like the idea of the case but it didn't work for me. I think the reason that Mintys and...

I am really stuck and can't find an answer for this and would appreciate some guidance. I have a field in a form txtQtyTray and if I have a numeric value in that field my VBA code below works. If Me.txtQtyTray.Value = Me.txtCount.Value Then MsgBox "Full " & Me.txtQtyTray & " is equal to " &...

Thanks again for all the suggestions, tried them all and they all worked as expected. Now I am spoilt for choice!