Error 2455 “Invalid reference to property filesearchâ€

M

Masoud

I have the code like below for sending email with attachments, but I found
error 2455 “you entered an expression that has an invalid reference to the
property filesearch.
' Add attachments to the message.
With Application.FileSearch
.LookIn = Forms!frmMail!Att
.FileName = "*.*"
.Execute

For i = 1 To .FoundFiles.Count
objOutlookMsg.Attachments.Add .FoundFiles(i)
Next i
End With

please help.
 
J

Jack Leach

If you are using Access 2007, apparently the FileSearch functionality has
been removed. You will need an alternate method to locate what you need.
Aside from that, I'm not very familiar with the method to begin with so I'm
not sure.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Value from Textbox on Form to VBA Code 4
Script Runs in 2003 / Fails in 2007 (FILE SEARCH) 2
Application.FileSearch 2007 Reference 1
Unable to Reference a Subforms Properties/Controls 3
get error 2455 invalid reference to property 5
Error: The remote server machine does not exist or is unavailable 1
Using Application.FileSearch in Access 2007 5
Archive(Move) and Delete 2

Top