Answer Questions

• ABMA Social/Ethical Question!

  In the US, if your boss was angry at you for not doing something the right way, or any other reason, and amidst the conversation he says "f*** you". Another employee hears this while you're talking. Please state if each of the following statements are true or false:   1- Your boss does not respect you, if he did, he would never say this no matter how angry he is. 2- Your boss is not a respectable man himself, or he would have never used ...Show All

• Ahmad_Jafari Office 10 \ winword.exe runtime error

  I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. I found a solution that worked for me! You ca ...Show All

• keithGard Using a Macro (VBA) to select a variable number of rows

  I have an Excel spreadsheet that I need to copy a variable number of rows from 1 worksheet to another within the same spreadsheet (workbook). I have a variable (NRRows) that contains the number of rows that I want to copy, ie: from row 1 torow "NRRows". I need to be able to select the entire set of rows at one time, copy them all at once and then paste them on another tab in the same spreadsheet. How can I do this or for that matt ...Show All

• Haider Ali Khan VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. The problem is not with the "=COS(", but with the"pi*A2". Try: =COS(PI()* ...Show All

• Nigel Richardson Macro to sort an Excel column

  Hello, I am trying to create a macro to sort a column starting at a cell activated by the user. I programmatically select the range of cells starting at the selected cell over which I want to do the sort on. But I am stuck on what to do for the following snippet of code: Selection.Sort Key1:=.Range(<something>) ... I don't know what to stick in place of <something> to represent the selected range of cells in the column ov ...Show All

• Apsis Go-Live for alpha/beta programs as well?

  We are about to move to a limited alpha test for our .Net 2.0 based product. This would be a very limited deployment under strict NDA. So far I have failed to understand from the description and FAQ of the Go-Live program if we (and our alpha sites) still need to sign up  for Go-Live, or if that is only necessary for a more public deployment Many thanks. Chrutil here's some follow up information on ...Show All

• PixelSlave Someone mind helping me with Error 426

  I am hoping that someone wouldn't mind helping me out here. I have a macro in Excel 2003 which I use to modify some data and then put it into MapPoint 2004. I noticed the memory usage for MapPoint jumps up to 175-180 MB when I initialize territories so I decided I would create a subroutine to close the program and then reopen it. Unfortunately MapPoint 2004 does not let you close a file, only the entire program (unless you are using "Map ...Show All

• Chosie Problem with deleting records

  HI, I am using the following function to delete a record from sysDeptDef table which is not present in ups_new table. I have two rows for the same deptid but diff attid. when i use the delete command the two rows get deleted but when the loop executes it cannot find the deptid so it fails.can please anyone suggest me how to handle this situation. Dim CurrentLevel As Integer Dim CurrentDeptId As Variant Dim LevelUp1 As String Dim L ...Show All

• Dhinesh Windows known applications web service

  Windows known applications web service In Windows XP, when you try to open a file that is unknown to the operating system, you are given two options 1> Use a web service to look up the application 2> Select the application from a list How do I register my application with the Windows Web Service so that when a user opts to look up the application using the web service, they are able to do so ...Show All

• Kalisurfer Deployement project build ERROR - URGENT!

  Hello Everyone, I wrote a little program in C# to read and write from a ms access database and I wanted to create a deployment project. I followed the wizard and included Documentation, Source, Debug, and primary files to the Setup project. also under detected dependencies I added the Microsoft .NET framework and System.Data.SqlClient.dll. BUT when i try to build it it gives me this warning: Warning 1 Unable to find dependency 'SYSTEM' (Si ...Show All

• Joyce_David Microsoft Partnering and License

  I am planning to start a Company. I want to develop solution for Small business to Grow. I have done good amount of study for Small business. I feel there is a great potential for me to enter. My Questions are. 1. My first Application requires a Data base server for small Business. If I register as an ISV, am I allowed to distribute Microsoft SQL server 2005 Express edition once it released along with my Application 2. Some time there is a cla ...Show All

• mleible VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   I believe that Visual Studio Tools for Office will be replacing VBA in Office 12, but that Microsoft will still support VBA. Here's a few sites that may be of use: http://www.microsoft.com/office/preview/default.mspx http://msdn.microsoft.com/offic ...Show All

• TheCurse Controlbutton settings

  Hi, I have a little big problem. (I am a beginner) So : I made in access a form wich contains several control buttons, which are linked to a table. each button has the name (original) Command + number there are 4 main buttons, which charge a specific table when you click on them. so far so good. these tables are a listing of types. each type has a name and a code I search a value with Dmax Now I need : 1) a series of invisible ...Show All

• Rayr Charts.Add method causing error

  I needed a macro to add a chart with a very specific format. I created a macro that usually works, but I am getting an error that I don't understand. Here is a snippet from the macro: Set chartRange = Selection Charts.Add ' This line results in a "Type Mismatch Error" the first time it is run ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=chartRange, PlotBy:=xlColumns '... When I open a new sheet, and put some data in an ...Show All

• swizz_balu Access Link Table with Outlook Problem

  Hi, I'm having problem in create a link table that retrieve task from Outlook. It can create a table. But with nothing in it, except the %Complete data. The rest of field were empty. Does any have any idea about this Or, Would you mind to show me on how to create a link table in access that retrieve Task from Outlook , which including start date/end date Regards, David It is great to hear a response to this long time issue - the inabilit ...Show All