Search results

Could have sworn you said to try moving the focus? How do I use F8 to step through the code?

thanks for the idea which I have given a go but still no luck. I tried to setfocus immediately after the update (being the first line of the code before the If statement and also within the else part of the code although that was already setting the focus elsewhere). It must know that the...

I have a check box with the code below on the After Update event however not all of the code runs when the check box = False (unticked) I have placed message boxes to test to see which parts of the code are running and the odd thing is that the Else part does appear to run but it doesnt fire the...

Thanks I will give these a try next week.

Thanks, I wondered why when I had a message to confirm it had run that I received the message twice. Where is it calling it twice? Thanks I will give that a go.

When my application is launched an AutoExec macro opens a hidden Form. The hidden form opens a Splash Screen and runs code to relink the backend Access tables. I use a hidden form to run the code because I found that if I used the Splash screen to run the code then the form wouldn’t render to...

You are a star thank you so very much for helping me this appears to be working fine now. I can thank you enough much appreciated. You've helped me yet again.

I have updated my code with the above but it only works after you have added the 43rd record. I have been playing around with the numbers in the below section of the code and I just cannot get it to work when there are less than 43 records. Any Ideas? Just to add to the above, the form size...

Hi arnelgp, I have played around with changing the numbers but cannot figure out why sometimes it works and other times it doesnt. The size of the form has room to display 20 records before the need to scroll. When it does work it only shows 5 records with lots of blank space (room for 15...

Thank you, this is very useful to know :)

Thanks I seemed to have this working now but is there anyway of moving to the say last record -5 so that I always see the bottom 5 records?

When you say this all needs to be achieved from the 'Other' form do you mean from the Main form or the actual Pop up form?

Where do I need to put this code?

I tried that but it still didnt go to the last record :(

Thanks for that I will avoid this then I have a specific order they are presented in no matter which order they added them so unfortunately I cannot just sort them in descending order. I have tried the DoCmd.GoToRecord , , ac_Last on the OnActivate event but this isnt firing when the form is...

I have a pop up form (Continuous view) that is bound to a query. The detail section contains only two fields of information, Item Name and Item Cost. As actions are taken on the main form I need the pop up form to update to show the costs of additional items that have been added. Basically the...

Right so I have taken the advice on here and have now restructured my table to have 3 fields. StockCode, Pallet, and BoxesPerPallet and then amended my lookup to lookup both the stock code and pallet from the two combo boxes and all works perfectly. I will just need to sort out how the user...

I have found another way as I couldn't get the field name to work using a variable. I am just going to reference the actual field name in the Dlookup and use if statements so that each Pallet has a separate lookup depending on what value they select from the combo box. Maybe not the way you guys...

I can only see 3 points listed and thought I dealt with them. I did correct all of the typos but when I pasted it back into here I pasted the wrong bit. Not having a good day :( So are you saying that I cannot determine the field name with a variable from a combo box? Dim strBox As String Dim...

The field names in the Pallet Matrix have to be the same as the values selected in the cboPallet otherwise it wont know which field to lookup. I want the value in the cboPallet to determine which field to lookup in the matrix table. This still doesnt work and produces error 2428 "You have...