difference between opening a query

[jeremypaule]

what's the difference between...

Dim stDocName As String

stDocName = "APPEND - DATA"
DoCmd.SetWarnings False
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings True


and

DoCmd.SetWarnings False
DoCmd.OpenQuery "ADD EVENT"
DoCmd.SetWarnings True


are their benefits to either?

 

[pbaldy]

I assume you mean the bit about using a variable for the name? Personally, I only do that if I'll be using the name in more than one place in the code, or I'll be setting it to different things depending on user selections. Otherwise, I just use the second method. Performance-wise, I'd assume the second is faster, since the first would have to resolve the variable name back to the actual name anyway.