Answer Questions

• Marian Andrei Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  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, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• CorkChop licences for Open Src/non-profit projects

  What are MS licencing policies about: - for non-profit organizations - for Open Source projects (in Java) Can u give me any link What is the trial period for: - MS VS .NET 2005 Architect - MS SQL Server 2005 Enterprize Link on download More specifically I am interested on .NET, Office development tools and products Guennadi Vanine Here's the link to the Microsoft Volume Licensing site: http://www.microsoft.com/licensing/defa ...Show All

• dcleary Color Index

  I want to use a custom color palette in Excel, by redefining some of the default colors. I'm trying to choose the colors in the default palette that most closely match the custom colors. Looking at colorindex 11 and 25, 5 and 32, and some others have the same RGB value. Does this mean that they are the same color And can I set my own default RGB value to duplicates with impunity Phineas The color is defined by the RGB values. If two ...Show All

• CurtCBerry VBA6.4 sdk issues

  HI. Just installed VBA6.4 , when I open a access database, i get a error msg saying that it cant locate VBA6.dll... A search of my system fails to find that file. How do I get this dll... and are there others I need as well.. Per the support engineer: Base on my understanding, our buddy is work on VBA SDK 6.4. However, he met some problem and can not locate VBA6.dll file. Actually, as I know, VBA6.dll is not required to run VB ...Show All

• vcspec Help! Math problem

  I am using vb in excel and have run into an issue I can't figure out. Just for testing, I have a form with a button that calls a function: function test() dim a a = 1.09 - 1 msgbox a end function I am looking for the answer to be .09 but I get 9.00000000000001E-02 I have played with it a bit. If I make the equation a = 1.9 - 1 ,I get 0.9 and if I make it a = 1.099 - 1 , I get 0.099. Does anyone know what the cause of this is Thank ...Show All

• ArKhas Display a drawing on an MS Access Form

  Hi there i would like to display a drawing (test.dwg) on my form in a vb code. The form has an Bound Object Frame - OLE1 area. So when the i press an button it should display the diagram itself (not the link) inside the Bound Object Frame and be able to zoom in and out and edit. Thank you Here's the latest from the support engineer: As I mentioned, first of all, we have to confirm that the 3 rd party Active ...Show All

• Darrin Dyson Microsoft Access Runtime/Developer (XP) - compatibility issue with XP SP2?

  I have software that I packaged with Microsoft XP Developer SP1 edition which  does not  function on Windows XP SP2 systems but ran fine on all prior operating systems. The wording I am getting when I launch the installer is: "Visual Basic 6.0 Setup Toolkit" "The Application you are installing requires updated system components. To continue, install the Office System Pack. For assistance, contact your applicaton provider" Is there ...Show All

• Hoopla Please Help with Access 2003 and ActiveX Controls

  Hello everyone, I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out. I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0". I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control ...Show All

• skyshock21 Path of MDB

  This is my first post, and I need help with the following: Is there a way to get the path of where a MDB file is running everytime I open the database (If a user opens up a copy of the database from a different path, the database should not open up.) Thanis in advance for your help, Carlos This returns more than the path: currentdb.name I hope it helps Thanks!!! ...Show All

• Dave M. VBA tapi caller ID

  hi wizards, I search for days now, but cannot find any working sample code to do the following I just want to get the telephonnumber of an incoming call (initiate outgoing calls with tapiRequestMakeCall works with a telephone connected to the USB port). I found a lot of code for C or VB, but not a single working one for VBA. Can anyone point my nose to a working sample I just want to recognize the incoming call in my access applica ...Show All

• faizy What is the difference between SET and Assigning a value to a variable?

  Hi, Can anybody advise what the difference between SET and assigning a value to a variable Example: Sub NewWorksheet() Dim ws As Worksheet Set ws = Worksheets.Add ws.Name = "New sheet" End Sub =================== Set ws=Worksheets.Add vs. ws.Name="New Sheet" Why not just write ---> ws=Worksheets.Add ----- for the former Regards, Patrick Derek, That he ...Show All

• sburton Read data from excel through VB.NET

  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 MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Youcef enabling controls at runtime

  i have a userform with two listboxes, and six optionbuttions. the options buttons are split into 3 pairs of two. at the outset only the first pair of option buttons is enabled. the following code tests to see if more than one selection is made in a listbox, and if it is, then enables a relevant pair of option buttons. Private Sub Listbox1_change() 'check to see if there is a multiple selection Dim i As Integer Dim Acount As Integer Acou ...Show All

• beastrabbit What about Sourcesafe now too?

  So Empower and Certified partners will not get Team System.  That also screws us up for Sourcesafe doesn't it I quote from the MSDN site ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/VSTmSysvsVSS.asp ):   The desktop-based nature of Visual SourceSafe 2005 lends itself well to scenarios where team members may need occasional remote access to files. However, it is not intended for day-to-day usage by a ...Show All

• Corinne C list object

  Sir I have a list object in excel. i want to make the alternate rows of the list object to display different background color pls let me know Hopefully someone will prove me wrong but I don't think it's possible. Per our support engineer: Thanks for using Microsoft ISV Community Forum, according to your problem, I think you can take the following steps to achieve what you want: ...Show All