Incredibly powerful! Thank you for the great example. Awesome stuff!

Kevin

Forgive me for being thick, but where/how can I get the client component?

I have a CD for Reporting Services (from the Microsoft Action Pack) and have installed on my server...

Can you post the SQL in your Access query?

Regarding Andy's method not working, what exactly isn't working? What error messages are you getting and where in your code? Or is it that the code runs without error but...

Hi!

I agree that Helen Feddema's site is a great source for code with Access and other MS Office products.

Regarding Richard's suggestion, the SendObject method of DoCmd in Access will attach...

In looking up CASE functions in SQL Server BOL, it appears that there are two different types of CASE functions: simple and searched.

Simple is to be used when you're comparing...

Steve,

In the 3/22/05 edition of SQL Server Central you asked for comments on the SQL Server STandard March periodical. Here's a comment:

Holy [beep]! I have never read content that is...

Replication is really the only direct way to do exactly what you want if you're looking specifically for a "partial backup". That can be done locally (on a single computer),...

Are those capabilities mentioned for ERWin the same type of features that I believe exist in Visio?  If so, that's more affordable for me (since I already have that).

And thanks...

I have a follow-up question to what's been said here.  I work a lot with Access (and the suggestions above are correct for correcting the bloat).

I'm about to start working...