Search results for query: *

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

    Complex Queries

    In my previous email and code example, it looks like SELECTCOUNT is one word, but I copied it wrong. It's actually two words in the code. SELECT COUNT Just an FYI
  17. dpatfield66

    Complex Queries

    Select Count,etc... I tried the following code: SELECT COUNT(DISTINCT MRNumber, PregnancyID,Encounter) FROM (SELECT MRNumber,PregnancyID,Encounter,'T' AS Type FROM OBTriage Where RecordComplete = 1 UNION SELECT MRNumber, PregnancyID,Encounter,'A' AS Type FROM OBAdmit Where RecordComplete = 1)...
  18. dpatfield66

    Complex Queries

    Difficult Problem... Thanks for the code advice, I'll check it out. As for single tables and alternatives, I have to go by what the boss wants, but thanks for the ideas in that area, no problem. As for not seeing what the difficult problem is, sometimes as programmers we're so versed in what...
  19. dpatfield66

    Complex Queries

    I'm not sure I follow your example. Can you elaborate. I know how to create the UNION query, and then create another query that takes the UNION query and eliminates certain records, but I can't figure out how to do it in one single query. In other words...a simple UNION query produces the...
  20. dpatfield66

    Complex Queries

    I agree with the one table idea, but the company wants two. Due to marketing module reasons, although I still think you could get away with one table even in that scenario. However, I've learned to let that go. The Admit and Triage tables are very similar. Sometimes we create a new admit or...
Back
Top