thanks so much Michael!!!! , i put these code but i keep getting an error message that says Duplicate column name "Account Manager.Phone", any ideas why I am getting this...

thank you sooooo  much, i did what your link said to saved it as txt file and it works like a charm. thank you!!!!

got it to work!!!! thank you so much !

how can i check is there sufficient memory in my OS? and no in my sql server box i only have sql server enterprise , query analyzer and another software...

I did everything you told me to do but when i try to run the query it says odbcc call failed, error converting data type nvarchar to smalldate time. even...

thanks, i think i am in the right track.. so i created the form, i added two text boxes one for @begindate and another one for @enddate. now in the...

i also tried this:

EXEC myReport [Enter Beginning Date:],[Enter Ending Date:]

@begindate = "#" & format(me.StartDate,"mm/dd/yyyy") & "#"

@enddate = "#" & format(me.EndDate,"mm/dd/yyyy") & "#"

but did not work either

hello i tried modifying the pass through query to be:

EXEC myReport [Enter Beginning Date:],[Enter Ending Date:]

but like you say the validation does not work

it says odbcc call failed

error converting...

hi thanks but i tried and i get the error message:

Unable to connect to server win2k3-02

Server: Msg17, Level 6, State1

[Microsoft][odbc sq server driver][namepipes]sql server does not exist or access...

I did .... same error

thanks so much for helping me, I tried using another workstation and login in with my windows user id and password and yes i am able to log in to QA...

I am accessing all the drives of my workstation good and i have access to the network drives fine too. the problem is when i try to access a database...

anything else i could try?

i try changing it to nt network account but i get the same error and also, i have some jobs that have to work with the local/administrator account so i...

also i have kerberos authentication...