Search results for query: *

Excel, you're killing me! I originally posted thread 707-1651774 about a year and a half ago and I still get bitten by VBA. So I have 2 pairs of combo boxes: SI & Step and Proj & Task I populate comboSI. The user selects an item. In the AfterUpdate event I populate ComboStep. What goes into...

I've got a bunch (100 or so) DLL files. I would like to create an Excel sheet that shows: Assembly Path & DLL name Namespace Class Name I can use VS2010 to get this information or ILDASM but in each case the information is not readily convertable to my 3 column Excel sheet. The best I seem...

Working with Pivot tables today. The data is simple: Category Hours So we might have: Category Hrs Work 8 Work 8 Vacation 8 We want a pivot table with rows being the Category and two columns Hrs and % of total Hrs. We get Category Sum Hrs % Work...

So I've got this little VBScript that tries to shutdown a COM package. 100% of the time it does that. About 50% of the time it also throws up an error: "An unhandled win32 exception occurred in dllhost.exe [8616]." Then it wants me to go into the Visual Studio Just-In-Time Debugger. I...

Imagine a userform with 3 text controls. We are in text field 1. We type something or we don't. Hit tab and we move to text field 2. In text field 2 I want to do some work but I don't want to be left there. When I finish working I want to move on to text field 3 without the user having to...

This is kinda weird. I have a userform with a couple dozen controls - a number of them comboboxes. The user enters a value in text field 1. The logic in the AfterUpdate event sets up the combo boxes with values and sets a starting value. There are about 5 combo fields it does this with...

The simple idea of moving from control to control is driving me nuts. I have 3 fields: Start Time Stop Time Duration Here are the rules. We come to the start time field: 1. When we leave if the field is blank then skip Stop and prompt for duration. 2. When we leave if the field is not...

So the KPI has a value and a goal field. Let's say the value is sales growth and the goal would be looking at things like: if we reached a sales growth of 20% then that is good, 10% is fair, negative is bad. No problems. Now my issue is that I will create this cube but I will install it on a...

I'm using VS2008 and starting a new project. It is a Viscual c# Office 2007 Excel 2007 Workbook project. I click on Project Types in the New Project dialog box. I select Excel 2007 Workbook. I use the defaults values for name, location, solution name. Click OK I get the pop-up Visual...

I'm being asked about doing the following: I have an Excel Workbook and a worksheet with normal Excel stuff. The user will print the worksheet. Management would like me to include logic so that when the print of the worksheet happens other documents print as well (automatically). These other...

I'm in VS 2008 VB.NET I have a form with the RDP control on the form. In the Form1_Load event I set the parameters to connect: rdp6.Server = "10.1.1.1" rdp6.UserName = "abc" rdp6.AdvancedSettings2.ClearTextPassword = "def" rdp6.Connect() It connects and I see...

I need to develop a custom wrapper around the RDP functionalilty. There is a DLL called MSTSCAX.DLL that I believes provides the functionality. I want to call this from within a VB.NET executible and I confess I have little or no knowledge of how to get this off the ground. Anyone know of...

My problem is that I have an Excel Workbook (XLS) with a number of commandbuttons on various forms. Most of the commandbuttons have the picture property set with some type of image. I used to have a directory where I kept all of the images I had placed on the various worksheets but...

I've got a module with two procedures. Procedure 1 calls procedure 2 and passes a worksheet reference. Procedure 2 does some work and then wants to call a procedure which is stored as code on the worksheet. Specifically sheetA has a routine called Format and sheetB has the same thing. The...

I've got a mental block on this one - maybe you can help. I need to populate Table ABC from Table DEF. There are multiple columns but I need to ensure that I don't get duplicates based on a smaller group of those columns. Assume both tables have columns A, B, C, D, E, F and both tables are...

Sorry if this is a duplicate, I can't seem to search on the tek-tips site any more. For three days now I've been screwing around trying to figure out why the aggregation design wizard refuses to create any aggregations. Every time I run it it says 0 aggregations designed. The optimization...

I'm migrating a cube from SQL 2000 to 2005. I find that certain dimensions don't behave as I would expect - specifically elements of the dimension appear in the wrong places. I think this may be due to dimension settings before the migration. So I'd like to go back to basics and make sure I...

I'm running SQL2000 on a Win Server 2003 box. Full-text search was implemented about two years ago but now appears that the catalog populate has not been successful since 12/2006. When I try to take a look at the catalog, Enterprise Manager and/or Query hangs. I believe the catalog is...

Anyone using this crazy thing. I've been fighting it for 3 days now and have a little problem I can't get rid of. I can connect. I've tried VB6, VS2005, and the TSWEB based version. When I go into full screen mode, everything is great. If I click on the connection bar to come out of full...

So I have this dimension in my cube that is a date type dimension. Its hierarchy is: Year Quarter Month Date I had Year as the key column for the Year level and Quarter as the key column for the Quarter level. Problem was that when looking at things at the quarter level, quarters for...