Problem with Command Button on Click (1 Viewer)

Hi All,

I am having some serious issues with a simple search box and the cmd button (using embedded macro onclick)for it. everytime I click the button I get the message Object or Class does not support the set of events. Using access 2007. Copied the embedded macro from an access 2007 template.
Here is the embmacro:

Begin
Condition ="[Forms]![Customer List]![Searchbox] Is Null"
Action ="RunCommand"
Comment ="Clear Filter when search box
empty"
Argument ="144"
End
Begin
Condition ="..."
Action ="SetProperty"
Argument ="cmdShowAll"
Argument ="0"
Argument ="0"
End
Begin
Condition ="..."
Action ="StopAllMacros"
End
Begin
Action ="SetTempVar"

Comment ="Handle \"'s in search"
Argument ="strSearch"
Argument ="Replace([Forms]![Customer
List]![SearchBox],\"\"\"\",\"\"\"\"\"\")"
End
Begin
Comment ="Build the Filter"
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="\"([Last Name] Like \"\"*\" &
[TempVars]![strSearch] & \"*\"\")\""
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="[TempVars]![strFilter] & \" OR
([First Name] Like \"\"*\" &
[TempVars]![strSearc"
"h] & \"*\"\")\""
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="[TempVars]![strFilter] & \" OR
([E-mail Address] Like \"\"*\" &
[TempVars]![strS"
"earch] & \"*\"\")\""
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="[TempVars]![strFilter] & \" OR
([Job Title] Like \"\"*\" &
[TempVars]![strSearch"
"] & \"*\"\")\""
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="[TempVars]![strFilter] & \" OR
([Mobile Phone] Like \"\"*\" &
[TempVars]![strSea"
"rch] & \"*\"\")\""
End
Begin
Action ="SetTempVar"
Argument ="strFilter"
Argument ="[TempVars]![strFilter] & \" OR
([Business Phone] Like \"\"*\" &
[TempVars]![strS"
"earch] & \"*\"\")\""
End
Begin
Action ="ApplyFilter"
Argument =""
Argument ="=[TempVars]![strFilter]"
End
Begin
Action ="RemoveTempVar"
Argument ="strFilter"
End
Begin
Action ="RemoveTempVar"
Argument ="strSearch"
End
Begin
Action ="SetProperty" Picture: Search.bmp
Argument ="cmdShowAll"
Argument ="0"
Argument ="1"
End

Don't run 2007, but you say "Copied the embedded macro from an access 2007 template."

There are several references in the posted code to specific forms/controls. Did you replace them with the actual names of your own forms/controls?

missinglinq said:

Don't run 2007, but you say "Copied the embedded macro from an access 2007 template."

There are several references in the posted code to specific forms/controls. Did you replace them with the actual names of your own forms/controls?

Click to expand...

I am using Access 2007, yes I replaced all the names to those of my own controls and forms. The odd thing is, it started working again. And the only thing I did was to change the picture on the cmd button and remove the display text!?!?

OK quick update. It was working yesterday afternoon. Just went to use it today and now getting same error message!!!!!!! Help me please someone!!! All I want is a command button that will use the contents of a text box to search

Ok this is really getting me confused now. It works then I come in the next day and it stops working. Yesterday morning it wouldn't work, didn't change anything and it started to work. Came in this morning and it wouldn't work!!!!! WTF is going on.?!?!?

Can you upload your Database, minus any sensitive data. Will be much easier to see whats going wrong.

dbDamo said:

Can you upload your Database, minus any sensitive data. Will be much easier to see whats going wrong.

Click to expand...

I can't get it to zip to a small enough size. I can use winrar to compress it enough but unfortunately I can't upload winrar files. Can I email it to you??

Upload it to a file hosting site and post the link here. I'll have a look when I get home Tonight as I don't have 2007 at work.

Hi dbDamo you can find the file here http://www.mediafire.com/?sharekey=0cd78a1972f9b6a0bda4076e811714c8e04e75f6e8ebb871

Hi did you manage to have a look at the form??

I'll have a look when I get home Tonight mate, running 2002 at work

ok thanks that's great.