SendObject To field

[neptyr]

Hi, i'm writing a macro by using the SendObject feature atm.

But i got a problem.

How can you do something like "SELECT email FROM users WHERE sign='*username*" , without using code or anything like that?

email and sign is fields on the same line in the users table.

The only reason i don't want to use VBA code, is because the ones who are going to use this, don't want _any_ code in the application.

Hope someone got a solution, I'm going mad here

Neptyr

 

[IR_Moon]

I would figure the best way to do would be to use code. I';m looking at doing something similar but definitely will be using VBA... and in fact I'm not sure you can put something so complex into a Macro.

The real issue is WHY don't they want any code? that seems a little odd to me. The trade-off of using macros for everything of course is that you don't have the same level of flexibility as you would do with VBA....

 

[neptyr]

i allready got a mailcode solution ready, but they didn't want that, they wanted MACRO MACRO MACRO!

I really don't know why they don't want to use code.
Tried to convince them several times, but, no go.

I guess it is because of the old fellow who is going to administrate this, can't a single line of vba, and he does not want to learn anything new.

So there i am, stuck :/

Neptyr

 

[boblarson]

So there i am, stuck :/

No, you can tell them that THEY are stuck because they won't budge.

But, seriously, you should be able to create a query in the QBE grid and set the criteria to be their username by placing the =Environ("username") function in the criteria. Then save the query with a name and then send that as the object specified in the macro.