Creation of mlutiple records

2007-09-26 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I have a requirement to allow users to add multiple billing areas to a change request. Currently, they click a button called Add Billing Area, which opens a dialog called Change Bill Area. The user selects a billing area id from a character field with a menu attached

Re: Creation of mlutiple records

2007-09-26 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Pick two. On 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] wrote: ** Listers, I have a requirement to allow users to add multiple billing areas to a change request. Currently, they click a button called Add Billing Area, which opens a dialog called Change Bill

Re: Creation of mlutiple records

2007-09-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] wrote: Thanks Carey, Would something like this work? I was thinking of maybe using

Server change *RESOLVED*

2007-10-02 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Nevermind :) Just changed the name in the ar.cfg file and everything worked fine. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6478 / Comm: 334-416-6478 ___ UNSUBSCRIBE or access ARSlist

Server change again

2007-10-04 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I sent an email earlier about a server change and an ensuing name change before we added it to the domain. Basically we had set up the new server with a different computer name usaf-aeahnhd04i (full arserver install, email engine, SQL server, etc.) and right before we went live, we

Re: Server change again

2007-10-04 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
the email engine. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Thursday, October 04, 2007 9:46 AM To: arslist@ARSLIST.ORG Subject: Server change again ** Listers, I sent an email

Re: TR, DB, and nothing

2007-10-04 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
'FieldName' = Current value of the field 'TR.FieldName' = Current value of the field if it has changed, else the value is null. 'DB.FieldName' = Value stored in the database. Obviously, this value does not exist on submit. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN:

Re: Table Loop push fields

2007-10-12 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
? You do not see these columns in the available list to map to do the push field operations while creating your Active Links? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ

Re: Table Loop push fields

2007-10-12 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Friday, October 12, 2007 8:35 AM To: arslist@ARSLIST.ORG Subject: Re: Table Loop push fields Yeah, I think it just turns out I'm nowhere near the sharpest tool in the shed. I

more email problems

2007-10-23 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Dear listers, We're having some problems today with emails backing up in the email messages form. Occasionally we'll lose connectivity to the exchange server and the emails start backing up. In that case, we generally restart the email engine service once connectivity is restored

Re: more email problems *RESOLVED*

2007-10-23 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
was to upgrade the Outlook client to the 2007 version. Additionally, you need to ensure the outlook client is not running in cached mode. Thanks, Andrew Baxter From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent

Re: more email problems *RESOLVED*

2007-10-24 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
resolution as we are facing the same issue. Thank you, Dave. McManus Michael A SSgt HQ 754 ELSG/DOMH wrote: Odd. Looks like there was an email stuck in the outbox of the mailbox we're using. Apparently that was causing the emails to queue up in the email messages form? We sent

Crystal Reports

2007-11-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I know this isn't exclusive to AR System, but I figured it's as good a place to ask as any. Is anyone out there using Crystal Reports that can email me off list? I've never used it before and am having some issues with a requirement I have. Thanks much, Michael A.

Load Balancing

2007-12-12 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Dear listers, We're in the process of a 7.0 upgrade and a new hardware configuration and we're trying to explore our options. I figured this is likely the best place to ask the pertinent questions. We just bought 3 new servers, and the plan was to set up a server group to help

Re: Load Balancing

2007-12-13 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
balancer and ar configurations and has some directions and instructions for server group settings. You should be able to get it form the support site. Regards Robert - Original Message From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday

Licensing Issues

2008-01-10 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Hey all, We're in the process of upgrading to 7.0 and implementing a server group and I'm running into a few problems with licensing. I've been on and off the phone with BMC licensing to no avail. We have two new servers that I was going to set up as a server group and a third

AR System SSAA

2008-01-11 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Hey all, I know this probably doesn't pertain to most of you, but this is the best way I could think of to reach DOD/USAF Remedy administrators. My Project Manager is trying to find out if anyone is using AR System 7.0 at any military installations, and if there are, have you

Object Owners?

2008-01-15 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, This is a new one for me, so forgive me if it's painfully obvious. I can't recall the exact point we noticed this problem (and as such, what changed at that time) but for the last few weeks or so, I've noticed that everytime I make a form change, or create a new form, the

Adding ITSM modules on top of an existing AR System Application

2008-02-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I know zero about ITSM, but I was asked this question by my PM and I have no idea how to answer. Is it possible to add the Asset Management, or Change Management, etc. on top of an existing AR System application, and if so, what else needs to be in place to make it

Re: Interview questions

2008-02-22 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Hate to beat a dead horse but ( 'TR.Fieldname != $NULL$ ) AND ( 'Fieldname' != 'DB.Fieldname' ) I want the filter to fire if the transactional value -- i.e., what the user just entered in the field -- is not null, *AND* it's different from what's in the database. I don't think this is

Changing SA passwords

2008-02-25 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, A couple of our servers were identified in a scan the other day as having weak sa passwords for SQL Server. We've been told to change them, but I want to be sure that it's not going to stop AR System from functioning correctly. I imagine there's a setting for the sa

Re: Changing SA passwords *RESOLVED*

2008-02-25 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, February 25, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Changing SA passwords ** Listers, A couple of our servers were identified in a scan the other day as having

Re: Weird field ID issue

2008-04-04 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Thursday, April 03, 2008 1:47 PM To: arslist@ARSLIST.ORG Subject: Weird field ID issue ** Listers

Advanced Search Bar

2008-04-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Dear listers, It's been some time since anyone on my project has been to the performance and tuning class and we're having some performance issues at peak times. I'm sure we're getting killed in multiple areas (QBE settings, Indexing, etc.) but one of the questions I was asked is

Re: Advanced Search Bar

2008-04-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, April 07, 2008 13:42 To: arslist

Re: Adjusting Menu Access with Workflow?

2008-05-02 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Friday, May 02, 2008 12:33 PM To: arslist@ARSLIST.ORG Subject: Adjusting Menu Access with Workflow? Listers, On our Incident form, we

Adjusting Menu Access with Workflow?

2008-05-02 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, On our Incident form, we apparently have some users with access to the Modify All command through the Actions Menu. If I go to the view properties on the Incident form, on the menu access tab, Modify All is unchecked. Is there a way to override that setting with workflow

Re: Adjusting Menu Access with Workflow?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Friday, May 02, 2008 12:33 PM To: arslist@ARSLIST.ORG Subject: Adjusting Menu Access with Workflow? Listers

Mid-Tier ?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, We had some major problems over the weekend, and for all intents and purposes, our mid-tier server is nothing short of hosed. I'm completely brand new to installing one of these, but I figured the best route would just be to install mid-tier on another server. I got IIS

Re: Mid-Tier ?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Remedy Developer HQ 754 ELSG/DOMH -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, May 05, 2008 3:04 PM To: arslist@arslist.org Subject: Mid-Tier ? ** Listers, We

Re: Mid-Tier ?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, May 05, 2008 4:09 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier ? Sorry, forgot to include the requisite info. OS is Server 2003 DB is SQL 2k AR Server is 5.1.2 I

Re: Mid-Tier ?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, May 05, 2008 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier ? So I went with the 5.1.2 mid-tier installer which comes bundled with the servlet exec (I had heard you could

Re: Mid-Tier ?

2008-05-05 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
configuration page? If yes, make sure the web application for the midtier is configured. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, May 05, 2008 3:40 PM To: arslist

Re: ITIL Remedy

2008-05-06 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
AR Server is like that famous burger slogan, you can have it your way, as long as you write the code, yourself. If you don't want to follow ITIL, don't get ITSM, develop your own applications. Isn't this the problem though? In many cases (including one we're going through right here at

Re: Mid-Tier ?

2008-05-16 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Atlanta ServletExec...they're designed to work with Tomcat. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, May 05, 2008 4:09 PM To: arslist@ARSLIST.ORG Subject: Re: Mid

Re: Mid-Tier ?

2008-05-16 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
unless otherwise indicated -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Friday, May 16, 2008 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier ? Sorry for the delayed response

LIKE qualifications in 7.0

2008-06-18 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
We're in the process of upgrading our AR System Server and Clients from version 5.1.2 to 7.0.01 and I've run into a bit of a problem. I was asked to upgrade my User and Admin tools to 7.0.01 on my PC for testing purposes, and to draft an implementation plan. Our server is still 5.1.2 but I

Re: LIKE qualifications in 7.0

2008-06-19 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, June 18, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: LIKE qualifications in 7.0 We're in the process of upgrading our AR

Re: LIKE qualifications in 7.0

2008-06-19 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
be a more consistent solution between ARS versions. --Thomas - Original Message - From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 7:23 AM Subject: Re: LIKE qualifications in 7.0

Re: LIKE qualifications in 7.0

2008-06-19 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
. As to why your original syntax (using the concatenation operator between the search value and the wildcard characters) didn't work in your 7.0.1 client, is still a mystery to me. - Original Message - From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] mailto:[EMAIL PROTECTED

Re: LIKE qualifications in 7.0

2008-06-19 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
I discovered the initial problem with a 7.0.01 client against the 5.1.2 server. I thought that may have been the problem so I used the 7.0.01 WUT against our 7.0.01 dev server. Still got the same behavior. Neither the WUT nor the server is patched though. Our database is SQL 2000 SP4 build

Deleting Indexes in the WAT

2008-06-26 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I'm in the process of modifying some indexes and I've run into a small problem. For some reason, I have some indexes that were created in the database before they were created in the WAT and some that were deleted from the database but not the WAT. Consequently, when I

Inconsistent workflow between WUT and Mid-Tier

2008-08-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, We've been going through some test scripts of late in preparation for our upcoming upgrade to 7.0 and we noticed a workflow problem as it relates to the mid-tier. This is all pretty clunky so bear with me, and I'll do my best to describe the problem. Scenario: Analyst

Re: Inconsistent workflow between WUT and Mid-Tier *RESOLVED*

2008-08-08 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Aug 7, 2008 at 3:54 PM, McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] wrote: ** Listers, We've been going through some test scripts of late in preparation for our upcoming upgrade to 7.0 and we

Anticipated timeframe for an AR Server Upgrade?

2008-08-22 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, We're upgrading our AR Server tonight from 5.1.2 to 7.0. A direct upgrade didn't appear to be working so I went with 5.1.2 to 6.3. I kicked it off about 6 hours ago and it still appears to be steadily chugging along at the Upgrading the AR System Database screen. I did

Re: Anticipated timeframe for an AR Server Upgrade?

2008-08-25 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
. If it did work previously time frame is difficult to know since all forms and workflow will be touched. -Original Message- From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Sat, 23 Aug 2008 12:56 am Subject: Anticipated timeframe for an AR Server

Problem importing records

2008-08-26 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, So it appears the problem with our upgrade and it's ridiculous length was the user form (and the user_cache). When the system was conceived, the original developer used the User form as a User form and a Customer form so we're looking at 555000+ records in the User

Re: Problem importing records

2008-08-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
: Tuesday, August 26, 2008 5:47 PM To: arslist@ARSLIST.ORG Subject: Re: Problem importing records ** I'll give you a hint: Multiple NULL values will trigger the duplicate key errors as well. Rick On Tue, Aug 26, 2008 at 3:37 PM, McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] wrote

Re: Problem importing records

2008-08-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
and pushing data to another form. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Tuesday, August 26, 2008 5:37 PM To: arslist@ARSLIST.ORG Subject: Problem importing records

Re: Problem importing records *RESOLVED*

2008-08-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, August 27, 2008 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: Problem importing records Arsql.log? I'm looking at the arimport.log but it's really not helping. Just tells me the same thing that the error message that pops up

Re: Problem importing records

2008-08-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
. Thanks much, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Wednesday, August 27, 2008 9:27 AM To: arslist@arslist.org

Supportweb License File Upgrades

2008-08-28 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, Has this feature ever worked for anyone? I've tried several times in the last two days and never gotten an upgraded license file back. Thanks, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH

Qualification failing on the mid-tier

2008-08-29 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, We finished our upgrade to 7.0 last night but now we're having some workflow issues on the mid-tier. The following qualification is failing when it should pass and now our Analysts can't create user records: (($GROUPS$ = Analyst ) OR ($GROUPS$ = Team Chief )) AND ((

Re: Qualification failing on the mid-tier

2008-08-29 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Sorry, scratch that % before 560. Everything else is the same. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent

Re: Qualification failing on the mid-tier *RESOLVED*

2008-08-29 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Friday, August 29, 2008 12:33 PM To: arslist@arslist.org Subject: Re: Qualification failing on the mid-tier Sorry, scratch that % before 560. Everything else is the same. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH

Re: $PROCESS$ Application-Bus-Time-Diff and ARERR 4568

2007-05-29 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
From the 6.3 Advanced Guide: Use the following syntax for the Application-Bus-Time-Diff calculation: Application-Bus-Time-Diff StartTime EndTime HolidayScheduleName WorkdayScheduleName The startTime and endTime parameters are required in this command. Other fields are optional and

Re: Error message

2007-06-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
It's dependent on the indexes defined for the form in question so you'll have to check. Open your form properties and look at the indexes tab for unique indexes. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6478/Comm: 334-416-6478

Problem reassigning ticket

2007-07-03 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Hey Listers, I'm having an odd problem with a couple of our users that are trying to update tickets. For some reason, when they update a ticket and try to reassign it to someone else, they're getting an ARERR 1602. My log files contained the following: ACTL Checking INC:Validate

Logging changes

2007-07-09 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Dear Listers, I'm looking for a more elegant solution to a new requirement. Currently on our incident form, we have a tab called account management with about 15 checkboxes (Reset Password, Unlocked Account, Updated Email Address, etc.) for ticket tracking purposes. The

FW: Logging changes

2007-07-09 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Sorry, forgot to include in the original message that we're on 5.1.2. I know there exists an audit feature in 7.0 that I think will do this for me, and we have plans to upgrade in the relatively near future, but this is apparently a priority. Thanks, Dear Listers, I'm looking

SQL help

2007-07-19 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
So I stink and SQL and I imagine it's a syntax error so I figured I'd check here. We have a field on our incident form that tracks the total number of passoffs a ticket goes through. Currently it's not working so I'm trying to make it happen. Here's the SQL I'm trying to use. SELECT

More SQL Help

2007-07-26 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Listers, I'm running into more problems with SQL so I figured I'd check here again. Here's the initial query: SELECT COUNT(*) AS Total FROM Session_Tracking WHERE Incident_ID = '$Incident_Number$' AND PassOffReason IS NOT NULL This works perfectly. When the user tabs over to the

Re: More SQL Help *RESOLVED*

2007-07-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: 27 July 2007 13:27 To: arslist@arslist.org Subject: Re: More SQL Help It's a character field I created

Re: More SQL Help

2007-07-27 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/26/2007 01:19 PM Please respond to arslist@ARSLIST.ORG To arslist

Exporting data

2007-08-08 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
I'm trying to export some data from one of our forms into a .csv but when I open the form in search mode, the reporting option is grayed out of the tools menu. It's specific to that form so I'm sure it's an Admin setting but for the life of me I can't figure it out. Thanks, Michael A.

Re: Exporting data

2007-08-08 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
option. HTH Phil Bautista President / CEO Bull Creek Data Corporation www.bullcreek.com Remedy Approved Consultant (RAC) 512-731-0304 -Original message- From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] Date: Wed, 8 Aug 2007 16:40:27 -0400 To: arslist

Re: Exporting data *RESOLVED*

2007-08-08 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
-Original message- From: McManus Michael A SSgt HQ 754 ELSG/DOMH [EMAIL PROTECTED] Date: Wed, 8 Aug 2007 16:57:07 -0400 To: arslist@ARSLIST.ORG Subject: Re: Exporting data Thanks for the help guys. Now a new silly question. The table contains 18 75 records. How I can