Web compatibility check: supported expressions
You can resolve expression-related compatibility checker errors in Access web databases by replacing expressions that the compatibility checker identified as issues in the Web Compatibility Issues table.
This topic lists expressions and the contexts that do and do not support them in an Access web database. You can use supported expressions to replace expressions that the compatibility checker identified as not web-compatible.
For general information about Compatibility Checker errors, see the article Web compatibility check General errors.
Note: This article applies to Access web databases (introduced in Access 2010) which are different than Access web apps (introduced in Access 2013).
In this article
Overview
In traditional Access desktop databases, expressions are all evaluated the same, regardless of where they occur. That is, whether the expression is in a query column, a form control, or a report footer, it works the same way.
In an Access web database, expressions are evaluated in context, and some expressions are valid in some contexts but not in others. For example, an expression that works in a web form control might not work in a web query.
When you design Access web database objects from scratch or use a template to get started, you don't have to worry about contexts, because Access prevents you from entering an expression that cannot be evaluated in the context in which you are working. But, if you want to bring forward an existing database and publish it to the web, some of the expressions in that database may not work as expected.
You can run the compatibility checker to help you identify such potential issues. You may have reached this topic after running the compatibility checker, and then clicking a cell in the Web Compatibility Issues table. This topic lists the expressions that you can use in each context, to help you address issues that the compatibility checker discovered.
Table of supported expressions
Refer to this list of supported expressions by context to replace expressions that are identified as issues by the compatibility checker.
General Access
The following expressions are allowed in the General Access context of a web database.
Conversion
CDbl
DateSerial
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Nz
Database
CurrentWebUser
CurrentWebUserGroups
IsClient
IsCurrentWebUserInGroup
Date/Time
Date
DateSerial
Now
Inspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
Avg
Count
Sum
Text
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
+
<
<=
<>
=
>
>=
And
Not
Or
Calculated Columns
The following expressions are allowed in the Calculated Columns context of a web database.
Conversion
Asc
CDbl
DateSerial
Day
Hour
Minute
Month
Second
Str
Str$
TimeSerial
Weekday
Year
Date/Time
DateSerial
Day
Hour
Minute
Month
MonthName
Second
TimeSerial
Weekday
WeekdayName
Year
Financial
DDB
FV
IPmt
NPer
Pmt
PPmt
PV
Rate
SLN
SYD
Inspection
IsEmpty
IsNull
Math
Abs
Atn
Cos
Exp
Fix
Int
Log
Round
Sign
Sin
Sqr
Tan
Program Flow
Choose
IIf
Text
Asc
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
Space
Space$
String
String$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
\
^
+
<
<=
<>
=
>
>=
And
In
Like
Not
Or
Validation Rules
The following expressions are allowed in the Validation Rules context of a web database.
Conversion
Asc
CDbl
DateSerial
Day
Hour
Minute
Month
Second
Str
Str$
TimeSerial
Weekday
Year
Date/Time
Date
DateSerial
Day
Hour
Minute
Month
MonthName
Now
Second
Time
TimeSerial
Weekday
WeekdayName
Year
Financial
DDB
FV
IPmt
NPer
Pmt
PPmt
PV
Rate
SLN
SYD
Inspection
IsEmpty
IsNull
Math
Abs
Atn
Cos
Exp
Fix
Int
Log
Round
Sign
Sin
Sqr
Tan
Text
Asc
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
Space
Space$
String
String$
Trim
Trim$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
\
^
+
<
<=
<>
=
>
>=
And
In
Like
Not
Or
Query Columns
The following expressions are allowed in the Query Columns context of a web database.
Conversion
Asc
CDbl
DateSerial
Day
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Hour
Minute
Month
Nz
Second
Str
Str$
TimeSerial
Weekday
Year
Database
CurrentWebUser
CurrentWebUserGroups
IsCurrentWebUserInGroup
Date/Time
Date
DateSerial
Day
Hour
Minute
Month
MonthName
Now
Second
Time
TimeSerial
Weekday
WeekdayName
Year
Financial
DDB
FV
IPmt
NPer
Pmt
PPmt
PV
Rate
SLN
SYD
Inspection
IsEmpty
IsNull
Math
Abs
Atn
Cos
Exp
Fix
Int
Log
Round
Sign
Sin
Sqr
Tan
Program Flow
Choose
IIf
Text
Asc
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
Space
Space$
String
String$
Trim
Trim$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
\
+
<
<=
<>
=
>
>=
And
In
Like
Not
Or
UI Macros
The following expressions are allowed in the UI Macros context of a web database.
Conversion
CDbl
DateSerial
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Nz
Database
CurrentWebUser
CurrentWebUserGroups
IsClient
IsCurrentWebUserInGroup
Date/Time
Date
DateSerial
Now
Inspection
IsNull
Math
Round
Program Flow
IIf
Text
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
+
<
<=
<>
=
>
>=
And
Not
Or
Data Macros
The following expressions are allowed in the Data Macros context of a web database.
Conversion
Asc
CDbl
DateSerial
Day
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Hour
Minute
Month
Nz
Second
Str
Str$
TimeSerial
Weekday
Year
Date/Time
Date
DateSerial
Day
Hour
Minute
Month
MonthName
Now
Second
Time
TimeSerial
Weekday
WeekdayName
Year
Financial
DDB
FV
IPmt
NPer
Pmt
PPmt
PV
Rate
SLN
SYD
Inspection
IsEmpty
IsNull
Updated
Math
Abs
Atn
Cos
Exp
Fix
Int
Log
Round
Sign
Sin
Sqr
Tan
Program Flow
Choose
IIf
Text
Asc
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
Space
Space$
String
String$
Trim
Trim$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
\
^
+
<
<=
<>
=
>
>=
And
In
Like
Not
Or
Forms
The following expressions are allowed in the Forms context of a web database.
Conversion
CDbl
DateSerial
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Nz
Database
CurrentWebUser
CurrentWebUserGroups
IsClient
IsCurrentWebUserInGroup
Date/Time
Date
DateSerial
Now
Inspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
Avg
Count
Sum
Text
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
+
<
<=
<>
=
>
>=
And
Not
Or
Reports
The following expressions are allowed in the Reports context of a web database.
Conversion
Asc
CDbl
DateSerial
Day
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
Hour
Minute
Month
Nz
Second
Str
Str$
TimeSerial
Weekday
Year
Date/Time
Date
DateSerial
Day
Hour
Minute
Month
MonthName
Now
Second
Time
TimeSerial
Weekday
WeekdayName
Year
Financial
DDB
FV
IPmt
NPer
Pmt
PPmt
PV
Rate
SLN
SYD
Inspection
IsEmpty
IsNull
Math
Abs
Atn
Cos
Exp
Fix
Int
Log
Round
Sign
Sin
Sqr
Tan
Program Flow
Choose
IIf
SQL Aggregate
Avg
Count
Max
Min
StDev
StDevP
Sum
Var
VarP
Text
Asc
InStr
LCase
LCase$
Left
Left$
Len
Mid
Mid$
Right
Right$
String
String$
Trim
Trim$
UCase
UCase$
Constants
""- EmptyString
False
Null
True
Operators
-
&
*
/
\
^
+
<
<=
<>
=
>
>=
And
In
Like
Not
Or
No comments:
Post a Comment