Recent content by dpatfield66

  1. dpatfield66

    Question Dynamic .rdlc field formatting

    How can I get my program to dynamically hide a label and cooresponding field at runtime. I basically need to edit the XML to change properties of the fields in question, but dynamically. My report is a .rdlc file and I use reportviewer. I can already set the data source, and the report's...
  2. dpatfield66

    Dropping Constraints conditionally

    Thanx! Thanks, Matt! I found something similar finally, but this is close too.
  3. dpatfield66

    Dropping Constraints conditionally

    I have 2 scripts that produced a default constraint with different names for the same field. Ex: Script 1 added [DF_OBAdmit_Field1] Script 2 added [Field1] Now I want an upgrade script that drops this constraint, but I want the command to be conditional: IF (CONSTRAINT NAME =...
  4. dpatfield66

    Question Tab Pages and child controls

    If I have a control on a particular tab page, how can I get the index of the tab page. Example: I have a tab control with 3 tab pages tabpage1 (Index = 0) tabpage2 (Index = 1) tabpage3 (Index = 2) Not to be confused with the actual Tab Index of each page (which could be 22, 16, 4, or any...
  5. dpatfield66

    ReportViewer Print Layout button

    Can anyone tell me how to programmatically set the viewing mode in a reportviewer to print layout (as if the user had clicket the print layout button on the toolbar)? I want it to go to print layout automatically.
  6. dpatfield66

    Same Controls for one Event Handler

    This works great, thanks. I've just learned another OOP concept. I'm sure it's a basic one, but we all operate on different levels. Thanks so much!
  7. dpatfield66

    Same Controls for one Event Handler

    Currently I drag and drop the combobox (standard MS one) onto my interface and Microsoft creates all that behind-the-scenes stuff to add it to my form. Should I basically replace part of this code with my own named new cbo class? And If I do, I'm still not sure what I'm supposed to add to the...
  8. dpatfield66

    Same Controls for one Event Handler

    Inheriting So, if I create this special combobox class, how would the comboboxes that I've added to my form know to belong to this class? And what exactly am I putting in this class again...assuming that my click event was this: Public Sub Combobox_click (ByVal sender...etc) Handles...
  9. dpatfield66

    Combo Box Dropped Down (On Enter or GotFocus)

    Dummy's level Ok, I'm at a dummies level, sorry... What I want to do is avoid typing all 50 comboboxes like this: Public Sub Comboboxes_Click(ByVal sender as...etc) Handles cbo1.click,cbo2.click, etc... I want to try some code elsewhere that says...for ALL my comboboxes cbo1 thru cbo50...
  10. dpatfield66

    Combo Box Dropped Down (On Enter or GotFocus)

    Comboboxes in click event I'd like to revisit this. Can you elaborate on how I could get all comboboxes to do something when the user clicks them? I'm in the dark on the whole addressof thing, so can you start from scratch and tell me exactly what I'd need to do? Thanks for your help.
  11. dpatfield66

    Same Controls for one Event Handler

    Does anyone know how I can make sure all controls of the same type (for example (all combo boxes OR all text boxes with the tag, "Same") are handled at a particular event. For example: if I want ALL combo boxes to do something when the user clicks on them, rather than name every single combo...
  12. dpatfield66

    DatePickers with NULL Dates and/or Times

    Ok, I've asked this before, but let me try again... Can ANYONE tell me how to create a datepicker control that allows for NULL dates and/or times? PLEASE don't give me gobbledegook stuff that blows my mind. I'm a good programmer but excess code-related garbage just doesn't compute with me...
  13. dpatfield66

    Programmatically Printing rdlc files

    I have the following code below and printing is working fine: However, the program keeps dropping an EMF file (.emf) in my C drive, for every page of the report! I see in the code <OutputFormat>EMF</OutputFormat>, but if I remove this, the program does not work. If I remove the entire section...
  14. dpatfield66

    Complex Queries

    The Schema of the Admit and Triage tables are not exactly alike, so and asterick would not work. But there are many similar fields in both tables. To simplify I'll say this: Both tables have MRNumber, PregnancyID, Encounter, RecordComplete,AdmitDate, and let's say Field1 and Field2 (to...
  15. dpatfield66

    Complex Queries

    I got this to work by setting an alias: SELECT DISTINCT MRNumber,PregnancyID,Encounter FROM (SELECT 'T' AS Type,MRNumber,PregnancyID,Encounter FROM OBTriage UNION SELECT 'A' AS Type,MRNumber,PregnancyID,Encounter FROM OBAdmit) as uquery ORDER BY MRNUMBER,PREGNANCYID,ENCOUNTER If I remove <as...
Top Bottom