View Single Post
  #8  
Old May 5th, 2010, 09:11 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)

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.