Show All

Troubleshoot undefined functions and references to projects or libraries

• When you open a Microsoft Access file that contains references to projects or libraries that aren't in the location specified in the References dialog box, Access tries to find the projects or libraries. However, if Access can't find a referenced file, you might have to set the reference manually. You might not be aware that you need to fix a missing reference until you receive an "undefined function" message or a message that Access can't find a project or library when you try to run a query or a Microsoft Visual Basic procedure. To fix a missing reference, open a module in Design view, and click References on the Tools menu. Then clear the check box next to any missing references and set the references you want.
• You can't call a class module from a query, form, report or macro. Store a Visual Basic procedure in a standard module if you need to call it from a query, form, report, or macro.
• You might receive an "undefined function" message when you open a data access page outside of Access if the data access page contains a function that isn't available outside of Access.

  Functions you can use in a data access page, or in PivotTable view or PivotChart view of a form

  A control in a data access page or a form that is open in PivotTable view or PivotChart view can contain an expression that uses a Microsoft Visual Basic for Applications (VBA) function. However, the expression will generate an error unless it appears on the following list.

  Note  This limitation doesn't apply to expressions in tables, queries, views, stored procedures, or user-defined functions that you have opened in PivotTable or PivotChart view.

  A - C

  ABS	ARRAY
  ASC	ASCB
  ASCW	ATN
  CBOOL	CBYTE
  CCUR	CDATE
  CDBL	CHOOSE
  CHR	CHR$
  CHRB	CHRB$
  CHRW	CHRW$
  CINT	CLNG
  COS	CSNG
  CSTR	CVAR
  CVDATE	CVERR

  D - H

  DATE	DATE$
  DATEADD	DATEDIFF
  DATEPART	DATESERIAL
  DATEVALUE	DAY
  DDDB	ERROR
  ERROR$	EXP
  FIX	FORMAT
  FORMAT$	FV
  HEX	HEX$
  HOUR

  I - L

  IIF	IMESTATUS
  INSTR	INT
  IPMT	IRR
  ISDATE	ISEMPTY
  ISERROR	ISNULL
  ISNUMERIC	ISOBJECT
  ICASE	ICASE$
  LEFT	LEFT$
  LEFTB	LEFTB$
  LEN	LENB
  LOG	LTRIM
  LTRIM$

  M - Q

  MID	MID$
  MIDB	MIDB$
  MINUTE	MIRR
  MONTH	NOW
  NPER	NPV
  OCT	OCT$
  PARTITION	PMT
  PPMT	PV
  QBCOLOR

  R- S

  RATE	RGB
  RIGHT	RIGHT$
  RIGHTB	RIGHTB$
  RND	ROUND
  RTRIM	RTRIM$
  SECOND	SGN
  SIN	SLN
  SPACE	SPACE$
  SQR	STR
  STR$	STRCOMP
  STRCONV	STRING
  STRING$	SWITCH
  SYD

  T - Z

  TAN	TIME
  TIME$	TIMER
  TIMESERIAL	TIMEVALUE
  TRIM	TRIM$
  TYPENAME	UCASE
  UCASE$	VAL
  VARTYPE	WEEKDAY
  YEAR