Microsoft ISV

Page 168




  • Topics
    Replies
    Last post
  • CRM 3.0 SDK Contact Merge
    by MattMasotti
    4 Replies
    Last post by MattMasotti
      • I'm using the following code, which is pretty much right out of the sdk documentation example: Dim target As New TargetMergeContact Dim mergeReq As New MergeRequest target.EntityId = contactCRM(Pri).contactid.Value mergeReq.SubordinateId = contactCRM(Sec).contactid.Value mergeReq.Target = target Dim merged As MergeResponse = CType (crm.Execute(mergeReq), MergeR
  • Why my AddIns runs only once!?
    by Awsok
    3 Replies
    Last post by bi-lya
      • Hi All, I made 6 VBA Excel macro using Visual Basic Editor from within Excel, but after deploying the AddIns, my AddIns run only once and stop!! Here are the details: I made 6 macros and wanted to share them with my colleagues at work, in what I call it Add In library. I assigned shortcuts to the 6 Macros as follows Lnk2DB() (" Ctrl+Shift+a ") CHS
  • users appear to be offiline in LCS 2005 enterprise edition .
    by senjoy
    2 Replies
    Last post by MS ISV Buddy Team
      • Dear Friends , i have installed SQl 2000 with its service pack on Win 2003 Enterprise edition server .which is acting as a member server along with LCS 2005 enterprise edition With Sp1 . now the issue over is most of the users are able to login to Office communicator 2005 with the User id & password provided but they cannot send message to other users logged in to the same domain ..
  • Excel CheckBox - Enabled "False" but I don't want it grayed out
    by suznal
    6 Replies
    Last post by Andy Pope
      • Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality. I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • Converting access to VB.NET or C#
    by fweeee
    4 Replies
    Last post by fweeee
      • Hello, A friend and I are currently in the process of converting an access database to something a little more powerful. At the moment, we are converting the backend to MSSQL (using a tool we bought from somewhere on the internet - the upsizing tool was only working for 20% or so of it). After this is complete, we will then need to get the frontend into something a little more appropriate - either
  • Bucket ID 8, event type
    by Claus Brod
    14 Replies
    Last post by DHON
      • Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
  • Add a customized Tab in Communicator 2005
    by Gabriel Méndez
    7 Replies
    Last post by Ken Kosmowski
      • Hi, i'm trying to add a new customized tab in Communicator 2005 to show an html page, i have a document titled "Planning and Deployment" which somehow explains how to do this... I tried to add a new entry on the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Communicator called "TabURL" and also under HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator wi
  • use inputbox to choose cells for plots in excel
    by Jonas.S
    12 Replies
    Last post by Jon Peltier
      • Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) C
  • VBA for saving pdf file
    by LilyChan
    2 Replies
    Last post by Cringing Dragon
      • Hi, I have a problem to define the default file name when converting an excel file to pdf file in VBA. I set PDF converter as default printer. May I know the VBA code to change the defailt file name by adobe acrobat program in excel Thanks a lot!!!
  • Changing back color of a field based upon another field
    by Ely Spiegel
    2 Replies
    Last post by Ely Spiegel
      • I am interested in changing the back color of a field based upon a second field's value. This field is contained within a continuous form. All that seems to happen currently is every occurance of that field changes its color. Each field has a different value, can this be accessed for the formating as well
  • Excel autofilter selection criteria referencing the contnet of a cell on another worksheet
    by rabbitoh
    2 Replies
    Last post by MikeCaveSA
      • I need to have the autofilter in Excel reference the content of a cell on a different worksheet (but in same workbook) and use that content as the filtering criteria for the column being filtered. Example: Column 1 in the Table worksheet contains the word "Nelson" Instead of just filtering the word "Nelson" as per normal, I need the code to direct the filter to g
  • Rostering
    by Starfish
    1 Replies
    Last post by Cringing Dragon
      • Would it be possible to use excel formula to create a roster I am rostering the office staff to do reception duties during lunch. I want the sequence of rostering to be one staff from each department until the last person has been scheduled. Can this be done
  • How to access to the sipaccount of Office Communicator 2005
    by mrsamii
    0 Replies
    Last post by mrsamii
      • Hi all, Sorry about posting the problem again. But I thought that if I explain a little bit more clear, it would help to find out a solution. I am working on a client side web application of Live Communications Server using ASP .NET 2.0 with C#. In office communicator 2005, I added a button which links to aspx web page of the application. In this aspx page I need to get the identity (or sipaccount
  • Strange behavior when setting controlsource property in report
    by JLS123
    1 Replies
    Last post by JLS123
      • I'm using Access 2007 and in Report_Open I am trying to set the controlsource property of various fields. Example: Private Sub Report_Open(Cancel As Integer) Me!F01.ControlSource = "Quantity" Me!F02.ControlSource = "Total" Me!Major1.ControlSource = "=Sum([Quantity])" Me!Major2.ControlSource = "=Sum([Total])" End Sub where F01
  • Populate a Cell in Excel with a range ending position
    by Bill Irwin
    4 Replies
    Last post by ADG
      • I'm creating different charts with various ranges and I need to script VB or use an excel formula to populate a particular cell with the end point of the varying ranges.
  • VBA with SQL Server
    by Mrs Shivani
    0 Replies
    Last post by Mrs Shivani
      • I have one application that is using VBA and MS Access. Now I plan to migrate MS Access to SQL Server as now huge number of users from offices in different countries want to use this application. So I plan to keep VBA application & SQL server in a common location (LAN) from where all users will be able to access the application. Now I also want to migrate VBA code to VB.Net bu
  • Can anyone tell what is wrong with this? Excel is saying there is "run time error '1004' Autofill Range Class of Method Failed"
    by Visual Basic Beginner123456
    4 Replies
    Last post by Martin Xie - MSFT
      • Sub Test() ' ' Test Macro ' ' Keyboard Shortcut: Ctrl+t ' Selection.AutoFill Destination:=Range("C4:T4"), Type:=xlFillDefault Range("C4:T4").Select ActiveWindow.ScrollColumn = 13 ActiveWindow.ScrollColumn = 12 ActiveWindow.ScrollColumn = 11 ActiveWindow.ScrollColumn = 10 ActiveWindow.ScrollColumn = 9 ActiveWindow.ScrollColumn = 8 ActiveWindow.ScrollColumn = 7
  • Confidence Limits for the Mean
    by UniRyan
    1 Replies
    Last post by Shlizar Axis
      • Hi; I need some code that will let me work out the upper and lower confidence limits for the mean without using the excel confidence function
  • Need date in Excel header to advance 1 day for each page
    by Xymorg
    1 Replies
    Last post by Peter Mo.
      • I have a sleeping disorder and a doctor at the VA wants me to keep a daily log of all my activities. I have an Excel file for each day with the date in the header. However, instead of multiple files, I would like to have them in one file with the date in the header and have the day increase for each page. Each page would be the next day. I have the following code to add the date to the head
  • Find and rename specific Excel files
    by simonkrug
    1 Replies
    Last post by Shasur
      • Hi all I¡¯m a rookie in VBA-programming, and I¡¯ve been trying to write a code to organize and rename Excel files that I receive every day in a folder called ¡°daily prices¡± on my ¡°C¡± drive. I¡¯ve got a simple code to rename my excel files and adding today¡¯s date and save them in the folder ¡°daily prices¡±. Code: Sub name() Name "c:\daily prices\book.xls" As "c:\
  • Change a formula in vba code, How do you
    by chrstdvd
    1 Replies
    Last post by Andy Pope
      • Hi, I have a spreadsheet that adds each days purchases and each days sales et sums them, until the inventory is posted. The formula in each cell going down the sheet is like:=bi9+bf10, with bi9 having the current sum and bf10 having the current days sales or purchases. Lets say the next days formula is in cell bf11. I need to change the formula in bf11 to =bi11. Note: the store can post
  • About iexplorer 7 error.
    by Gilga.
    2 Replies
    Last post by MS ISV Buddy Team
      • "The instruction at 0x66869bc7 referenced memory at 0x00000050 . The memory could not be read." I keep getting this message whenever I close the internet explorer 7. Can anyone help me out on this matter
  • How to allow cookies for Windows Live ID
    by Ralph Burns
    6 Replies
    Last post by Coqui88
      • Help me!
  • Connect to sql data base
    by mjven
    1 Replies
    Last post by MS ISV Buddy Team
      • I would like to be able to have a web page on my share point 2007 site that allows me to query information out of an sql database. How do I do this