|
 |
access thread: Case Sensitive Sorts
Message #1 by "Gerald, Rand" <RGerald@u...> on Wed, 19 Mar 2003 12:18:25 -0600
|
|
I'm having a problem with sorts. I have a query and report which I run
on
several different machines from a common network Access database. On
some
of the machines I get a case sensitive sort and grouping while on other
machines I get a case insensitive sort and grouping. I would like them
all
to work the same way - preferably case insensitive sorting and
grouping. Is
there an Option or Parameter I can use to force consistency?
Rand E. Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston, IL 60201
(xxx) xxx-xxxx
Message #2 by "Hamilton. Tom" <hamiltont@s...> on Wed, 19 Mar 2003 10:29:29 -0800
|
|
Consistency can be a big problem. I use 'Option Compare Database' in
all modules, Standard and Class, see the Help Topic for 'Compare
Database'. 'Option Compare Text' is a non case-sensitive collation
option that you can strategically use in your code to manage
grouping/collation issues.
These statements go in the Declaration section of your code and I always
use "Option Explicit' to force declaration of ALL variables since VB/VBA
is so loosely typed which can lead to some unanticiapted results. hth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, March 19, 2003 10:18 AM
To: Access
Subject: [access] Case Sensitive Sorts
Importance: High
I'm having a problem with sorts. I have a query and report which I run
on
several different machines from a common network Access database. On
some
of the machines I get a case sensitive sort and grouping while on other
machines I get a case insensitive sort and grouping. I would like them
all
to work the same way - preferably case insensitive sorting and grouping.
Is
there an Option or Parameter I can use to force consistency?
Rand E. Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston, IL 60201
(xxx) xxx-xxxx
Message #3 by "Gerald, Rand" <RGerald@u...> on Wed, 19 Mar 2003 12:33:03 -0600
|
|
All users are running the same application from a common network
location.
We should all get the same sort order.
Rand E. Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston, IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Hamilton. Tom [mailto:hamiltont@s...]
Sent: Wednesday, March 19, 2003 12:29
To: Access
Subject: [access] RE: Case Sensitive Sorts
Consistency can be a big problem. I use 'Option Compare Database' in
all
modules, Standard and Class, see the Help Topic for 'Compare Database'.
'Option Compare Text' is a non case-sensitive collation option that you
can
strategically use in your code to manage grouping/collation issues.
These statements go in the Declaration section of your code and I
always use
"Option Explicit' to force declaration of ALL variables since VB/VBA is
so
loosely typed which can lead to some unanticiapted results. hth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, March 19, 2003 10:18 AM
To: Access
Subject: [access] Case Sensitive Sorts
Importance: High
I'm having a problem with sorts. I have a query and report which I run
on
several different machines from a common network Access database. On
some
of the machines I get a case sensitive sort and grouping while on other
machines I get a case insensitive sort and grouping. I would like them
all
to work the same way - preferably case insensitive sorting and
grouping. Is
there an Option or Parameter I can use to force consistency?
Rand E. Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston, IL 60201
(xxx) xxx-xxxx
|
|
|
View Cart
