Reputation
405
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 6 16
Newest
 Yearling
Impact
~119k people reached

  • 0 posts edited
  • 0 helpful flags
  • 15 votes cast
2d
awarded  Yearling
Jan
20
awarded  Good Question
Jan
15
awarded  Popular Question
Jul
2
awarded  Curious
Jun
8
awarded  Editor
Jun
8
revised How do I restore a non-system hard drive using Time Machine under OSX?
added 329 characters in body
Jun
8
awarded  Nice Question
Apr
5
comment How can I execute WinRAR serially against each archive in a folder?
Thanks! This worked beautifully.
Apr
5
accepted How can I execute WinRAR serially against each archive in a folder?
Apr
4
asked How can I execute WinRAR serially against each archive in a folder?
Jan
31
asked How can I force Excel to recalculate after a UDF macro error?
Jan
31
answered How can I force Excel to recalculate after a UDF macro error?
Jan
16
awarded  Famous Question
Nov
28
awarded  Nice Question
May
29
awarded  Famous Question
Apr
5
comment Why is my Access 2010 ADP not filtering its SQL statements when connected to MSSQL 2008 R2?
Apparently I don't have a high enough reputation here to answer my own question, but I found a workable solution. I created a VIEW in MSSQLSM that selects rows from my table based on filters I have in a row in a scratch table designed just for that. I can then edit rows in Access by editing within the view and it is ORDERS OF MAGNITUDE faster. Just have to edit my filter row (which I keep open in another window) and refresh the view as needed.
Mar
28
awarded  Popular Question
Feb
9
awarded  Famous Question
Dec
10
awarded  Notable Question
Oct
24
awarded  Promoter