Error 3875 on RunDataMacro

toast

Registered User.
Local time
Today, 11:31
Joined
Sep 2, 2011
Messages
87
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:

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

Users who are viewing this thread

Back
Top Bottom