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. Barrow66

    Stored Procedure

    When is it necessary to use a table variable, a temp table and a derived table in a stored procedure? Does it depend on the total number of records. Lets say the Stored Procedure1 returned 10,000; Stored Procedure2 returned 100,000 and stored procedure3 returned 1,000,000,000 rows. When...
  2. Barrow66

    Insert into problem

    Insert into problem I have information in table variable as: Table1 Location Letter Amount 12 A 0 12 B 0 12 C 1 The information above placed in another table variable must look like: Table 2 Location Letter Amount 12 A 1 12 B 1 12...
  3. Barrow66

    Calling An exe from VB

    How can one call another exe application from a visual basic environment using command line ?
  4. Barrow66

    Grouping Help

    I have a report that has column name CurrentVBDate. I want to populate this column (CurrentVBDate) with data from other columns. The other columns are PreviousVBDate, NextSequentialVBDate and NextSequentialVBDate. I am using CR8.5. Any assistance will be appreciated and thanks in advance for...
  5. Barrow66

    Drill Down

    Hi There, Can someone tell me how to create a group tree in CR8.5 when a main report has a sub report in it's footer section. Is there a way of showing a group tree when a sub report is embedded in a main report. I need to drill down based on the first group header in both report...
  6. Barrow66

    Maximum users in Access97

    I am using Access in a multiuser environment. The database is used for users accessing information by calling into the system.Users at the same time run reports and do package ordering. The database get corrupted many times in a day. How can this be averted. How much users can access accomodate...
  7. Barrow66

    Drill-Down

    Both some clients we use ASP and the other strict URL.However we are trying to Standardize through ASP code
  8. Barrow66

    Drill-Down

    Web.
  9. Barrow66

    Drill-Down

    I need to drill down without showing the drill-down box for users. All what the user need to do is to click on the header and see all its contents. For example, Group = Country, Second Group = Site. Country is USA and Sites are 123, 456, 789, 800. I need users to click on USA on the report to...
  10. Barrow66

    Immediate II()

    Is there a way of implementing immediate ifs(IIF()) within immediate ifs(IIF()) in access queries. For example, If visit4Days and visit5days does not fall within demand days then order 1. If visit4days and visit5days does fall within demand days then order 2. I have four fields that get...
  11. Barrow66

    Greater than sign

    Thanks. I actual want to use UNICODE.But I do not know how.
  12. Barrow66

    Greater than sign

    Any ideas on how to print or show greater than equal to sign. I do not mean >=. I mean greater than > and the equal to sign is -. Then minus sign needs to be below the greater than sign. Thanks in advance.
  13. Barrow66

    print a symbol ( ¡Ý ) to an ASCII Text file using VB6

    How can I use UNicode2265 in vb. Is it like Chr(2265)? Thanks inadvance
  14. Barrow66

    print a symbol ( ¡Ý ) to an ASCII Text file using VB6

    I need the >- sign. The - must be below the > sign.
  15. Barrow66

    print a symbol ( ¡Ý ) to an ASCII Text file using VB6

    Can anyone please help?????
  16. Barrow66

    Background color for detail section

    Hi Naith, I placed one box to cover the first two column fields on the report and another to cover the rest of the report after the sixth column. The color of the boxes set to white and only the four column fields I needed colored were colored and the rest was white-out. Thanks for...
  17. Barrow66

    Background color for detail section

    Hi Naith I do want all fields displayed but only the last four columns must be highlighted as noted above based on the formula. Thanks.
  18. Barrow66

    Background color for detail section

    Hi Naith, I cannot find in the Box format editor conditional formatting. Is there a way of finding this out so that I can place my formula to color last four columns . The formula is : IF({TableName.Fieldname} <> NEXT({TableName.Fieldname }) ) THEN crwhite else crsilver ONCE AGAIN THANKS...
  19. Barrow66

    Background color for detail section

    Hi Naith, Yes I am using the box in cr8.5 Sorry for being a pain but I inserted the box control from crystal 8.5 into the detail section but not formula(x+2)appeared. Is there another way to insert a box in crystal 8.5.
  20. Barrow66

    Background color for detail section

    As long as the tablename.fielname not equal to next tablename.fieldname then White else gray. Is there a way for the box to show white or gray based on this condition in the datail section.

Part and Inventory Search

Back
Top