Microsoft ISV

Page 136




  • Topics
    Replies
    Last post
  • Speed with Excel 2007
    by sunzhoujian
    1 Replies
    Last post by Andy Pope
      • Did anyone test with Excel 2007 How is the speed given a large amount of data (for example, 1Million row) I am seriously considering this new feature for some financial applications...
  • .mdmp files not being created
    by David Ching
    28 Replies
    Last post by David Ching
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • programming "yes-to-all" functionality
    by pacificwaters
    4 Replies
    Last post by pacificwaters
      • I'm using VB 6.3, and I'm trying to program a Yes-to-All (and No-to-All) button, which doesn't exist in the MsgBox functionality. Currently trying to use the .doalert method: With Application.Assistant Select Case .DoAlert( _ "Invalid Member", _ message, _ msoAlertButtonYesAllNoCancel, _ msoAlertIconQuery, _ msoAlertDefaultFirst, _ m
  • WER and file version differentiation
    by Joel Stein
    3 Replies
    Last post by Joel Stein
      • When mapping files against version numbers, does WER (and the watson servers) compare all four version_info fields For example, I have mapped version 4 of my application, for example, MyApp.exe, which has version 4.0.6192.0. As bug fixes are done for this application, the last integer gets bumped...now we are up to 4.0.6192.27. Do I need to remap the application, and/or upload a new map
  • Subscript out of range
    by NutoVBA
    6 Replies
    Last post by NutoVBA
      • I am new to VBA and am trying to create a copy of a sheet from one workbook to another workbook using the following code: Workbooks.Open Filename:=bw_path & "\" & bw_file 'Opening the file from which I want to copy. Sheets(bw_sh).Copy After:=ThisWorkbook.Sheets(3) 'Trying to copy the open worksheet into the workbook housing the macro. I am getting the "sub
  • Vba To Calculate Across Monthly Worksheet
    by Naz75
    0 Replies
    Last post by Naz75
      • Hi all, My problem is that I need Week Totals to calculate the day dated sheets before them and the Monthly total to calculate the Week Totals. Every month the workbook will be different due to amount of days and dates in each month. I was hoping if someone could help me out with code to make this work. The ranges are B6:E24, G6:H24, K6 24 (top team) The ranges are B28:E49, G28:H49, K28 49 (bott
  • Cannot sign in to communications service error on Vista (credentials prompting)??
    by markm75c
    3 Replies
    Last post by markm75c
      • 'You may have entered your sign-in name, username, or password incorrectly' This error suddenly occurs on my Vista x64 machine.. I've seen articles pertaining to XP and a dll to fix, but this doesnt apply in Vista. Has anyone run into this I suspect a log off or reboot may fix it; Its rather aggrivating though, if you try to enter credentials manually it still occurs. I can sign into Com
  • Generate log file when updating Excel Worksheet file
    by mrtaktak
    1 Replies
    Last post by ke wenzel
      • Can anybody giving advice or help if I want to generate a text log file whenever I open an Excel Worksheet file and update it Would that be possible to be handled by VBA code Thanks a lot for any help. Victor.
  • Application.FileSearch in Excel 2007
    by DieZeL
    14 Replies
    Last post by Jon Peltier
      • There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\S
  • Position a Cell at the top left conrner of the window
    by John in HK
    3 Replies
    Last post by Andy Pope
      • I'm writing a routine to process a series of tables with user input. The user needs to be able to see the table, as well as the UserForm which gets his input, so I need to move the window so that a particular cell is at the top left hand corner of the window - is there a way to do this in VBA Thanks
  • Passing Function As Argument
    by Douglas Penna
    4 Replies
    Last post by Douglas Penna
      • I dunno if it's possible, but I'd like to pass a function name as an argument to a function. The idea is to use the result of the function to do some calculations, no matter what the function is. It would be like this: Function Find_Zeros( Function_Name As Function, Value_X As Double, etc) Thanks in advance.
  • 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
  • Renaming files with VBA
    by DJRave
    2 Replies
    Last post by DJRave
      • Hey there, I'm a rookie in VBA programming and I've got a problem that I want to solve with a VBA script. I've been trying to rename files I receive and after this import them in Access. I have a script that imports the files but the renaming is a problem. The filenames change every month. Further the number of files I receive varries between 70 and 80 a month. They have long filenam
  • runtime 2465 can't find field "|" referred to in your expression
    by Seabass
    4 Replies
    Last post by Seabass
      • runtime 2465 can't find field "|" referred to in your expression. Here is the code. I know that the fields exists in the table and the object exists on the form. Private Sub Command32_Click() Dim db As Database, Tools As Recordset Set db = CurrentDb() Set Tools = db.OpenRecordset("tblCodedCuttingTool", dbOpenDynaset) Do Until [tblCodedCuttingTool]![ToolCode] = Forms![frmCodedC
  • 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
  • Check Boxes
    by jtminqc
    2 Replies
    Last post by jtminqc
      • I am a self taught newbie in Excel VBA, so my question could be very trivial. I have a UserForm that, among other things, has a CheckBox in it. Say CB1. I would like CB1 to show its last state, whenever I open the UserForm. If it was TRUE last time, I want it to show the check mark, in full black, when I open the form. How do I do that JtmInQc
  • Executing code automatically
    by une
    1 Replies
    Last post by Andy Pope
      • I wrote some code within a UserForm that does xyz when a command button in the UserForm is clicked. I then created a macro that runs the code in the UserForm using the statement "UserForm1.Show". I then added a custom button to a toolbar that the user can click to run this macro. The result is the user clicks a custom button on a toolbar and the UserForm appears, instructing the user to
  • 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
  • Executing a SQL Stored Procedure from MS Access via VBA
    by Poppy Lochridge
    1 Replies
    Last post by Cringing Dragon
      • I'm upsizing a database from Access to a SQL backend combined with an Access frontend. Along the way, I'm trying to shift the larger queries into stored procedures, but many of our queries require variables. I'm having a hard time with the VBA to run this stored procedure, and looking for suggestions that make sense to a relative newbie to VBA. Here's my code, which is being triggered by a button
  • Runtime Error '2001'
    by Mona_D
    6 Replies
    Last post by cobolisdead
      • I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Nam
  • Numbers in textboxes VBA Excel
    by rascalcat
    4 Replies
    Last post by rascalcat
      • I am trying to use a userform with 3 textboxs. 2 are for user input of numbers. The other is to display the calculation result using the input numbers. Having problems getting the + operator to do what i want
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • Format text in MsgBox
    by une
    5 Replies
    Last post by une
      • How do I format text that is presented in message boxes. I have looked for what I know as escape characters, but like a lot of things maybe MS calls these something else. I want to for example add newlines and tabs. Changing font would be handy also, as would the ability to add images. If you can help on the fonts and images fine, but at the moment I really need to be able to add newlines and tabs
  • Comparing two word documents
    by SurajJaldu
    4 Replies
    Last post by kannaiah
      • Hi All, I have to compare the text of two word documents using VBA. These word documents contain images and tables also. But I just wanted to compare the text. Can anybody please let me know how to do this Thanks, Suraj
  • adding controls to multipage at runtime
    by LSF
    2 Replies
    Last post by LSF
      • Hello, I need help with a simple task. I'm trying to add a command button to a page in a multipage control at runtime. I've searched for ways to do this and found the same answer multiple times but when I try it myself it doesn't work. This is what I have: Dim MyTextBox As Control Private Sub imgMap_Click() Set MyTextBox = MultiPage1.Pages(2).Controls.Add("MSForms.TextBo