Recent content by jplank

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

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

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.

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