2002 to 2010 Problem

[DSTR3]

I'm converting from 2002 to 2010. When I open my 2002 in 2010 my program hangs on this line. Any suggestions on what it may be?


Thanks
DS


TU = Nz(DLookup("TerminalTouch", "tblTerminal", "TerminalName = Environ(""ComputerName"")"), 0)
If TU = True Then
DoCmd.OpenForm "frmPointer", , , , , acHidden
Else
End If

[ajetrumpet]

well it doesn't look like the syntax is correct really in the TU' line. and I believe the environ() function should be concatenated out of the doubles. it's possible that 10 doesn't like that. and the other thing too, is that I don't think 2010 is bug free yet, or not even close for that matter. I've had numerous problems with corruption after opening pre-10 versions of database in that program. backup your files before you open them in 2010.

the corruption only happens though, when you re-open a file in pre-10 after opening it in 10. I've heard numerous other accounts of this happening as well.

[DSTR3]

Thank you for the input. Just what I want to hear about 2010! I'm trying to move towards the future but now it looks like I moved too fast!!!!
Just how would the line read? I'm not sure where the doubles should go.
DS

[ajetrumpet]

allen browne uses nested double quotes, and I never understood how people like that can read code that way. I would go crazy determining what is what.

but it works as well, I just personally don't care for it. I would personally write it like this:

TU = Nz(DLookup("TerminalTouch", "tblTerminal", 

"TerminalName = '" & Environ(6) & "'"), 0)

[DSTR3]

Thank you, I will try that. In the meantime I mad a module with the following.....

'This function is used to allow the use of the Environ function in Access 2003

Public Function Environ(Expression)
On Error GoTo Err_Environ

Environ = VBA.Environ(Expression)

Exit_Environ:
Exit Function

Err_Environ:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_Environ

End Function

This worked. Apparently Access 2002 doesn't have a "Sandbox Mode" and 2010 does. This caused the problem as it deemed Environ as being an unsafe bit of cade. Thank you for your help.
DS