View Single Post
  #10  
Old May 6th, 2010, 03:39 AM posted to microsoft.public.access.queries
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Function is not availalbe in expressions in query expression error message (0/1)

Not sure what happened with SendObject... and that is not a Reference
issue. Unfortunately, tracking down errors is sometimes tedious (and
annoying). Did you change anything in the macro that would indicate what
part thru up the error?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Repent34" wrote in message
...
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.