Re: Suppressing Remedy Macro errors

2007-12-28 Thread Martinez, Raul (ISD, IT)
Its probably a much bigger ice burg than it appears at its tip... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 28, 2007 9:49 AM To: ar

Re: Suppressing Remedy Macro errors

2007-12-28 Thread Martinez, Raul (ISD, IT)
(RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Dec 28, 2007 8:38 AM, Martinez, Raul (ISD, IT) <[EMAIL PROTECTED]> wrote: > ** > > > > Is there anyway to do this on

Re: Suppressing Remedy Macro errors

2007-12-28 Thread Martinez, Raul (ISD, IT)
ailto:[EMAIL PROTECTED] Behalf Of Martinez, Raul (ISD, IT) Sent: Thursday, December 27, 2007 3:53 PM To: arslist@ARSLIST.ORG Subject: Suppressing Remedy Macro errors ** Does anyone know how to suppress the Error box that comes up after you run a macro that

Suppressing Remedy Macro errors

2007-12-27 Thread Martinez, Raul (ISD, IT)
Does anyone know how to suppress the Error box that comes up after you run a macro that finds no valid data? __20060125___This posting was submitted with HTML in it___ * This communication, including att

Remedy SQL query assistance... Please Help.

2007-12-18 Thread Martinez, Raul (ISD, IT)
ry from within MS Excel? Crystal Reports? Also, If you're using an ARSystem ODBC driver the date conversion formula I gave you isn't necessary. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mart

FW: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
From: Zaldivar, Jack (ISD, IT) Sent: Friday, December 14, 2007 3:33 PM To: Martinez, Raul (ISD, IT) Subject: RE: Remedy SQL query assistance... Please Help. SELECT "HPD:HelpDesk"."Assigned To Group+", "HPD:HelpDesk"."Assigned To Individual+&qu

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
se are you using? On Dec 14, 2007 11:33 AM, Martinez, Raul (ISD, IT) <[EMAIL PROTECTED]> wrote: ** Yes there is a limitation in affect right now on the server. Here is an example of what we are doing, but of course the code is not 100% correct: said syntax error ? SELE

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
ces to unlimited while you run the macro. You probably don't want to go against the database itself. Remedy has a tendency to store dates as long integers based on the number of seconds since 1/1/1970. From: Action Request System discussion list(ARSList)

Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
Can anyone assist me in either in connecting an ODBC connection to Remedy through Access or with creating a SQL search query for $DATE$ function? I am needing to grab all submitted tickets for current day based on certain submitters. I already have a remedy macro created but it would be easier with