1) I've managed to get to the point where I can select "ALL" records from a table, or only those for which a user has security for (partial 'All').

2) What...

Thanks Gianluca

Now that I have the VBA call working correctly (and know why it wasn't working) I can shift my attention from problem solving to future proofing.

I had kept your...

Jeff, I really appreciate the time you've taken to look at this; as that was exactly the issue.

Very much appreciated (and red faced for missing a basic date conversion principle)....

Thanks Jeff; I managed to work out how to send the date/time without the periods.

However, even as this:

"EXECUTE qDbReports '2010-17-12 07:56:52 AM', '2010-17-12 07:56:53 AM', 88, 1"

I still receive...

Thanks Jeff.

I appreciate your reply (as I can't beleive I missed that! but when you look at two differences a lot I guess that happens!).

I'll see if I can pass...

Thanks Gianluca

I'll take a look and see what I can work out.

I'd still quite like to know why the string passed to SQL only works with date values and fails...

We have a number of functions that have been built with differing permutations of parameters, allowing us to call any stored procedure from these functions.

It seemed to make the most...

Where I create a value for (All), SELECT 0 AS Dpt_GroupId, '(All)' AS Description, @User AS Hr_RecordId WHERE @SecCond > 0

is it possible to replace the value of '0'...

Thanks shield_21, yes this is similar to my other post (I want to address a similar concept on another database).

I have a list that is populated by a procedure (below).

This...

Thanks for the feedback!

I'm just working through these two options and how I might be able to implement them.

I'll post back what I'm working on as soon as I get...

That's exactly what I'm after! Thanks shield_21

I need to do some testing on implementing this as it gives me greater options on the AuditLevel that I don't have in my...

Yes, used to select records by filtering them, or reporting records by type, and logging a record type based on what types the user can select.

If I modified the table...

Thanks for the clarification Scott - yes I had picked up on that in your earlier post.

Would it be more efficient to add one column to the existing table and...

Thanks Scott, yeah I'd thought the best option (not my first thought however...) was to add a column tot he table to handle levels of auditor. I could then handle...

I've actually found this article http://www.sqlservercentral.com/articles/T-SQL/65423/ to be really helpful as well.

I added the criteria

in (SELECT HolidayDate FROM DbHolidays WHERE Location = @LocationId)))

and

@LocationId int

to that on...