Answer Questions

• Michael_317 Post-Empower ISV Options

  Hi all, The company I work for has been in the Empower ISV program for almost two years. During that time, we have completed version 1.0 of a very large (about 800,000 LOC) enterprise application. We have made a few sales, but we're not rolling in the cash yet (hopefully that will change soon). We are still adding new features to our product, fixing bugs, etc, and as such we still need development tools. Since all of our tools are covered under the Empower ISV program, we'll have to switch to something else once our subscription expires. What exactly are our options Is there anything that isn't going to cost us an arm and a leg I doubt there's anything that's as cost effective as the $375/year we've been paying for Empower ISV, but is th ...Show All

• George3 access populate combo box help needed

  hi there, i am trying to get the following to occur: user types in search string hits search button in a form, if there are any records that match the search string a list/combo (which one should i use by the way ) box is displayed and populated with all the matching records. the user then selects which of the records to display using the now visible list/combo box i need to be able to access partial match records ie: search string = mi returns: michael mike amie etc the code i have so far makes the text box visible (i'm using a text box because i don't know how to populate a list/combo box) and populates the new box with whatever the user types in the search box . it's the select statement and p ...Show All

• Gidon Sela Hide/unhide

  I have a button that when the user presses the button the program will search an ordered column for values equal to 0 and hide the rows that has values equal to zero. If the rows already are hidden then they shall be revealed by pressing the button. My code is: Sub showHideButton_Klicka() Dim relativCell As Range Dim i As Integer, j As Integer, k As Integer Dim blnFirstFound As Boolean, blnLastFound As Boolean, blnIsHidden As Boolean Set relativCell = Worksheets("Berakning").Cells.Find("Rel.", LookIn:=xlValues) 'hittar forsta och sista cell med varde 0 Do Until IsEmpty(relativCell.Offset(i, 0)) = True Or blnLastFound = True If blnFirstFound = False Then If relativCell.Offset(i, 0) = 0 Then blnFirstFound = True k = i ...Show All

• nigliazzo Word Automation Issue

  Hi, I'm investigating an issue in a legacy vb6 application our company maintains, the application supports word automation so that users can generate letters for their business. I've come across an issue where a user attempts to open a word document from the vb6 application that has been generated and saved with Email headers visible, Word crashes when the application attempts to open the document using automation ("Error in Winword.exe" in Office XP, "Word has encountered a problem and needs to close" etc. in Word 2003). The vb code to open the document is roughly: Set app = New Word.Application app.Documents.Open "X:\documents\docwithemailheadersvisible.doc" app.Visible = True The Crash occurs when ...Show All

• enric vives Writing result in Excel

  Hello, I have the folowing code:   Public Function DgrMinSec2DecDgr(Angle As Double) As Double ' * -------------------------------------------------------- ' * Program not yet working ' * -------------------------------------------------------- ' * Variables Dim grd As Integer Dim min As Integer Dim sec As Integer Dim calc As Double ' * Values grd = Angle \ 1 calc = (Angle - grd) * 100 min = calc \ 1 calc = (calc - min) * 100 sec = calc \ 1 DgrMinSec2DecDgr = grd + (min / 60) + (sec / 3600) DgrMinSec2DecDgr = Round(DgrMinSec2DecDgr, 4) ' should I round this result ' * Write - problem in writing in cell 'Debug.Print Round(DgrMinSec2DecDgr, 4) 'ActiveCell.Formula = "Write" & DgrMinSec2DecDgr ActiveCell.Sel ...Show All

• gokce Excel Pivot Tables - Dynamically Changing Pivot Table Structure

  I have one pivot table which is associated to a Excel Range. I dynamically change the structure of the pivot table (eg Columns, Row, Data) to create different outputs. I used the following code to "empty" out the Pivot Table structure     With Sheets("Pivot").PivotTables("PivotTable1")         For intLoop = 1 To .PivotFields.Count             .PivotFields(intLoop).Orientation = xlHidden         Next     End With But in some cases, the Data field was not being cleared at all. When "empty" out the structure and build a new pivot table structure, it holds on to the Data ...Show All

• NelG1 Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance Hi The below example uses a recordset to scroll through the records and add the entries into one string. Hope this helps Public Sub test() Dim rs As Recordset Dim MyStr As String Dim FirstRec As Boolean Dim Responce S ...Show All

• WinFormsUser13232 Service won't use default printer

  I am developing a program that is intended to run as a service on an XP Pro machine. It processes files and prints them to a printer automatically in the background without any user interaction. The printer that I use is configured to be the system's default printer. When the program runs it works fine when it is not running as a service. However, when it is running as a service, instead of printing to the default printer, it tries to print to the Microsoft Office Document Image Writer. I have not been able to find any information on configuring the system so that I can get my service to use the designated default printer. Any ideas would be appreciated. Thanks in advance. We made some progress on this i ...Show All

• Nitesh Ambastha Help Building a Custom Annotation Report View for BSM

  Hi, I am trying to make a custom report for MS Business Scorecard server. I have implemented the sample report from the white paper on building custom report. When I alter that code to output annotations it crashes the report or portal its self. The code is the same except I added the GetTheAnnotations()function and created a new PMServer() which is part of the Server class. Please suggest how to access the annotation with the scorecard API. This is the code used: using Microsoft.PerformanceManagement .Scorecards.Extensions; using Microsoft.PerformanceManagement .Scorecards.Client; using Microsoft.PerformanceManagement .Scorecards.Server; output.Write(HttpUtility.HtmlEncode(GetTheAnnotations())); ...Show All

• irvendeep Problem passing a range as argument

  Hello there, I'm developing a macro do do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. My code is simple, and here it is: Sub Main()     Dim Range_do_Comeco As Range     Set Range_do_Comeco = Worksheets("Plan1").Range("AD2")     MyFunc(Range_do_Comeco ) End Sub Sub MyFunc(ByRef Valor_do_Range As Range) 'etc etc End Sub I need to pass the range as argument, because I change the values around the "area" of the range, and it keeps going throught the Plan. The compiler keeps saying, when I call MyFunc that "The object is necessary". Dunno what's wrong with the code =/ Thanks in advance if someone can help me = ...Show All

• Claudio V. An issue with Outlook Express 6 attachments

  When a client of mine tries to add an attachment to an e-mail, the file (when shown in the attachment address bar) comes up as a .lnk file. This is strange because it happens with every type of file she tries to input. We, so far, have tried a Word document, Excel spreadsheet as well as many other file types. In the folders, they are viewed with their regular file extension, however, as soon as they are attached to the e-mail, the extension changes to .lnk every time. This causes a problem because of the security settings Outlook automatically creates which blocks all executable files, including .lnk. I know there is third party software and regedit that could allow us to open these types of files, but its not worth it to do so on every co ...Show All

• aahkam ISV Royalty Program - OA2007

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end customers   6) If I was to have a techincal problem with a soultion and I can not get in touch with the ISV that sold me the soultion will Microsoft be able to help me       7) What are the benefits from buying solutions from an ISV to an end user ...Show All

• VSFW3 Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi, After a bit of searching I found this code that demonstrates drag and drop between two list boxes on a user form. You saw your new so I'm give a brief overview of whats going on here. ListBox1 is populated with some values when it initialises. When the user click ListBox1 (the source) and moves the mou ...Show All

• calmal20 Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks I have exactly the same problem, do not know when it started. The information is not helpful. details: XP prof, version 2002, SP2. I can open the registry with an external tool: TuneUp Utilities. Help would be appreciated. XP Profesional (5.1, Build 2600) The dutch version would be the same globally. I am wondering if you click start- then run- then type in regedit if you are using capital letters inst ...Show All

• Rajesh.Y microsoft need to work on explorer 7

  locks up with errors when closing tabs, need to load web pages alot faster, locks up when downloading gif, and any java apps. at start up in explorer 7 always looking for proxy or connection the gui interface needs to expand with more tools in browser. microsoft is creating another window me editions o/s to fast for the future guys i think you should rethink specs and requirements actually its in RC1 now and this is the wrong place to post :-) best place: www.microsoft.com/communities in the IE newsgroup I've personally never had problems like most people, perhaps you are using some toolbars or 3rd party plugin's causing the problem, otherwise we wouldnt have a delay in its release ;-) No doubt feedback is ...Show All