Search results

...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...

Hello I am trying to create a VBA script which removes duplicates from a single table. It searches for duplicates based on two fields (IDtable1 and IDtable2) puts them in a string and then if the string is a duplicate to the one preceeding then it deletes that line. That part is ok, but there...

Hello - yes this is useful, at least to my client, who, with all due respect, would disagree this is an 'academic' excercise. To clarify, it is a small part of a larger project. Thank you to those who answered the original question whether or not an array could be used for this. The answer...

Hello boblarson - yes your code works well if it is only one thing I am looking to replace. But here is the array of words I want to remove from a table (there is some repetition) tblWords_to_Delete Strings2Eliminate [la ] [ la] [ & ] [ (la)] [ (le)] [le ] [ le] [ les] [ (les)] [un ] [ un]...

Ok, so imagine I have a table that is as follows (of course this is a test table): SKU Title 1 the quick 2 brown fox jumped 3 over the lazy 4 dog So as it works now, I run the code and a message box pops up saying "the word is the and the length is 3"...

Hi Gemma ok here are some more details with some code which works. What I want to add to the code is an array (which can be edited via a form). The array will contain the delimiters of the 'split' function. Right now you'll see in the code the only delimiter of the split function is a space ("...