Search results

Are you the original Rich?

Perhaps we are both a bit more narrow minded than we care to admit. You jumped right into the thread with a wise crack instead of offering a resonable response like mile-o. I'm guessing I probably gored your sacred cow, like maybe you are gay? I wonder what really happened at the cake store...

Ugh... The worst part is they probably want their data from the old, poorly designed database to work with the new stuff...

I see, so it had nothing to do with the topic, you were just trying to make the point of how narrow minded I seem to be. Got to go Libre, thanks for the lively discussion. Not getting much done here at work the last couple of days hanging out in the forum...

What will they do if they still refuse to make the cake, shut them down?

Agreed good starting points. But: a. You can normalize too much sometimes. A lot depends on the deployment. b. Somebody (read between the lines) needs to walk the business process(s) and understand and collect the business requirements, making it a point to not even mention a computer or database.

Sorry if you missed the point with the car analogy. And why do you make statements like the kidney thing? For a person who seems to want to be considerate of others you can be really condescending...?

We do get ice cream if we donate at work :)

If I own a car and two people want to buy it I don't want the goverment telling me who I have to sell it to. Pretty simple. Next they'll be wanting to tell me who to buy FROM - !

Hum... I'm stumped. Sorry...

You are correct. As a rule of thumb you should not save query results in tables...

Look at this and see if the const suggestion works in your code: http://bytes.com/topic/access/answers/833088-sending-email-cdo-access

So... I know this is going to be redundant but - Did you see if the barebone database/code worked on the machine that the original code works on?

in your bare bones test did you take things like [Action], etc? edit: Post your bare bones test code

Pitiful stretch Libre...

Access needs to know where the code is for the outlook objects. If you go: VBA window->Tools->References on the machine that does work and make sure you have the same ones checked in the machine that does not work ?

Have you checked to see if the references have been set up to see the outlook objects?

How many records total would you need to go through in one run of the query? You could create a function to do it...

Have you opened outlook and sent an email manually?

Have you tried stepping through the code as it executes?