Microsoft ISV

Page 32




  • Topics
    Replies
    Last post
  • Bucket ID 8
    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
  • Using VBA macro to locate next free column on worksheet
    by rabbitoh
    14 Replies
    Last post by magicalclick
      • I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.
  • CRM 3.0 Error: Subreport could not be shown
    by RSorenson
    2 Replies
    Last post by AnonAG
      • I have a user that is getting the error "Error: Subreport could not be shown" when doing a report for a quote. She can do a report for an order but just not for the quote. I tried logging her in with different computer and get the same result so I think it is at the server level. Please give me some direction on what to do next. Thanks
  • Importing multiple textfiles into Access
    by DJRave
    4 Replies
    Last post by DJRave
      • Hi, For a project I need to import multiple textfiles into Access. Between 40 and 50 files everytime. Using the wizard wouldn't be a great sollution in this case. I've tried to use the transfertextmethod but the only problem is that I need to specify the exact location of all files in VBA but since the number of files varies every month this creates an error when a file isn't present that m
  • how to control equations in MS Word
    by ninjaneer
    2 Replies
    Last post by LeVraiNinjaneer
      • Hi! I need te create a table that calculates values for forks, knives and plates from one variable pax(number of people). This table has to be in MS Word. How can I setup a table that multilplies given constants by pax I need to be able to format the colours etc of the table to make it look attractive. Thanks a lot in advance for any help, I really need it Pieka
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • app verifier error log - Exception record. Use .exr to display it
    by valent&amp;#124;n0
    2 Replies
    Last post by MS ISV Buddy Team
      • Would this be the right forum to ask what is the message means - < avrf:logEntry Time =" 2007-06-13 : 08:59:38 " LayerName =" Handles " StopCode =" 0x300 " Severity =" Error " > < avrf:message > Invalid handle exception for current stack trace. </ avrf:message > < avrf arameter1 > c0000008 - Exception code
  • Local Folders - Inbox
    by DivaMaggie
    1 Replies
    Last post by DivaMaggie
      • In Outlook Express 6, under Local Folders - Inbox, I have a (1) and there is no actual mail. In other words if beside Inbox it says (5), there really are only four emails and the (1) always stays beside inbox. Was hoping maybe someone could help.
  • Change Input Focus: bring Form to front:Stop Excel from flashing: HELP!
    by J678
    2 Replies
    Last post by jameswmc
      • My Macro doesn't bring my userform to the front because it has just transfered focus to Internet Explorer. Instead the Taskbar flashes repeatedly. the code is simple: Set MyObject = CreateObject("internetexplorer.application") With MyObject .Visible = False .Navigate MyLocation Do While .ReadyState <> 4: Loop End With Load UserForm1 UserForm1.Show
  • opc
    by ksona
    14 Replies
    Last post by MartinBrasil
      • I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • Access Forms
    by PC Geek
    4 Replies
    Last post by stlarmon
      • hi, Ive got a form, in MS Access and its a group control, which means it can only output integers. I need a little code to attach to the form, so that the text field which its bound to, actually gets the text. eg, if i select "before 2000" on the field, then the database would get "before 200" instead of somethign like 6 etc. i hope im explaining this clearly. Im wondering if s
  • DoCmd.OpenReport passinh param to underlying query in MSAccess
    by acki4711
    3 Replies
    Last post by Bazz07
      • Hi all, - I have in Access (2003) a report who's datasource is a saved query. - This query needs a param How can pass the param to the query using the DoCmd.OpenReport method Any help is highly appreciated. TIA Dan
  • HOW CAN VBA CALL ON EXTERNAL DATA SOURCES (I.E. A GREATPLAINS TABLE) FOR INTEGRATED CALCULATIONS?
    by DFANT
    1 Replies
    Last post by Bruno Yu - MSFT
      • I'm wondering if anyone familar with Micrsoft GreatPlains (v9.0) develpment can assist me with this issue: --One of our clients has a customized dataform they use for user entry for Sales Order Processing --They have a validation on a specific filed which performs a calculation on a value source from their sales items table. --Sales staff entering a sell price are
  • Syncronising two Form drop down lists and display contents in a corresponding textbox
    by rabbitoh
    2 Replies
    Last post by rabbitoh
      • Scenario: I have two columns on a worksheet, the contents of which relate to each other e.g. 01 Name1 ....etc. 02 Name2 ....etc 03 Name3 ....etc I have a Form with two drop down lists and one text box. The drop downs relate to the entries in the two columns respectively. The text box relates to the contents of only the second column. Objective: I want to select an entry from either drop down list
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • Creating and filling in an array
    by scireja
    0 Replies
    Last post by scireja
      • I'm trying to make a ranking function that isn't as stupid as excel's built-in version. I want to input the contents of one cell (a number) and the contents of a range of cells (numbers, including the one cell), and to make a ranked list of these numbers, going from largest number to the smallest. I've written up some code in VBA (since I haven't been able to find a built-in function that does thi
  • Update an MS Access Table Field using VBA
    by Mike S. Avelar
    1 Replies
    Last post by Luiz Claudio - MVP
      • Hi everyone! So, I have this tool I created for my team at work. I need to be able to update a numeric field in a table I have when the VBA code is excuted. I tried searching through the online help and a few forums, but I'm not exactly what I'm looking for so it may take me more time than just asking. So, the function that I want to create is to check and see if an action has happen
  • Errors migrating macros from Office XP to Office 2007, implicit variable definition
    by Matt-san
    0 Replies
    Last post by Matt-san
      • I have a set of macros written for Excel 2002 that are having intermittent errors when trying to run them from Excel 2007. The file has been saved as *.xlsm, which is the current version for Office 2007. The file ran correctly the first several times it was tried. It then stopped working correctly for no apparent reason. Same input conditions, same computer, same file. The original file was
  • Opening an access database to memory
    by Kevin Porter
    2 Replies
    Last post by Kevin Porter
      • I am trying to open an access database to memory, then test somedata in Excel against, then send that data to individual worksheets. The bigggest problem I am having is actually connecting to the database. The only way i can get it to work is if I open the database into a worksheet, which I do not want. I want to simply connect to it. It says I am using Microsoft Visual Basic 6.3, I sta
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • Driver disappeared!
    by Hot4Candles
    0 Replies
    Last post by Hot4Candles
      • I was using the Microsoft Document Image Driver to convert .doc to .tiff but then the next time I went to use it it was gone. I tried all the suggestions in the previous posts and got as far as #7. My advanced tab did not have the Microsoft Image driver in the drop down, it still only shows generic/text only. What can I do to get this driver back and installed so I can convert my files
  • Learning VBA.... where to begin??
    by gregw74
    4 Replies
    Last post by NWAprog
      • I have some very limited knowledge of VB, but I would like to learn VBA from the ground up, specifically with FrontPage. I just don't know where a good starting point is Do I learn VB and then build upon that by learning VBA, or dig right into VBA Do I learn VB.NET or VB in it's previous form Is VBA much different in Office 2007 than previously Any feedback would be greatly appreciated. Thank yo
  • macro for automatically creating data labels in excel chart
    by Erik Houtriet
    8 Replies
    Last post by hysenlici
      • Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C
  • Excel Checkbox - Multiple controls-only one may have value of true
    by suznal
    10 Replies
    Last post by suznal
      • I have checkboxes on a sheet of which, the value of only one may be true at a time. (By the way, I am not allowed to use option buttons on this workbook). I have figured out the basic code to use if there are only two checkboxes involved, but each instance I have involves a minimum of three and sometimes five checkboxes. The code I have works well (for a pair of checkboxes) provided I supply it