How to view MSAccess2003 default collation order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On the TOols/Options/General page, you can set the collation order for the
next compact/repair operation.

Where can you view what the value is set to currently? Is this a per-table
setting?

HELP!!!
 
CurrentDb.CollatingOrder will give it to you. It's on a database-basis, not
a per-table basis.
 
THanks DOuglas.
Can I ask, where can I find CurrendDB in the MS Access user
interfaces?
Regards,
Redd
 
From any code window, press F2 to see the object browser. Search
for CurrentDB and you'll see it's from the Access | Application object.
 
Danny,
Thanks also. Im running MsAccess2003. By "code window" do you mean
VB? or the developer studio? Im trying to find a way, from within MSAccess
GUI.
THanks
Redd
 
OK Getting somwhere (never been this far inside Access). I added a
"module", then found CurrentDb.CollatingOrder.

Finally, can you tell me how to run the module?

Thanks!!!
Redd
 
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
 
Back
Top