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!

  • Congratulations strongm 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. CAPiTA

    Clear Text Box When Tabbed To

    Is there a function similar to Click that will clear a text box when the user tabs their way to it? Private Sub txtTol_Max_Click() txtTol_Max = Empty End Sub
  2. CAPiTA

    Display "Loading" In Label While Loading DataEnvironment

    I tried the following and got the same result. Is the syntax right? Dim Str1 as String Dim Str2 as String Private Sub Form_Load() Str1 = "Ready" Str2 = "Loading Data..." End Sub Private Sub Combo1_Click() If Combo1 = 001 If Not Label1.Caption = Str2 Then Label1.Caption = Str2...
  3. CAPiTA

    Display "Loading" In Label While Loading DataEnvironment

    I have a cbo on a form that loads a large dataenvironment. It takes 20-40 seconds to load the data, during which time I want a label on the form to display "Loading Data...". I've tried the following code, but the label goes blank when the data is loading. What did I do wrong? Dim Str1 as...
  4. CAPiTA

    Populate Combo Box With Field From Data Environment

    I have a combo box named cboPrt_Num and a data field BladeName from DataEnvironment1.Blade_Name. I want the values of this field to populate the combo box, but only the first value appears. How do I get all the values to display?
  5. CAPiTA

    Moving Average In Crystal Reports 8?

    Are these chart options only available in later versions of Crystal Reports?
  6. CAPiTA

    Chart of Moving Average

    Also, I'm using Crystal Reports version 8.
  7. CAPiTA

    Chart of Moving Average

    I am trying to create a chart that would display a moving average of my data. The fields look like this: Parts.PartID Parts.Offset 001 0.521 002 0.545 003 0.567 004 0.509 005 0.523 ... I am a...
  8. CAPiTA

    Combine Data From Multiple Access Databases - CR 8

    Can you be more specific about what exactly to do with this: SELECT [TABLE1].[ID], [TABLE1].[OFFSET] FROM [TABLE1] UNIONALL SELECT [TABLE2].[ID], [TABLE2].[OFFSET] FROM [TABLE2];
  9. CAPiTA

    Combine Data From Multiple Access Databases - CR 8

    Is it possible to combine data from several Access databases (with identical tables and fields, but with different data) into one report? Example: Database1 Products ID Offset #001 0.1 #002 0.2 #003 0.3 ... Database2 Products ID Offset #001 0.4 #005 0.5 #008 0.6...
  10. CAPiTA

    3 Decimal Places in Parameters - CR 8

    That's not the problem. When I Edit Parameter->Set Default Values->Select or enter value to add: and I enter something like 0.045, I get the error message displayed above. Formatting the object will make three decimal places display, but the last decimal will just be zero (i.e. 0.040 rather...
  11. CAPiTA

    3 Decimal Places in Parameters - CR 8

    Is there any way to allow numbers with more than two decimal places to be used as a report parameter? When I try to use a thousandths digit I get this error message: "Please enter only up to 2 decimal place(s) as shown in the number format
  12. CAPiTA

    Large Database - Slow Processing Fixes?

    Verify Database shows the database is up to date.
  13. CAPiTA

    Large Database - Slow Processing Fixes?

    i am using Crystal Reports Version 8 and the database is Access. Report->Edit Selection Formula->Record... displays: {Product.BladeName} = {?ProductID} "Show SQL Query" was grayed out in the Database menu. so far, all i have tried is it insert a paramter based on the field Product.BladeName...
  14. CAPiTA

    Large Database - Slow Processing Fixes?

    hello, i am dealing with a very large database of individual part information (n x 100,000 parts). the data only needs to be analyzed by specific part numbers (~50 part numbers), making the amount of data needed at any one time quite a bit less. i set up a parameter to seperate the data by...
  15. CAPiTA

    User Interface, View Report Content Dynamically?

    hello, i was given the task to create an interface to make viewing and analyzing data easier. the data is to be gouped and analyzed by a user-specified part number, and calculations are to be made based on certain tolerances entered by the user. i can get CR to do this from within the...

Part and Inventory Search

Back
Top