Search results

  1. J

    Hide-Unhide Standard Menus Access 2007

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

    Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression.

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

    Array within a Split Function

    I'm looking to optimize a split function by allowing users to enter delimiters into table, and then later on be able to split a string using the delimiters users have chosen. So intead of the delimiter being fixed, it would be flexible depending on what is chosen. I would get an array via the...
Top Bottom