Search results for query: *

I'm wondering if anyone can explain this behavior. The example uses 2 controls on a form, comboBox1 & textBox1. Both of their Visible properties are true in the designer. When I step through the code I can see where the Visible property of each control changes to false after they are added to...

There have been times when I’ve needed a specific format for a DateTime value but don’t have the different style values memorized. Instead of doing a search on the CONVERT function each time, I created this query shortcut and thought I’d share. Go to (SSMS 2014) ... Tools > Options… >...

Before proceeding too far with this idea, I thought it might be good to get your thoughts here at Tek-Tips. There are a number of stored procedures here at work where a list of values is passed in as a comma-separated-values varchar or an xml parameter. This has always seemed messy to me, so...

I have a small problem with a program where, when I change the data source of a data grid view, if a column's header text changed only by case, the previous value is still displayed. I don't know if there's an explanation for this or if it is a bug. It is important that the heading show the...

Is there a better way to code the following comparison in a WHERE clause? WHERE ((@ParameterValue IS NULL AND ColumnValue IS NULL) OR (@ParameterValue = ColumnValue)) Normally when I accept a null parameter value I use it to mean I don't want to filter on that particular value but in this...

I am having a problem when rendering my reports to PDF. Text that will fit on one line onscreen is wrapping to a second line in the PDF version. Also, (Bold, Italic) headings appear close to okay when exported to PDF on the server from Report Manager (they're still wrapping) but my local version...

I'd like to change the default font from Arial to Calibri and, ideally, also default the height from 0.25in to 0.2in when creating a new text box. Does anyone know how to accomplish this?

Is there a way to create a report template such that the name of the .rdl file from which the report was designed from is automatically placed in a textbox? Note that I'm not referring to [highlight #F8F8FF]=Globals!ReportName[/highlight] as that value will change if an instance of the report...

Is there any way to return from a modal form without using Me.Hide? I would like to show a modal form and wait for input. Afterwards, I extract values from the form via user-defined properties (one of which tells me whether the OK or Cancel button was clicked). I then use these properties as...

When I add a reference to COM component Microsoft Excel 11.0 Object Library, the reference added is Copy Local=True to Interop.Excel.dll (Version 1.5.0.0) in my Release folder. Does anybody know how to get it to reference the copy in the Global Assembly Cache? I can change the Copy Local...

I have a global parm (DivisionId) that I would like to set in the OnRead() method of a data row. The problem is the data row also contains a column/variable named DivisionId. What syntax can I use to distinguish my global DivisionId from the data row instance's DivisionId? Sub OnRead( )...

Bring up the Project Browser (View -> Project Browser) Filter the contents by clicking on the Filter icon. This will bring up the Browser Options window. Make sure the Members filter:Variables box is checked. Click OK. When you return to the Project Browser, expand the Symbols folder and you...

Does anyone have a Globals Browser option in their View menu? On page 93 of the Actuate Foundation Class Reference (Volume I) it mentions this option but I don't see it. I am using e.Report Designer Professional.

Is there any way to reference a field value in the Detail_Format subroutine as shown below? I know I can set the ControlSource property of controls on the report and access the values this way but I'd like to avoid this "blackbox" movement of data and get some better control of processing the...

Is there any way to check to see if a modifier key (Alt, Ctrl or Shift) is being pressed from a VBScript program? When I execute a script, I'd like to know if any of these keys are down when the program is initiated. If so, I'll force a prompt window, otherwise it will retrieve it's input from...

Is there any way to create a style that won't change the Bold/Regular font attributes in a paragraph? I'm working with a document that has lines similar to: Field Desc: Field Value where I would like to apply paragraph formatting but don't want to affect the Bold/Regular font styles that...

Is there a more straightforward method than the code I have listed below to create a new worksheet from an existing template worksheet and then assign the new worksheet to a variable? Public Sub CopyWorksheetFromTemplate() Dim NewWorksheet As Worksheet Dim Template As Worksheet...

Is there any way to specify a field's Lookup:Row Source that references a previously set field in the same row? As an example I've tried setting Row Source to: SELECT TeeId, Name FROM Tees WHERE (CourseId=[DefaultCourseId]); I would like the [DefaultCourseId] value to be substituted with the...

When creating a new chart series, I am taking a text value from the spreadsheet which I have formatted as I would like it to appear in the chart's legend. It is a "date" of the form Aug 05. Whenever I assign this value to the Name property, it keeps getting reformatted as 5-Aug. To get around...

Is there any way to get a count of the number of subheaders and place this count in it's associated parent header section? If I use COUNT(*), I get a count of the detail lines. I've also tried creating a dummy txtOne field in the subheader (with Control Source =1) and attempting to display the...