This is on a sharepoint web database...
I'm trying to run a data macro which simply retrieves field values.
When I run it from within Access, it gives no errors.
However, whenever I try to run it on Sharepoint it throws up a 3875 error.
The only information I can find on that error is "Microsoft Access cannot interpret the text you are pasting as a data macro. Correct the text and then try again"
I have stripped the macro right back to basics and it still throws up the error:
There is only one record in that table (I get the same error if I use Lookup)
Any suggestions on this one?
I'm trying to run a data macro which simply retrieves field values.
When I run it from within Access, it gives no errors.
However, whenever I try to run it on Sharepoint it throws up a 3875 error.
The only information I can find on that error is "Microsoft Access cannot interpret the text you are pasting as a data macro. Correct the text and then try again"
I have stripped the macro right back to basics and it still throws up the error:
For Each Record in tblHistory
Set Return Value name varCurrent
Expression = [tblhistory].[dblCurrent]
There is only one record in that table (I get the same error if I use Lookup)
Any suggestions on this one?