Search results for query: *

Here the scenario. We are using Share Point for our case management, and when we log a call we allocated a new case number (a list item) What im trying to do is send an email with a code in the subject line, which fires off a script which will run a query to get the last number used , then email...

Ive got my self into a corner. My user form has 30 + text boxes which populate their Conrtol source, and its all good. BUT... when it comes time to add another item (with its own text box) to the user form in between two existing textboxes, the Control sources will be out of sync. SO i'm...

Hello All. Having a go at some VBA Excel 2010, and hit a roadblock. If asmblyCode = Application.WorksheetFunction.HLookup(asmblyCode,Sheet3!B$2:!S$3', 1, False) Then So, im trying to do a lookup for the variable asmblyCode on sheet3 B2-S3 on the first row. I get a list separator or ) error...

I have column data whicn im trying to get in to data for each record. The data is layed out like.... LOCATION, STOCKPILE, PAD, X1, X2, X3, X4 abc 123 x 2 1 0 Im trying to get the data into the database like this.... abc,123,x,2 abc,123,x,1 abc,123,x,0 ...so for each of...

What i'd do is make a new field, using a formula, test the value of the $ field and give it a new value. (eg if $1,000 - $2,499 then 1 or if $2,500 - $4,999 then 2 and so on. Then you can group by and count this field .... :)

Anybody know the compatability between SI7.5 and CR 9.0? Particularly interested in Web based clients. Are there any issues with this version of CR? Peace!

I found the solution to my problem in Crystal Reports server. If your running the report through the reports server, there is a tab which hold these sort of variables. Peace!

Racking my brain trying to think of how the ODBC password can be hard coded either in the report or the ODBC settign themselve, so our user (god love 'em) dont have to input the password @ process time. Any ideas greatly appreciated! K2

Just installed SI 7.5. Installed the web client, put a report and db on the server to see what we could see. when i used the HTML viewer to generate the report, nothing came up except the report header. Used the Info desktop to view the same report....same thing. Used Crystal to run the same...

I have set up some cron job which fire off an email. When the mail arrives in Outlook (from an exchange box) the sent time is some hours in the future. Anyone know why this is happening? Or how to correct? The systime/date is as it should be. Thanks in advance

Id like to map activity against a map of the floor lay out. So as it shows pretty colours based on activity....etc. Which Map info product lets me make my own maps? Cheers

Im trying to create a report that when prompted for a date, instead of assuming the day starts and ends at 00:00, the trading day starts at 10:00 and finishes at 04:00 or 06:00 the following day. Any ideas would be most welcome!