Sunday, May 2, 2021

Web compatibility check supported expressions

Important    Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps.

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.

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

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

Top of Page

at

No comments:

Post a Comment