Hi everyone,
I am new here and I am not sure if this is the right group, else please move my tpoci tho the correct group.
I have a strange situation.
A friend of my has made a file in MS Access 2013
On his computer and laptop it is working fine. (I think he is using windows 10 on both)
When I copy the file to my computer, it does not want to work.
First I was getting the message that I had to turn on Macro's
So I had changed this to allow all macro's
Now when I try to open the file, I am getting an error;
Undefined function ‘Str’ in expression
I only have two options I can choose.
I can click on OK or HELP
When I click on HELP, a website page is opened and it will try to explain what is wrong;
“You entered an SQL expression that includes a Function procedure name that cannot be recognized. Make sure the function can be used in SQL expressions, or check the expression to make sure you entered the name correctly."
When I click on OK a new window will pop-up with the following;
Macro Single Step
Macro Name:
mcrExtendedMembers
Condition:
(this field is empty)
Action Name:
OpenQuery
Arguments:
MembersExtendedMembers; Datasheet; Edit
Error Number:
2950
In this window, I only can click "Stop All Macro's"
When I do this, I end-up with a empty field/workspace.
I had try this file on several computers.
On my Windows 10 with Office 2010 and on a laptop with Windows 10 and Office ProPlus (UK) 2013
Both are doing the same thing.
Does anyone has any idea, why the file is working on both his computers, but not on mine ?
We also had tried the file on a clean Windows 10 laptop with Office 2013 from him, and it is working there without any problem.
For me this is very strange.
I am new to MS Access, but any which way I look at it, it should work.
Many thanks for all your help, tips and tricks.
Gr. Pierre