Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ksquared

    Last Case Number from Sharpoint List.

    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...
  2. Ksquared

    Increment Control Source of text box.

    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...
  3. Ksquared

    Hlookup with Variable.

    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...
  4. Ksquared

    Tricky Import Problem

    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...
  5. Ksquared

    Group within Top N

    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 .... :)
  6. Ksquared

    Seagate Info V's Crystal 9.0

    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!
  7. Ksquared

    Oracle8 ODBC password

    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!
  8. Ksquared

    Oracle8 ODBC password

    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
  9. Ksquared

    Blank reports

    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...
  10. Ksquared

    Mail with weird time stamp.

    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
  11. Ksquared

    Mapping to floor layout

    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
  12. Ksquared

    Trading day

    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!

Part and Inventory Search

Back
Top