View Single Post
  #9  
Old May 5th, 2010, 10:23 PM posted to microsoft.public.access.queries
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Function is not availalbe in expressions in query expression error message (0/1)

Looks like my issue is finally resolved. I ended up having to remove
the macro for the sendobject, in this case, email. I then recreated
it from scratch and everything is back working.

If there is an easier way to discover the problem, I sure wish someone
would share it with me. I may run into this issue again.

BTW, I had tried creating a new blank DB, then importing over all
forms, controls, queries, etc. Still had the same error. Only after
deleting the macro and underlying code and recreating it did I get a
solution.

chris






On Wed, 05 May 2010 13:11:59 -0700, Repent34 wrote:

I've done quite alot of testing on this issue. what I've found out,
is that if I remove a sendmail macro action from a button on a form,
as well as removing the VBS code under the editor, save everything,
create another accde file and publish to my client, I now don't
receive this error, and everything seems to be back to normal, except
of course when the user clicks on the button, to drive the macro that
does a send mail funtion, nothing happens. I just need to fix that
part. I'll try to do this and post back my results.

the T/S I did consisted of removing various parts of my forms, code,
controls, etc until I removed the above referenced control for
sendmail that resolved the issue.

Do this sound familiar to anyone?

chris



On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

Check the References on your Client's machine. Sounds like ther might be
one missing.