Undefined function 'Format Number'

[wisdom]

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.

 

[mdlueck]

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.

 

[wisdom]

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.

 

[mdlueck]

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????

 

[wisdom]

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.