Ooops. Didn't realize where your starting point was. The Object
Browser is a good tool to know, but probably not what you need
right now.
If you're in the "code window" that is, the VBA code module window
where you can type functions, subs, etc, then press Ctl+G to bring
up the Immediate window, which will appear at the bottom. Use this
window to test stuff ... for example, type the following and press ENTER.
Print CurrentDB.Name
You can run Doug's code by typing ...
?CurrentDb.CollatingOrder
The question mark is shorthand for PRINT. Play with it and you'll see all
the cool things you can do in this window. Try these ...
?Len("My name is Sam.")
?Format(Now(), "mmm-dd-yyyy")
?Right("Hello",3)
MsgBox "Hi from the debug window."
This is where you can test stuff and "run" a function. The function must be
declared as public and saved to a module. Try pasting this in a new module
and saving it.
Public Function GetCollatingOrder() As String
Dim strOrder As String
strOrder = CurrentDb.CollatingOrder
MsgBox strOrder
GetCollatingOrder = strOrder
End Function
To run this, put this in the Immediate window and hit ENTER ...
?GetCollatingOrder
