Microsoft ISV

Page 31




  • 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
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • Creating Excel File Error
    by CoderMike
    2 Replies
    Last post by CoderMike
      • Hello, I'm trying to create an Excel file using ADO. I can read from an Excel just fine, but creating it has been more of a problem. When I try to open a connection to a file name, I get "object not found" error. According to the MS article I read, the workbook should be created automatically when I create my first table in the workbook. However, I can't see how I can do this if t
  • VBA Help?
    by NWAprog
    6 Replies
    Last post by NWAprog
      • I'm new to VBA programming, while I understand Access a fair amount, I am continually running into the same problem. Can anyone help. I am developing a program for my job that tracks times. I have created forms that are supposed to make the entry easier and faster. On the first form the operator enters the information relating to the trouble call, when the submit button is clicked, the info
  • Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?
    by johnson hk
    13 Replies
    Last post by dionjuan2004
      • In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, m
  • VBA Or Access
    by Crysallis
    2 Replies
    Last post by Crysallis
      • Currently I've written a db and on one of my forms I've used the builtin combo box tool and used it to have you select and item from the list and update the data on the form. Now on my machine I can, when I open the form, simply start typing in a number thats inthe list and it will seek to that number and I can press enter and it will update the form. Now when I do this on another machine it gi
  • Emailing data with Access
    by DJRave
    0 Replies
    Last post by DJRave
      • Hey there! For my work I keep track of things in an Access database. I receive data, edit and regroup it and after that distribute it to other people. Every month I have to mail exported *.txt files to a group of people. And since not everybody gets the same data I need to select the files/emailaddresses manually. I want to let access do this automatically to reduce the work and chances of
  • running access queries using VBA
    by A Zhu
    1 Replies
    Last post by ADG
      • Hello, Say for example, I would like to using a dynamically generated query (using VBA) to select the records in such a way that, for example, the Client ID field in table A has to be found in the CID field somewhere in Table B and the Amount field in Table A should be differ by the AMT field in Table B by no more than 100. How could this be accomplished using VBA Thanks!
  • SAP
    by envi_ria
    11 Replies
    Last post by envi_ria
      • HI Does any one know what is the procedure and purpose of doing SAP. What are the requiments, and how can I go about doing the training. What are the courses available for the same. I am an IT trainer for the last 2 years would like to do SAP. Supriya
  • Attempted to read or write protected memory. This is often an indication that other memory is corrupt
    by Girish Nair
    4 Replies
    Last post by Tan Check Leam
      • I am getting this error when trying to open oracle connection from visual studio 2005. I am pasting the stack trace here. at System.Data.Common.UnsafeNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.OciEnlistContext.Joi
  • Disable macro toolbar button in macro itself
    by oryan_dunn
    2 Replies
    Last post by oryan_dunn
      • I have a macro that I want to disable after it is finished running. I would like to grey out the button on the toolbar. Is this possible If not, how would you recommend removing/disabling the button Thanks, Ryan
  • Worksheet.Copy causes execution to stop
    by pnp
    11 Replies
    Last post by pnp
      • Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: W
  • 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
  • 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 '
  • Spooler error 1068
    by Terminator484
    14 Replies
    Last post by virginia3443
      • I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa
  • windows vista program files protection
    by sharadam
    2 Replies
    Last post by Mo Nail - MFST
      • Hai all, i am installing my application at c:\program files\ APPFolder. At the time of installation, default settings are stored in config file at c:\program files\ APPFolder\configsettings.xml . when i made changes in application , i am updating all settings to an XML file . when i unistall my aplication i am removing xml file. when i reinstall my application as admin , again config file with d
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • 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
  • Read data from excel through VB.NET
    by Prasanth.P.P
    12 Replies
    Last post by Srini111
      • Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim
  • ExOleDB in Exchange Server 2007
    by Alexander Basyuk
    2 Replies
    Last post by Young Developer
      • I have developed an agent for Exchange Server. It use exoledb and event sinks for interacting with Exchange. For registration we use RegEvent.vbs (from Exchange Server 2007 SDK). It works fine on 2000/2003 versions. But on Exchange 2007 even RegEvent.vbs script doesn¡¯t work. It shows ¡° Error Opening Connection : 3706 Provider cannot be found. It may not be properly installed. ¡± I use
  • Creating new table in Access 2003
    by Tantani
    2 Replies
    Last post by Tantani
      • Dear, I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA. Any solution Thank you in advance!
  • iexplore.exe application error
    by stargal46
    6 Replies
    Last post by Morena916
      • Hi...I'm not sure if I'm putting this in the right forum, but here goes. I'm receiving an error message which says, iexplore.exe - Application Error The instruction at "0x66869bc7" referenced memory at "0x0000002c". The memory could not be read". Click on OK to terminate the program. I had trouble installing QuickTime player and then when i finally did get it t
  • How to check is there duplicate value somewhere in Combobox
    by Hoowah
    2 Replies
    Last post by Andy Pope
      • I was wondering, is there a way to check if there is same string value in Combobox with Excel Basicly I'm trying to make a check that makes sure, there are no duplicate value of the value I'm adding to Combobox. I tried to get the values like this, but it didn't work. ActiveSheet.Shapes("Combobox").Select With Selection For i=0 To .ListCount If .Item(i) = someString Then
  • Vba Excel 03 - Detect Shape Position and calculte related row number when sort / filter is activated
    by ajliaks
    6 Replies
    Last post by ajliaks
      • Hi guys, I have an excel datasheet where each row has on it a Shape called "myShape" + the Number of the Row where it is located, in example:
  • this problem is also troubling me now!! :(
    by Moim Hossain
    14 Replies
    Last post by WebDev2000
      • Hello everybody, I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int