Microsoft ISV

Page 147




  • Topics
    Replies
    Last post
  • 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
  • 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
  • Can't remember the purpose of these lines of code in my project?
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hi, I just can't remember what the following lines of code are here for! Please put me out of my misery... Code Snippet Private glb_count As Integer Public Property Get GlobalCount() As Variant GlobalCount = glb_count End Property Public Property Let GlobalCount(ByVal vNewValue As Variant) glb_count = vNewValue End Property
  • Excel Dialogs
    by Keithyboy1
    3 Replies
    Last post by Andy Pope
      • I have a routine, which calls for the Excel SaveAs dialog box, using the code snippet below: Code Snippet Application.Dialogs(xlDialogSaveAs).Show fileName I am passing the string variable, fileName to the Show method. This variable is created with the code below: Code Snippet fileName = "CC " & cmbCostCentre.Value & " - " &
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
  • Delete Unwanted rows based on value in cell
    by Donaghy
    7 Replies
    Last post by magicalclick
      • Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "
  • Microsoft Project 2003 (How to open a save as dialog box with a macro?)
    by Dannemann
    4 Replies
    Last post by Dannemann
      • Hi people! I'm having trouble in opening a dialog box in VBA. I need that when i click in a form button, the save as dialog appears to save a txt file im not finding not on google and other searches engines please somebody help me.. im looking this since yesterday thanks folks a hug
  • VBA excel outlook / A program is trying to send mail using Item.Send
    by rhXX
    7 Replies
    Last post by LuisEG
      • hi, i am trying to send an automatic mail from excel VBA to the outlook outbox, when i send the mail i obtain this security warning: A progam is trying to automatically send e-mail on your behalf. the help buttom says: A program is trying to send mail using Item.Send A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want
  • WER wish list for developers 8-)
    by Claus Brod
    14 Replies
    Last post by Joel Stein
      • Jason Hardester posted today about some of the decisions made at Microsoft around WER, and concluded with a call to action to collect requirements for WER from a developer point of view. I'm glad to oblige (And thanks, Jason, for your helpful post.) My main issue with the current implementation of WER, particularly on Vista, is that it makes it hard for a developer to find out whether a crash rep
  • Macro to delete entire row that contain a specified value in a chosen column
    by sree
    2 Replies
    Last post by sree
      • Hello, I need help to write a macro where i could delete the entire row if it contains "Financials" in column D. Is it possible to record a macro. or should i have VB programming skills. Thank you in advance Sree
  • Adding Outlook signature using OLE automation.
    by jpas
    5 Replies
    Last post by jpas
      • Is it possible to add a signature to an Outlook message using OLE automation Outlook is configured to automatically add a signature to outgoing e-mails. If I don't try to set objMailItem.HTMLBody to any value after creating the Mail Item object, the signature is in the e-mail as expected. If the HTMLBody is set to a value, the signature is lost. Trying to pre-pend the application data to t
  • excel 2003 - sp2 - OpenTextFile(,ForAppending,,)
    by jdrean
    1 Replies
    Last post by Peter Mo.
      • in vba the following command will generate an execption: Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(filename, ForAppending, , 0) Instead one needs to replace ForAppending by 8 (the default value from the system is 3) note: it is confusing because it is working for ForReading and ForWriting
  • Access 2007 - Create email form to be sent via Lotus Notes
    by bloukopkoggelmander
    0 Replies
    Last post by bloukopkoggelmander
      • Hello all First , I am new to this forum and if I am not following any correct procedures, then please let me know. My problem is as follows: I am trying to create a form in Access 2007, layed out in the format of a new email memo. I then need the user to fill in the standard like To,CC,BCC,Subject,Body,Add Attachment. I have now idea how to make this work in Access usi
  • Erratic Performance using Workbooks.Open
    by lgoldstein
    1 Replies
    Last post by magicalclick
      • Using Excel 2003, I'm writing what should be a quick application using VBA to open a series of Excel files and perform nearly 800,000 calculations (sad, but true). Typically, I use the Workbooks.Open method, either preceeded by Application.GetOpenFilename so the user can select the file to open or without where the filename is generated programatically. I'm running into Error 1004 (applicati
  • INSERT INTO string Object into Access table
    by Andy576879
    2 Replies
    Last post by Andy
      • Hello After running script I 've got error "Too few parameters Expected" for test I try to put only one string in table "StudyTrack" with one column "Status" if I use instead string object "strStatus" ('abc') it is working fine ,but SQL don't see string Object. I suppose it syntaxes error, but I can not find the right one. I would really
  • how to use variable to automate selection of a worksheet
    by sree
    6 Replies
    Last post by sree
      • Hi all!!!!!! Thank you in advance for helping me with this. I need to know how can i use a variable in VBA to read data in a cell which should be the worksheet name of one of diffrent worksheets in a diffrent workbook. To simplify- i have two workbooks [Book1.xls and Book2.xls] i need to run a macro to read A3 in sheet 1 of Book1 and store it in a variable A.
  • How do I 'click' inside a List Box!!
    by Quarry
    2 Replies
    Last post by Quarry
      • Hi, when a user clicks a command button I want it to automatically click (enter) a list box. I have tried using the set focus event but i need my code to actually click inside the list box.
  • TreeView Code published in KB209891 works good for Northwind Database, but not for my file!
    by Janinder Virk
    1 Replies
    Last post by Cringing Dragon
      • I pasted the code from KB209891 http://support.microsoft.com/Default.aspx kbid=209891 in the Northwind sample Database. It worked like a charm. I was very happy that it is working and I will have my problem solved in no time. But! when I added it into my required file and made the necessary changes as suggested in the artilce. I get a message "Type mismatch error" at the line .....
  • Business and market share of Software Players
    by Jessica Alba
    0 Replies
    Last post by Jessica Alba
      • Not sure if this is the right folder, but I can't find where to look for this information. This is more a business question. We have Microsoft, Oracle, SAP and maybe IBM as the dominant players in the software industry. I would like to know the market share, prospect and the future trend of these players in the industry. For example, in particular, the ERP Sytems, currently it is SAP getti
  • VBA for Access 2003 not seeing ADOX nor some ADODB objects
    by anhyzer
    2 Replies
    Last post by anhyzer
      • I have the basic install of Access 2003 and am using the standard VBA that installed with it. When I'm adding code and start a line with "ADODB.", I can get some objects such as Fields or RecordSet, but not others such as Stream or Record. If I manually type in either "ADODB.Record" or "ADODB.Stream", I get a "User-defined type not defined" compile error. Th
  • How do I configure sharepoint data to point different directory?
    by eac022403
    3 Replies
    Last post by MS ISV Buddy Team
      • I have created 20 GB vhd and install my SharePoint on it. Everything I put as data will be written on that 20 GB vhd. But if I put all my data in shared folder, it will be filled out quickly and I will be out of space. Is there anyway to store the new data other than the vhd and still be shared For example for my shared folder, I want to put the data in another drive but I want them to be shared t
  • What is the VBA code to insert an Object into an Excel File
    by amanda_m_wilson
    8 Replies
    Last post by amanda_m_wilson
      • Hi, I have recently been requested to create a button on an Excel spreadsheet that will insert an Object (usually a MS Word Document but not always) into the Spreadsheet as as Object. The user would need to browse for the document and select the file, then the file would attach and be displayed as an icon. In short, the smae as using the Insert > Object >Create From File (Display a
  • PPT: Display total # of pages for handouts
    by Cody
    1 Replies
    Last post by Andy Pope
      • I'm trying to print handouts (with 6 slides per page) that will include a footer that displays the total number of handout pages. So, for example, if there are 14 slides, the handouts would show that there are 3 pages. Using this code works for displaying the total number of pages for the entire presentation: Code Snippet With ActivePresentation.Slides AddOne = IIf((.Count Mod 6) = 0
  • Saving a pic
    by Edday
    7 Replies
    Last post by Andy Pope
      • hey i really need help with this, i have posted in tons of forums and the descussion groups, no replies! gar lol, well i have this macro in excel 2003 and it has a userform and there are a few elements (3 pictures, 3 text boxes) that get modified during the macro then i need to kinda merge them and save it as one picture, can a macro do that any help would be great thx
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i