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 Chriss Miller 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: *

  • Users: mastertorr
  • Order by date
  1. mastertorr

    CR 8.5 + Having Clause

    Thanks again LB for your time and help. Happy holidays and all the best in 2010.
  2. mastertorr

    CR 8.5 + Having Clause

    Thank you LB for your quick reply, it is greatly appreciated. How would one go about adding a SQL statement in 8.5? I believe in Crystal 2008 you have the 'Add Statement/Command' option under Database explorer? But i dont see this in 8.5.. Here is my current query: SELECT field1, count(field2)...
  3. mastertorr

    CR 8.5 + Having Clause

    I need to use a having clause in 8.5. I went to the Database > Show SQL Query, modified the select statement, but it wont save my changes. Is there another way to use a sql query in CR 8.5?
  4. mastertorr

    Datasheet View - ToolTips

    Didn't think there was a way from the table. Just figured i'd ask encase someone had discovered a way. Thanks for your reply.
  5. mastertorr

    Crystal Reports 8.5 - Describe table

    Thank you for your reply. Greatly appreciate it.
  6. mastertorr

    Datasheet View - ToolTips

    Im pretty certain, almost positive, this cannot be done, but figured i would ask. Is it possible to have a custom tool-tip when the mouse hovers over a field in datasheet/table view in access? Scenario: Field A holds a string such as "A12" When a person hovers over this field, a custom tooltip...
  7. mastertorr

    Error with Code - Using Listview

    No particular reason why i chose this version. I think I may have had too many references selected, so I deleted/unselected some of them. I then was able to figure out my issue using the listview (most recent version - not vb6 version). I will post how i resolved it later. Thank you for your...
  8. mastertorr

    Crystal Reports 8.5 - Describe table

    Having some trouble figuring this out. Was wondering if there is a way, in Crystal Reports 8.5, to describe a table in crystal reports? or print the field types (field name, string, 255 characters) for cetain tables? e.g. (FirstName, String, 255) or (Date_Of_Birth, DateTime) etc. Any help would...
  9. mastertorr

    Error with Code - Using Listview

    Control: Microsoft ListView Control, Version 6. ERROR: System.InvalidCastException was unhandled Message="Unable to cast COM object of type 'MSComctlLib.ListItemClass' to class type 'System.Windows.Forms.ListViewItem'. Instances of types that represent COM components cannot be cast to types...
  10. mastertorr

    Input Mask/Format - TextBox

    I have a text box on a form, which will accept the date in the format of mm/dd/yyyy. Is there a way to adjust the input mask to be mm/dd/4DigitCurrentYear (e.g. mm/dd/2009) so the year would be in the input mask by default? I have tried this: mm/dd/"2009" or mm/dd/2\0\0\9 as the input mask as...
  11. mastertorr

    Input Mask - Date

    Resolved myself. Just separated the date input into 3 separate textboxes (which i was trying to stay away from) but still works/same functionality)
  12. mastertorr

    Input Mask - Date

    Thanks for the reply. but I want to ignore the error do to the fact that partial dates can be entered. I put the form_error "exit sub",on the lost focus event of the textbox in question, i placed "on error resume next", but the error message still pops up. Any thoughts?
  13. mastertorr

    Input Mask - Date

    Is there a way to have a textbox with the input mask set to 99/99/0000, with the format set to mm/dd/yyyy, but allow the user to enter a partial date? such as just the day, just the day and month? When the textbox loses focus, it throws an error obviously.. but is there a way around this? Not...
  14. mastertorr

    Continuous Form: Trouble Scrolling

    btw, this form is set to data entry only, so i just want to be able to scroll up and down the form itself to see all the controls.
  15. mastertorr

    Continuous Form: Trouble Scrolling

    I have a continuous form set up with all my information in the detailed section. The height of the detailed section is 11.6146 (not sure if this helps). The form itself is comprised of large amount of textboxes, labels, group option boxes, lines etc. When scrolling in form view, the form barely...
  16. mastertorr

    VB6 + MySql: Row cannot be located for updating

    Mistake should be: If rs!new_value_on_form <> rs!current_value_in_table or isnull(rs!current_value_in_table) then rs!current_value_in_table=rs!value_on_form boolean = true End if NOT: If rs!new_value_on_form <> rs!current_value_in_table or isnull(rs!current_value_in_table) then...
  17. mastertorr

    VB6 + MySql: Row cannot be located for updating

    Mistake should be: If rs!new_value_on_form <> rs!current_value_in_table or isnull(rs!current_value_in_table) then rs!value_in_table=rs!value_on_form boolean = true End if NOT: If rs!new_value_on_form <> rs!current_value_in_table or isnull(rs!current_value_in_table) then rs!value_on_form =...
  18. mastertorr

    VB6 + MySql: Row cannot be located for updating

    Im not sure if you found a solution yourself, but i managed to get around this by: dim a boolean. check to see if the value in the table is different from the new value (say on your form), if they are different, set the boolean to true. at the bottom of my code, where its quite lengthy, if the...
  19. mastertorr

    Check for updates feature: Best way to go about adding

    Thanks again. Appreciate everyones help once again. I'll be testing this out over the next while so hopefully it'll be successful.
  20. mastertorr

    Check for updates feature: Best way to go about adding

    Thanks everyone for your help. I greatly appreciate it. One thing I am curious about is how to download the new updated file(s) (if there is an update) and replace it(them) with the old one(s).

Part and Inventory Search

Back
Top