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!

Recent content by mastertorr

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

Part and Inventory Search

Back
Top