Format undefined

[Ann]

I received the following from a previous post:

Key: Format([DRS Job Id],"00000000") & Format(Date(),"yyyymmdd") & "01" &
Format([ID],"00000000") & Format([Page Number],"00000") & Format([Page
Count],"00000")

I needed to put together a key with fixed length values. DRS Job Id, Page
Number and Page Count are entered when the query runs. There is one other
field, Sub ID, from a table that I am using.

It had been working fine but for some reason Access no longer understands
Format. I keep receiving the following message:

Undefined function "Format" in expression.

Can anyone tell me why it would all of a sudden give me this message? I
tried to recreate it in a new query and still have the problem. Thanks in
advance for any help you can give me.

 

[Ann]

Thank you so much! That was the problem and all is working correctly once
again.

Sounds like a missing reference.

1) Open any module and then click on Tools/References. If a reference is
missing it will be marked as Missing..

2) Unclick it then scroll down to find it again. Click on the refererence to
reselect it.

HTH - Bob

I received the following from a previous post:

Key: Format([DRS Job Id],"00000000") & Format(Date(),"yyyymmdd") & "01" &
Format([ID],"00000000") & Format([Page Number],"00000") & Format([Page
Count],"00000")

I needed to put together a key with fixed length values. DRS Job Id, Page
Number and Page Count are entered when the query runs. There is one other
field, Sub ID, from a table that I am using.

It had been working fine but for some reason Access no longer understands
Format. I keep receiving the following message:

Undefined function "Format" in expression.

Can anyone tell me why it would all of a sudden give me this message? I
tried to recreate it in a new query and still have the problem. Thanks in
advance for any help you can give me.

 

[John W. Vinson]

It had been working fine but for some reason Access no longer understands
Format. I keep receiving the following message:

Undefined function "Format" in expression.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.