Search results

  1. J

    Multiplying two values from the same column

    Names Number1 Number2 Name1 1 2 Name1 2 1 Name1 3 -2 Name1 4 2 Name1 5 5 Name2 1 2 Name2 2 5 Name2 3 2 Name2 4 5 Name2 5 -1 ... For each Name, Number1 will always contain the...
  2. J

    Assign a keyboard shortcut to a macro.

    Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go...
  3. J

    Loop over highlighted tables?

    Yeah, I meant selected in the navigation pane. There's only myself and one other coworker who has access to the file, so I don't think it should be too much of a problem. Thanks for the tip. I'll definitely look into this.
  4. J

    Loop over highlighted tables?

    I'm familiar with Excel vba, but I'm pretty new to using vba in Access. I have a macro set up to loop over all tables: For Each tbl In CurrentDb.TableDefs **stuff** Next I'd like to modify it so that the **stuff** only gets applied to tables that are actually highlighted before the macro is...
Back
Top Bottom