Answer Questions

• Glider Problem With Code That Writes a Change To Itself

  I have written a sub that modifies the code in the if statement of a functon in a different module. Trouble is that during runtime, I haven't found a way to get the equivalent of a Compile VBAProject to occur so that the behavior of the function actually changes on the fly. Even though the code is changed by the technique, the behavior when called always stays v1 > v2. Isn't there a way via the VBIDE classes or something to get the recompile ...Show All

• Joe Janson Microsoft Platform Test for ISV Solutions & FxCop

  Hi, the Microsoft Platform Test for ISV Solutions site ( https://partner.microsoft.com/global/40010438 ) states that to pass the managed code component "All Application Assemblies pass analysis by FxCop without errors or warnings" does this mean: 1) all assemblies must pass with the default FxCop rules (not even microsoft application blocks manage this) 2) the FxCop rules file used for the test must be supplied so any customisations can be seen ...Show All

• Victor Havin BSM Scorecard Report Views

  Hi All, I have created a scorecard,and added 2 reportviews(Type:Pivot chart) in the report view Tab, both of which belong to the same group i.e 1. I have added this scorecard on my sharepoint site along with Report view Web part and defined the relationship between them,by connecting them using "Webpart connections" . I have also selected the "Report view groups" thats needs to be displayed in the "Reportview w ...Show All

• danclarke_2000 Empower program support for ISVs

  Is there any real support provided for ISV's in the Empower program Visual Studio 2005 introduced breaking changes in our application (integrated in Visual Studio) and we have not been able to get anyone to investigate thoroughly. We cannot even determine which developer group is responsible for the breaking changes. For one problem, we were asked to submit the problem to the support team for Windows Forms. Is there any support for Empower pr ...Show All

• MARK E6581 BeforeUpdate Event Problems

  I have a text box that the user enters a number in.  It pulls the price from another table and updates the variable "charge" and shows the updated price in a textbox on the form. problem is when the user creates a new record and puts a number in the textbox, it erases the charge from the textbox that displays the updated charge. here is the code Private Sub numEdu_BeforeUpdate(Cancel As Integer)      intSubscript ...Show All

• JerryShea How to get ASCII code of the character? Weird Eh>

  Hi! How to get ASCII code of the character Say: strA = chr(87) 'returns "W" Is there any function that would get 'strA" and return its ASCII I thing you are looking for Asc() MyNumber = Asc("A") ' Returns 65. Thank you Dr Genius! Val ...Show All

• Tara Questions about using Windows Workflow Engine in ISV app.

  Hi, We are a registered partner getting ready to launch our first application in August, 2006. We are looking at using WWF in the application. I see we can likely get GoLive licenses for the application for that time frame. I am wondering is there a limit to the number of installations we can distribute on the GoLive licenses Will there be a general release date prior to Vista launch or will it be rolled in to Vista Any other risk areas, ...Show All

• Jay Legue Odd or even and converting Decimal to binary, octal, or hexadecimal and back.

  how do I make an algorithm that asks the user to enter an integer number, then determine whether the number is odd or even.  How would you write that in Visual Basic code Secondly I need to figure out how to convert a decimal number into binary, octal, or hexidecimal.  It needs to ask the user to enter a decimal number and then ask if it needs to be converted to binary, octal, or hexidecimal.  The Algorithm should ask until the o ...Show All

• Hoodwinked Optimise VBA for Multi-Processors

  How do I tell my VBA it is allowed to do several things at once I am moving my project to the server, which has 4 CPUs. I know that sections of my code have no interaction with each other, and do not work with the same cell ranges. Imagine my code is as such: Main Routine Call Task 1 Call Task 2 Call Task 3 End This is programmed in linear code, so I know that it won't start Task 2 until it has finished Task 1. I need some way of te ...Show All

• dave george Vba commands used to connect to sql

  Thnx Derek... I tried the commands but an error message appear "ActiveX component can't create object" and i don't know how to solve this problem. Thats a bit odd... try the Open statement instead. Here's an example: Dim I, FileName For I = 1 To 3 ' Loop 3 times. FileName = "TEST" & I ' Create file name. Open FileName For Output As #I ' Open file. Print #I, "This is a test." ' Write string to f ...Show All

• Anthony Giambalvo VBA Information.

  Is it possible to write code so that when I click on a Excel Workbook Icon, it will load up other workbooks as well. I have several Workbooks I access on a daily basis for work and I want to just open one documnet up rather than 6. I have already created the Buttons for the other Workbooks but can not get the coding right so that it opens the workbook up when the button is pressed. I hope that makes sense. If not, reply and I shall try and word ...Show All

• macv3x What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• AustinH100 MS Word Option Button Collection

  Hi, I am trying to use option buttons from the control toolbox in a word document. I have set the groupname and they work fine but.... I then need to loop through the option button values in the group and I can not work out how to create the array or collection - I have tried the shapes property and the inlineshapes property of the active document but they have not worked. I need code a bit alike below: dim optBtn as msforms.optionbutton for ea ...Show All

• Data-V Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• BEACHDBA Excel Macro - saveas command with current date?

  I'm new to VB and am trying to code up a macro for excel. What I am hoping to do is to save a file in two locations. The getting them to save isn't a problem. However, what I would like to do is have one of the saves to have the current date at the end... ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\ca5ms\Desktop\BAS05980.P.EFT.EOIIN.UNUMLIF.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassw ...Show All