Cannot read Office 2007 DVD

Partnering with Microsoft

Index ‹ Microsoft ISV

- Previous
  - 1
    - Sort rows within a range Hi My problem is the following. I have a (100rows x 10columns) range to which some numerical output is written. I need to access each row in this range and sort it descending. Any suggestions Any help is much appreciated. Thanks. Thomas Tag: Cannot read Office 2007 DVD
  - 2
    - Automate the Excel Camera Tool I'm dashboarding with Excel and have everything finished except for programmatic placement of camera objects. Here's the gist: My dashboard selects an image to copy with the camera tool based on the results of various lookup and choose functions applied to data pulled from an ODBC query embedded in a worksheet. The Camera object is placed on a display worksheet so that the dashboard is nothing more than a worksheet with a collection of camera objects referencing various data and images from other hidden worksheets. My question is: how do I automagically determine the display position of the camera object based on data in another worksheet For instance, if Sheet3!A1 equals C14, then I want a particular camera image to show up at Sheet1!C14. The idea is kind of like an autogenerated map - if the data says a "red truck" is in "texas", then I want a camera object pointing at "red truck" to pop up in the location "texas". I have everything working except that the resultant image has to be manually placed - how do I do this programmatically Please note that everything I know about programming came from the back of a Wheaties box. Thanks. Tag: Cannot read Office 2007 DVD
  - 3
    - Licensing the NTFS sepcifcation Hi, We're writing an embedded application that reads and writes data to removable media via USB. I have successfully implemented a FAT driver for our arhcitecture and now we would like to support NTFS. We understand that the specification for NTFS is privatly held within MS. So I'm wondering how to start the process of licensing the specification. Where do we start Who is the best person to contact initially Thanks, Ben Tag: Cannot read Office 2007 DVD
  - 4
    - SpeedUp a Macro in Excel - Disable Functions Hi all, In my macro I used this sentences to speed it up: Application.ScreenUpdating = False Application.EnableEvents = False But I've also created some functions and they are beeing recalculated every time my macro do a change in a worksheet. Is there any way to disable the calculation of functions Thanks and really sorry for my English. Tag: Cannot read Office 2007 DVD
  - 5
    - Ex 2002 VBA, Activate First Available Cell in "A" I need to please know how to call the first unused cell in Column A, activate it and put it at the top of my view area. If I have 7,369 rows of data populated, tomorrow it will be even more, each day I would like to do some work in VBA, which I know how to do, without referencing specific cells. Once complete I need to put my cursor (highlight) in the next unused "A" cell and put it in the left upper corner of my visible sheet. No cell numbers required, maybe the cell past lastused Thanks in advance for any help. Tag: Cannot read Office 2007 DVD
  - 6
    - Using VB in MS Access Ok, I have no knowledge of VB. I am attempting to co-opt a bit of someone elses database. I am using 2 combo boxs in a form header to search for a specific record using 2 different fields. If the record exists than the fields in the detail section of the form are filled in. If it isn't located then nothing happens. One of the two fields is a key field with a numberic autonumber. This search works just fine. The second field is not a key field, it is a name. This one gives me: Run-time Error "3079" The specified field "Name" could refer to more than one table listed in the FROM clause of your SQL statement. I only have 2 tables in this database, and the field "Name" only exists in one of the 2 tables. Any help is greatly appreciated. Here is the VB code from the original database. Private Sub Combo64_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Nz(Me![Combo64], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub Private Sub Combo66_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![Combo66] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub Tag: Cannot read Office 2007 DVD
  - 7
    - Why is it so ? Hi, I uploaded a product map file recently, and one of the exe was having version 7.31.0.0 But, when I go to the Product Rollup page, I can see an event for that exe having version 7.20.0.0 . As I understand, mapping process considers the version of that file also. Can anybody explain why 7.20.0.0 is listed instead of 7.31.0.0. In other words how come version 7.20.0.0 event were mapped for 7.31.0.0 mapped file Also the reported events were not sent from my side. Actually this product is used by many users across different timezone and once I uploded the map file, thses events also started showing up. Regards, Dhon Tag: Cannot read Office 2007 DVD
  - 8
    - vlookup I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error DestCity = WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) _ And WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) If I use the first part before the "And" it will find the results to the first occurance. Please help! Tag: Cannot read Office 2007 DVD
  - 9
    - Error when adding axModi to Windows Form. I added the COM Component for MODI (V.12.0) Using Office 2007 version and Visual Studio 2005 When i try to add the control to the form. I get an error: "Failed to import the ActiveX control. Please ensure it is properly registered." How can I add this control Is there a patch for this problem Also I try with MODI (v.11.0) Office 2003 and VS2005, and the same problem. Thanks a lot. Tag: Cannot read Office 2007 DVD
  - 10
    - Blue Star Infotech Offering on SharePoint for ISV and End User Organization Hi All, As a quick introduction I represent Blue Star Infotech, part of Blue star limited a $300 Mil group. We are based in USA & Europe. We are Microsoft Gold Certified Partner. I wanted to discuss and offers our expertise in building products around SharePoint to ISV community. My Company can help ISV's using SharePoint Build products on SharePoint technology faster and more efficiently. For end user organization my company can offer customization, support and independent testing and audit of application on SharePoint. Our service offerings cover the entire gamut starting from consulting, BI, data recognition, customization, and integration. We have an expertise to map the desired functionality to OOB feature list. We can manage site and content security, capacity planning, and storage management. I am wondering if the members of this group would be interested in looking at this service offering. May i request the group to visit my company website at http://www.bsil.com,in case anyone has any query please direct it to me and I will be happy to get it resolved regards Siddhartha Tripathi Tag: Cannot read Office 2007 DVD
  - 11
    - Autoexecuting macros How do you make a macro run as soon as the Excel file it is attached to is opened The version is Excel 2000. I have searched the help files and some forums already. Does anyone have any advice Tag: Cannot read Office 2007 DVD
  - 12
    - Making an array in Excel with the file names of a particular folder Hello, could anyone help me, I already have a macro in Excel that uses an array of filenames to process data, but so far I have to enter the filenames manually. Basically, I want the macro to simply create an array in Excel with the files names and their extension (which will always be the same) located in a particular folder, sucha as: Filename1.ext Filename2.ext ... Filename13.ext There will always be the same amount of files in the particular folder (13 in total) , but this process would really make processing of the data quicker than having to enter the filenames by hand each time. Any help would be grealty appreciated. Tank you! Tag: Cannot read Office 2007 DVD
  - 13
    - error message when closing ie7 The computer administrator profile is not having this problem only the other users on my home computer. Upon closing the browser this pops up: iexplore.exe Application error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b We have ie7. Can someone help Tag: Cannot read Office 2007 DVD
  - 14
    - Newbee - Insert previous cross-ref from the dialog box I would like to have a template that users can work on, and then later go through and select a paragraph or a word to be designated as a cross-reference. I would then like to create a macro that would pop open the cross-reference dialog box (type set to "numbered items", and type set to "paragraph text" as defaults), and have the items list already highlighted so the user pretty much launches the macro, scrolls to the cross reference item they want to insert and hit enter to insert and close the box. I don't want them to have to select the ReferenceType, ReferenceKind, etc. I know that this has got to be something simple and I'm overlooking it. I tried to record a macro to do it, I was having to put things like vbTab & "%m" to select stuff because I didn't know how to stop the macro have the user interact with the dialog box. Now thinking about it, I'd really like to just have a Dialog box that only displays the cross-references I've created show up without using the standard Microsoft box Is that possible Please, steer me in the right direction if I am off here. The application here is for a user to type a "Heading" and give it a cross-reference (can I set a style that automatically assigns a cross reference to the name (e.g. if the user applies the "heading" style to the text ). Then the user, later in the document presses the "macro button", a dialog box of previous references pops up, the scroll to the one they want, hit enter and it inserts it. Sorry, I don't know the proper language to use here; and maybe that is part of my problem. I just got "knighted" to this. I appreciate any input, even if it is "go read..." Thanks. Ferrell Tag: Cannot read Office 2007 DVD
  - 15
    - Need Help on how to use library file (Win32 API) Hi All, Can any one help me on how to use Library files in Excel VBA. I have pasted here some sample. If possible which website can i refer to know about more about this. How to declare and use the constants Private Declare Function WNetAddConnection Lib "mpr.dll" Alias "WNetAddConnectionA" (ByVal lpszNetPath As String, ByVal lpszPassword As String, ByVal lpszLocalName As String) As Long Thanks in advance. Bye Tag: Cannot read Office 2007 DVD
  - 16
    - Easy msgbox Query Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event will not work with functions. Here's what I've got so far: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Range("C11:C12") < 0 then MsgBox "Enter Larger Value." End If End Sub Can anyone help Tag: Cannot read Office 2007 DVD
- Next
  - 1
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( 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 Tag: Cannot read Office 2007 DVD
  - 2
    - Word: How to you determine the current cursor position For one of my macros to run, I have to ensure that the cursor position is not in a table or in a frame when the user activates the macro. How can I find our the current cursor position Once I can determine that the cursor is positioned in a table or a frame, I can then code a message box to instruct the user where to put their cursor to run a certain routine. Tag: Cannot read Office 2007 DVD
  - 3
    - duplicating VBA objects Hi all, on a form, i've got 10 textbox in a row. lets say that i've got x rows. the user need x+1 rows. how do i add the last row thanks. Tag: Cannot read Office 2007 DVD
  - 4
    - Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet hi, i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate. Tag: Cannot read Office 2007 DVD
  - 5
    - Using C# Events over COm-Interop in VBA Hi, i am trying to write a DLL with Code writen in .NET / C# that can be acces in VBA Applications via COM-Interop. Everything seems to work so far, but: I have an Event in my C# Class that i want to acces in the VBA code: --- Public Class VBATest { public event EventHandler OnLogin; public void Test() { ... if (this.OnLogin != null) { this.OnLogin(this, EventArgs.Empty); } } } ---- Now i want to add an event Listener in my VBA Code to the OnLoginEvent. Is there a way to do this or are C# like Events are not Supported to be use over Com-Interop in VBA BTW: If someone knows any tutorials about C#/.Net -> Com-Interop -> VBA (Excel), let me know Thank you very much for any Help! Tag: Cannot read Office 2007 DVD
  - 6
    - Excel VBA - Best way to SQL Insert if SQL Update fails What would be the best way to do this Try/Catch I was trying to check all the records to find the date/hour key but I thought there might be a better/quicker way to check if the record exists...or rather, if the update fails. Would this work Is there a better way to do this or is my thinking wrong Is there a way to check if an update fails...would it throw an exception Thanks for the help! Tag: Cannot read Office 2007 DVD
  - 7
    - Using DCount function in a Report group footer Hi, I'm having trouble getting a DCount function to work on an MSAccess 2003 report. I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group. Here's what I'm using - which produces the result of '#Error' with no further help.: =DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM R_TaskID)") I'm aware of the access definition of expr, domain and criteria syntax for this function, however, I'm not sure what to use for the 'domain' in this scenario. Expr - I gather this should be the field I want to count - 'Task ID' - the field is part of the report detail. Domain - here's where I'm sure I've gone wrong. I think this should be the group recordset but I don't know how to reference them The report uses a query containing tables and queries - but it doesn't have a name. How do I reference the report group level Criteria - hopefully I have this right - I am calling a query. Thanks in advance for any assistance. Liz Tag: Cannot read Office 2007 DVD
  - 8
    - Error 380: Invalid property value:Help Me Please Im working on some coding for an assignment i was given and i neede help as fast as possible. I have been recieving an error message that reads as follows: Run-time error: "380" Could not set the Value property: Invalid property value Ive used F8 in attempt to locate the problem and i have highlighted where i believe the problem is in the coding below: Dim Row As Integer Dim nop As Integer Dim cellc As Integer Dim nosuppliers As Integer Private Sub countchange_Change() countchange.Max = txtnop + 1 txtcount.Text = countchange Sheets("magazine").Select Row = Val(txtcount) + 6 Range("A" & Row).Select ctitle.Text = ActiveCell.FormulaR1C1 Range("B" & Row).Select cissue.Text = ActiveCell.FormulaR1C1 Range("C" & Row).Select cisbn.Text = ActiveCell.FormulaR1C1 Range("D" & Row).Select cbuyprice.Text = ActiveCell.FormulaR1C1 Range("E" & Row).Select csellprice.Text = ActiveCell.FormulaR1C1 Range("F" & Row).Select cstockb.Text = ActiveCell.FormulaR1C1 Range("G" & Row).Select cstocks.Text = ActiveCell.FormulaR1C1 Range("H" & Row).Select cstockr.Text = ActiveCell.FormulaR1C1 Range("I" & Row).Select csupplierno.Text = ActiveCell.FormulaR1C1 Range("J" & Row).Select cinterval.Text = ActiveCell.FormulaR1C1 Range("K" & Row).Select creleasedate.Text = ActiveCell.FormulaR1C1 Range("L" & Row).Select cnreleasedate.Text = ActiveCell.FormulaR1C1 Range("M" & Row).Select cgenre.Text = ActiveCell.FormulaR1C1 Range("N" & Row).Select ccprofit.Text = ActiveCell.FormulaR1C1 Sheets("suppliers").Select Row = Val(csupplierno) + 6 Range("c" & Row).Select csupplierc = ActiveCell.FormulaR1C1 If txtcount > txtnop Then csuppliername.ListIndex = 0 Else Range("B" & Row).Select csuppliername = ActiveCell.FormulaR1C1 End If End Sub Private Sub csuppliername_Change() csupplierno = Val(csuppliername.ListIndex) + 1 Sheets("suppliers").Select Row = Val(csupplierno) + 6 Range("c" & Row).Select csupplierc = ActiveCell.FormulaR1C1 End Sub Private Sub submit_Click() Sheets("magazine").Select Row = Val(txtcount) + 6 Range("A" & Row).Select ActiveCell.FormulaR1C1 = ctitle.Text ctitle.Text = "" Range("B" & Row).Select ActiveCell.FormulaR1C1 = cissue.Text cissue.Text = "" Range("C" & Row).Select ActiveCell.FormulaR1C1 = cisbn.Text cisbn.Text = "" Range("D" & Row).Select ActiveCell.FormulaR1C1 = cbuyprice.Text cbuyprice.Text = "" Range("E" & Row).Select ActiveCell.FormulaR1C1 = csellprice.Text csellprice.Text = "" Range("F" & Row).Select ActiveCell.FormulaR1C1 = cstockb.Text cstockb.Text = "" Range("G" & Row).Select ActiveCell.FormulaR1C1 = cstocks.Text cstocks.Text = "" Range("H" & Row).Select ActiveCell.FormulaR1C1 = cstockr.Text cstockr.Text = "" Range("I" & Row).Select ActiveCell.FormulaR1C1 = csupplierno.Text csupplierno.Text = "" Range("J" & Row).Select ActiveCell.FormulaR1C1 = cinterval.Text cinterval.Text = "" Range("K" & Row).Select ActiveCell.FormulaR1C1 = creleasedate.Text creleasedate.Text = "" Range("L" & Row).Select ActiveCell.FormulaR1C1 = cnreleasedate.Text cnreleasedate.Text = "" Range("M" & Row).Select ActiveCell.FormulaR1C1 = cgenre.Text cgenre.Text = "" Range("N" & Row).Select ActiveCell.FormulaR1C1 = ccprofit.Text ccprofit.Text = "" Range("O" & Row).Select ActiveCell.FormulaR1C1 = txtcount.Text txtcount = Val(txtcount) + 1 Row = Val(txtcount) + 6 Range("A" & Row).Select countchange.Value = txtcount + 1 txtcount = countchange.Value Range("C" & "2").Select txtnop = ActiveCell.Value End Sub Private Sub UserForm_Initialize() Sheets("magazine").Select Row = 7 Range("A" & Row).Select ctitle.Text = ActiveCell.FormulaR1C1 Range("B" & Row).Select cissue.Text = ActiveCell.FormulaR1C1 Range("C" & Row).Select cisbn.Text = ActiveCell.FormulaR1C1 Range("D" & Row).Select cbuyprice.Text = ActiveCell.FormulaR1C1 Range("E" & Row).Select csellprice.Text = ActiveCell.FormulaR1C1 Range("F" & Row).Select cstockb.Text = ActiveCell.FormulaR1C1 Range("G" & Row).Select cstocks.Text = ActiveCell.FormulaR1C1 Range("H" & Row).Select cstockr.Text = ActiveCell.FormulaR1C1 Range("I" & Row).Select csupplierno.Text = ActiveCell.FormulaR1C1 Range("J" & Row).Select cinterval.Text = ActiveCell.FormulaR1C1 Range("K" & Row).Select creleasedate.Text = ActiveCell.FormulaR1C1 Range("L" & Row).Select cnreleasedate.Text = ActiveCell.FormulaR1C1 Range("M" & Row).Select cgenre.Text = ActiveCell.FormulaR1C1 Range("N" & Row).Select ccprofit.Text = ActiveCell.FormulaR1C1 Range("C" & "2").Select txtnop = ActiveCell.Value Sheets("suppliers").Select Row = 7 Range("C" & "2").Select nosuppliers = ActiveCell.Value Range("B" & Row).Select cellc = 0 Do While cellc <= nosuppliers csuppliername.AddItem (ActiveCell.FormulaR1C1) cellc = cellc + 1 Row = Row + cellc Range("B" & Row).Select Loop Sheets("suppliers").Select Row = Val(csupplierno) + 6 Range("c" & Row).Select csupplierc = ActiveCell.FormulaR1C1 Range("B" & Row).Select csuppliername = ActiveCell.FormulaR1C1 countchange.Max = Val(txtnop) + 1 End Sub If you need any more info on the program dont hesitate to ask. Please try to help me. Tag: Cannot read Office 2007 DVD
  - 9
    - Windows Error Reporting - handling unanticipated errors For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them) Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it Tag: Cannot read Office 2007 DVD
  - 10
    - Is there a better way to debug. I learnt all of my programming in Java and used to use the command prompt/debug window extensively to print information out to. I could use this to check flow and determine when things were executed, the order and more information about the workings of the code. In VB I have been using Msgbox along with the Str() command. This is rather intrusive to the operation of the system. It also makes it hard to determine the order. I thought of dumping stuff to a text file but thought that is rather complex and not as useful as a command prompt. Any suggestions would be great. If a text file is the best option an example would be great. Tag: Cannot read Office 2007 DVD
  - 11
    - Display a value in a looping status Hello. I am working on a program that requires me to generate a status of the program I am writing. Up to now I can display every string values out onto the txtDisplayText box but except that last one which the value was generated from the serial port Code Snippet Dim sRx_Buffer As String Dim sRx_Msg As String commSerial.Output = stringValue sRx_Buffer = commSerial.Input sRx_Msg = Conversion(sRx_Buffer) *Conversion function* txtDisplayStatus.Text = txtDisplayStatus.Text & _ "From Serial device: " & generatedValue & vbcrlf & vbcrlf I let it run in a loop function. Everything shows up except the last one. I set a breakpoint to check what's in the commSerial.Input. I did see some values but the variable could not capture the string of data that is from the serialComm.Input. Any help on this Thank you very much. Tag: Cannot read Office 2007 DVD
  - 12
    - Excel Macro Help needed for the code in excel Marro... I have a backend excel file in LAN server, which acts as main database... and n numbers of fronend excel file with n numbers of users...... I have written a code where data will be submitted from frontend to backend in a click of a button.... I want to check if the backend excel file is open somewhere/anywhere before executing the code further.... Tag: Cannot read Office 2007 DVD
  - 13
    - Subscript out of range with a simple sql :-( [newbie to VBA] 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 'Database connection & select all from Table Set objDB = DBConnect() Set oRS = objDB.Execute("SELECT * FROM `production` WHERE id<1000000") 'Dump Records from Table nRec = 0 row = 1 Do While Not oRS.EOF For Each oFld In oRS.Fields 'WScript.Echo oFld.Name & " = " & oFld.Value Worksheets("Tabelle1").Cells(row, 1).Value = oFld.Value 'increment row = row + 1 Next oRS.MoveNext Loop End Sub Function DBConnect() Set objDB = CreateObject("ADODB.Connection") objDB.Open "ago_usgroups" Set DBConnect = objDB End Function Tag: Cannot read Office 2007 DVD
  - 14
    - VB code in Access forms Hi, i'm a beginner in the VB code world but enjoy making things happen in the rare instances that they do! I'd really like some VB code / help for the following: I 'm designing a database with user input forms and am stuck on how to use VB code to make it do the things i want it to... I want code to do the following: For each new record i only want the parent form to be accessible for data entry, after all its fields are in then the subforms which appear on the same form can then be made accessible for data entry. Problem is i don't know how to refer to the NewRecord property via VB and then turn on / off the data entry properties of the subforms. I would also like to know how to use the value of the current record (automatically incremented with every new record), ideally i'd like to sync this in with a reference number on the actual parent form. Any help much appreciated. Catherine Tag: Cannot read Office 2007 DVD
  - 15
    - Run-time error '13': Type Mismatch i always get this error when i try to run...does anyone know what's the problem Code Snippet Option Explicit Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "Research & Development" cbxDept.AddItem "Finance & Control" cbxDept.AddItem "Human Resource" cbxDept.AddItem "Globe & ISIT Services" End Sub Private Sub cmdPrevious_Click() If txtRow.Text > 1 Then txtRow.Velue = txtRow.Value - 1 UpdateData End Sub Private Sub cmdNext_Click() If txtRow.Text < Range("Database").Rows.Count Then txtRow.Value = txtRow.Value + 1 UpdateData End Sub Private Sub txtFName_AfterUpdate() Range("A2")(txtRow.Text).Value = txtFName.Value End Sub Private Sub txtLName_AfterUpdate() Range("B2")(txtRow.Text).Value = txtLastName.Value End Sub Private Sub cbxDept_AfterUpdate() Range("C2")(txtRow.Text).Value = cbxDept.Value End Sub Private Sub txtRow_AfterUpdate() If txtRow.Text < 1 Then txtRow.Text = 1 ElseIf txtRow.Text > Range("Database").Rows.Count Then txtRow.Text = Range("Database").Rows.Count End If UpdateData txtFName.SetFocus End Sub Private Sub UpdateData() txtFName.Text = Range("A2")(txtRow.Text).Value txtLName.Text = Range("B2")(txtRow.Text).Value cbxDept.DropButtonStyle = Range("C2")(txtRow.Text).Value End Sub thanx Tag: Cannot read Office 2007 DVD
  - 16
    - ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where I should ask instead, please drop me a note, thanks!) On Vista, ReportFault()'s behavior changed, unfortunately. With the default error reporting settings (automatic reporting without asking the user), it sends the crash report to the Winqual site - and then terminates the application. However, in my particular case, I need to re-gain control after WER reporting in my application in order to perform additional logging and clean-up, and to provide users with an option to continue working for a limited time (for example, to try and save their current data). Since ReportFault() didn't do what I wanted, I tried the WerReportCreate/WerReportSubmit combo instead. Those APIs do indeed return and don't terminate the application - but they also don't seem to report all the crash details correctly. For example, I've never seen any indication that one of the crash reports produced by the WerReport* APIs contained minidump information (judging from the problem report history in wercon.exe). My first guess is that I'm simply not using the WerReport* APIs correctly - but after trying lots of different options and variations, I'm pretty much at a loss. Hence my questions: - Where can I find tested sample code which uses WerReportCreate/WerReportSubmit() - Is there a way to use ReportFault() under Vista without terminating the application Thanks! Claus Brod Tag: Cannot read Office 2007 DVD

KRFournier

Has anyone experienced the problem of not being able to read the Office 2007 Enterprise installation DVD in a DVD R/RW drive. So far, three drives I've tested cannot read the disc. No error message. Nothing. The drive spins a little, but never sees it. I cannot access the drive through Explorer either. I've even updated the firmware. My drive's are all Lite-On drives, so I don't know if that has any effect.

I've gotten around it on one machine by installing a second DVD ROM drive, which can read the disk just fine. Is it expected that a DVD R/RW cannot read a DVD ROM disk Please tell me I'm not the only one.

Thanks.

Re: Cannot read Office 2007 DVD

wldaly

I'm having the same problem. Can't read any of the DVD's from Action Pack on my laptop. The specs on the drive say it will read DVD-ROM.

If I make a copy from another workstation it will read the copy without a problem.

Bill

Re: Cannot read Office 2007 DVD

Lumoruk

Hi I'm having same problem too, I recently installed using LG drive. I've now got a Lite-On drive and having no luck reading the disk, every other disk works fine on my drive.

Re: Cannot read Office 2007 DVD

MS ISV Buddy Team

There must be more people that have run into this problem, because there's a support article that covers this topic, with a number of options. http://support.microsoft.com/kb/924619

If these suggestions don't allow you to read the disk, there's a section towards the bottom of the page that discusses replacement options.

Hope this helps,

-brenda (ISV Buddy Team)

Re: Cannot read Office 2007 DVD

KRFournier

I actually saw that KB article before posting, but it didn't solve the problem. Seeing as I could reproduce the issue on three separate drives, I was convinced that it was either some kind of incompatability or defect in the disk. Ultimately, I just opted to make a direct copy onto a DVD R+, which worked fine on all my "problem" drives.

I think it's safe to say that something about these DVDs troubles a certain type of DVD/RW drive. At least I have a work around--DVDs are cheap.

Thanks to all who shared their knowledge.