Re: User Defined Functions in Calculated Fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I certainly will. It's makin me nuts though. I have unloaded all known
addins but still am getting the error. I must finish my project now, but
will get back to this when I have time to tracker down!

Thanks
doco


"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uFfraeFVHHA.4784@xxxxxxxxxxxxxxxxxxxxxxx
'fraid I don't have much experience in that arena.

Consider posting back here with your solution (after discovery!) ...
others
might be able to benefit from your situation.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"doco" <perdedor@xxxxxxxxxxxxxx> wrote in message
news:ebM3N8CVHHA.972@xxxxxxxxxxxxxxxxxxxxxxx
Ya, I overlooked it. The real bug-a-boo I found out, is with an addin I
have in Excel (which one?). For some reason when attempting to use
Excel.WorksheetFunction.SomeFunction from Access I get 'Out of Memory'
error
in Access and a custom error popup from Excel (found after closing a few
windows). I had 29 data points in my Access list so it could not be a
memory error - I wouldn't think. The custom dialog is telling me to go
to
Tools|Macro|Security|Trusted Publishers and "check 'Trust access to
Visual
Basic Project'"; which is checked. Oui vey!

Thanks guys...

"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:eHvZhPCVHHA.5100@xxxxxxxxxxxxxxxxxxxxxxx
I found no mention of a reference in your original post. Since we're
not
there, and you didn't mention it, it seemed an obvious first place to
check.

Perhaps as obvious as your "of course"...<g>

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"doco" <perdedor@xxxxxxxxxxxxxx> wrote in message
news:ecBpLH6UHHA.4188@xxxxxxxxxxxxxxxxxxxxxxx
Yes I have, of course.

doco







.


Quantcast