Undefined function 'Format Number'

W

wisdom

New member

Local time

Tomorrow, 02:27

Joined

May 12, 2013

Messages

6

• May 25, 2013

• #1

Hi, all. I looked for missing references after I had received this message. List of available references had 4 selected items:

1) Visual Basic for Applications;
2) Microsoft Access 15.0 Object Library;
3) Microsoft Office 15.0 access database engine library
4) OLE Automation;

I tried to check off the 3rd and the 4th one, but it came to nought (error didn't dissapear). What else can I do ?

Thanks for any replies.

 

M

mdlueck

Sr. Application Developer

Local time

Today, 18:27

Joined

Jun 23, 2011

Messages

2,649

• May 25, 2013

• #2

Please provide the VBA source code which is raising the complaining, and please be sure to use [#] code tags around it, found on the message editor button list.

 

W

wisdom

New member

Local time

Tomorrow, 02:27

Joined

May 12, 2013

Messages

6

• May 25, 2013

• #3

I have no VBA source code. Error's appearing while trying to open ADOQuery from Client app. When query executed directly from Access SQL query editor, transaction finished successfully.

 

M

mdlueck

Sr. Application Developer

Local time

Today, 18:27

Joined

Jun 23, 2011

Messages

2,649

• May 25, 2013

• #4

By your #1 it looked like you were in the VBA Editor \ Tools \ References. That is the only spot I can think of which that list shows up.

If you now say (#3) you have no VBA code at all... rrrrr????

 

W

wisdom

New member

Local time

Tomorrow, 02:27

Joined

May 12, 2013

Messages

6

• May 25, 2013

• #5

Yes, it's a VBA Editor \ Tools \ References. But what VBA Source code did you mean ? I only looked through the list of references and didn't execute any code. I'm novice in Access and can misunderstand something.