Option Compare Database (1 Viewer)
- Thread starter jsanders
- Start date
jsanders said:
You have two choices, either Option Explicit or Option Compare. The Option Compare would be used if you wanted to do comparions, for example, between strings:
"AAAA" = "aaaa" would be false
"AbCd" = "AbCd" would be true
fuzzygeek
Energy Ebbing
- Local time
- Today, 16:34
- Joined
- Mar 28, 2003
- Messages
- 989
Just for clarification the following link shows results using different options:
http://support.microsoft.com/kb/98227/en-us
http://support.microsoft.com/kb/98227/en-us
Option Explict can be set to add it self to everymodule when it is created. Higly reccomened as it stops a lot of silly mistakes.
from help
Require Variable Declaration — Determines whether explicit variable declarations are required in modules. Selecting this adds the Option Explicit statement to general declarations in any new module.
Peter
from help
Require Variable Declaration — Determines whether explicit variable declarations are required in modules. Selecting this adds the Option Explicit statement to general declarations in any new module.
Peter
techexpressinc
Registered User.
- Local time
- Today, 11:34
- Joined
- Nov 26, 2008
- Messages
- 185
Can you have both - if so what is the format?
Thx
RUss
Thx
RUss
boblarson
Smeghead
- Local time
- Today, 08:34
- Joined
- Jan 12, 2001
- Messages
- 32,059
ChrisO
Registered User.
- Local time
- Tomorrow, 01:34
- Joined
- Apr 30, 2003
- Messages
- 3,202
I think the answer would be that it has been deleted from some of the modules.
It is there by default but I normally change it to Option Compare Text because of a bug in Access 2000.
I don’t know if it has been fixed or if the end user is or is not using an old version.
http://www.trigeminal.com/usenet/usenet001.asp?1033
It is there by default but I normally change it to Option Compare Text because of a bug in Access 2000.
I don’t know if it has been fixed or if the end user is or is not using an old version.
http://www.trigeminal.com/usenet/usenet001.asp?1033
not quite correct mates!
option compare database is fine if you dont use the extended char set but if you do then use option compare text to aviod the dreaded error 3265 object not found in collection because your column 'Övrigt' is not the same as 'övrigt'
option explicit deals with variable declaration
option compare database is fine if you dont use the extended char set but if you do then use option compare text to aviod the dreaded error 3265 object not found in collection because your column 'Övrigt' is not the same as 'övrigt'
option explicit deals with variable declaration
