SendObject will not repeat

[KrissyB]

I am developing a macro that creates a table based on certain criteria entered by the user. Then this table is emailed in .xls format. I want to be able to run this macro via a button (I've already made) more then once in a row. HOwever, when I try to run it a second time it gives me an error message. (Condition: True Action Name: Send Object Arguments: 0, etc, etc,...)

Any help would save my life

Thanks

 

[TudorSmith]

Access 2000?

Apparently this is a known bug. Do a search for this topic and find a thread that explains. I'll try and look for it too and post it back here shortly.

There is a fix, but you have to write some VBA and insert a function in the code!

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))