Recent content by jpindi

...As a work-around I customized the quick access toolbar, just for my 'top' commands. Thanks again.

Thanks, Mr. B. I guess if that's the only solution then that's the only solution. Now I remember why I prefer website coding to MS Access...

Thanks for your quick reply: So let me get this straight, getting the menus to appear like it used to work in 2003 doesn't work any more and I have to rebuild this 'ribbon' as it is now called from scratch using XML? That seems like a lot more work than it used to be, but is that right? I think...

Hi All - I had a simple little VBA code written that works for MS Access 2003 but not for 2007. I believe it has to do with the menu names. Basically it was a list box that toggled the menus on and off. Here is the working code that I've tried to tweak by adding 'yes visible' for anything under...

I had the same problem and just applied the DCrake solution: it works and is going to help clean up my code quite a bit. Thank YOU!

Ok, then I guess there isn't a way to hit 'cancel' on the onClose event.

I do understand how the events work, that is how I know at onUpdate isn't good enough, thank you.

As I mentioned before, onUpdate does not suit my needs (yes, just the way you've presented the code). I need this to work onClose. Any other takers? Thanks,

Yes, exactly, popup appears when skip to another record after a change has been made to the previous record. Thanks.

Well, the problem's the same, so it's logical to keep it on the same thread. The problem with BeforeUpdate is that the same message box "Are you sure you want to whatever" that has been created will pop up every time you skip to another record (which may happen a lot in the case of continuous...

So did the solution for this ever appear? I have exactly the same thing I want to do and found this via Google.

Actually never mind, all is good. Thanks again for your help.

Sorry - there's no query, just a table. How would I do that in VBA?

Thanks for getting back to me, guys. I've tried different code which avoids the sorting altogether and instead loops through the table comparing each record to one another. Incidentally, how would you sort a table via VBA if the Execute method is not good?

Thanks, that worked well. It was one of those things that I knew would be a quick fix, but I just couldn't think of it. Another part of SQL code that isn't working well, though is trying to get my table to sort on a field called "IDtable2". It doesn't give an error message...it just doesn't...