Answer Questions

• tuhack Scroll Events of mouse

  Hi,  i am imtiyaz thange. i am working on excel vba, i have used the combo control of vb on excel application, when the combo conrol is activated during the runtime and when i scroll the mouse the combo control also scrolls, i want that only the combo contents only to be scrolled and not the page to be scrolled when the control is activated Here's the response from one of our support engineers: I repro t ...Show All

• anacomc Memory issue with variable declaration in a macro to write from excel to text file

  I have a macro to write data from excel spreadsheet to text file. The macro is actually creating a DMS script with the insert statement. Everything works fine till the cell(i, 104). Beyond that I am getting 'Compile Error- Too many local, non static variables. ' When I look up in the help it says that 'The sum of the memory requirements for this procedure's local, nonstatic variables and compiler-generated temporary variables exceeds 32K'. Ho ...Show All

• Mulhall Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi Vlado, here's the latest from the support engineer... As I mentioned, when Excel is in "Edit Mode", macro will not run. So "enters edit mode, calculates the result, displays the value and moves cursor to the end of value" is trying conflicting this design.   If you just want to display the value and formula, we can use ...Show All

• PatPhilippot How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Just thought I'd share that I ended up using OR instead of AND. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii < 65 OR KeyAscii > 90 Then 'invalid input, set to zero (ignore) KeyAscii = 0 End If End Sub Hello ...Show All

• Toby77006 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

• chadiswar additem issue with populating a combobox

  Hello, I have been working at this for days and am no better off. I could really use some help. I need to populate a combobox with data from a column in an SQL table. I have put together the code below but am having an error at this line: invBegNum.additem rs.Fields.Item("RMDNUMWK").Value Error message: "Object doesn't support this property or method" I'm really a newb but am trying hard to get this.  When I write this line of code to popul ...Show All

• Russ1L Table Caption Property

  I am creating tables dynamically. I started out only creating them using the Field name and data type. However to facilitate my form building I thought it best to add a caption. Well, I can not find out how to alter, modify, add, etc... the caption property of a table. I am using Access 2002 VBA Thank you Per the support engineer: What do you mean by table caption Can you change a table caption in Access menu If it is no ...Show All

• lukics has anyone done the tests at all?!

  hi, just wondering has anyone done microsoft ISV software tests   i'm a one-person ISV and i'm interested to hear from others who have been through the testing process.  i've been on the ISV empower program for the last 18 months and i'll be taking my tests shortly.  i intend to apply under the "platform" tests, doing the windows client test, and web services + .net framework.  i read the instructions from the testi ...Show All

• Taffy III pl help ,how to give warnings or Error Messages in Access Reports

  dear ISV's i am trying to print label in the report using vba. with some conditions for printing. for example: if one of the input value is above the stored value in the table(database) i want a warning message or Error message or exit: which i want something look like this " Plz enter the correct value" and should exit . But now my current situation is this , when i enter the value above the stored value in tabl ...Show All

• KitTexas VBA Excel Chart DateFormat Language Settings Locale

  I have designed a little application that produces graphs in Excel and then exports them as pictures to Powerpoint Presentations. These powerpoints presentations are generated in five different languages. The problem is now that I want the axis with the dates formatted according to the different languages, i.e. that the (long) month's name is displayed correctly. New in Office XP you have the possibilty to format the dates of an axis ...Show All

• John Saunders What does VMF Team in Microsoft mean???

  Hi, Not sure if this is in the right section but i was just wondering if anyone can tell me what does VMF stand for with regards Microsoft It came up when i was looking at jobs.ie and it said clearical activites of the VMF team in mircosoft..... I would be truely greatful if you could tell me what VMF means.... Thanks Not that this is terribly helpful, but I believe that VMF refers to Vendor Master File and seems to have s ...Show All

• Mat Gardam custom toolbar error

  I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I got an error message on a Mac Excel: Run-time error '-2147483640(-7FFFFFF8)': Method 'FaceId' of object 'CommandBarButton' failed If I comment out the        .FaceId = 642 Then the error message becomes Method 'OnAction' of object 'CommandBarButton' failed The original code in VBA look like this: ..............    Private Sub Cr ...Show All

• Robert Varga Problems with DAO and SQL Server

  I am trying to return a DAO recordset from SQL Server so that I can use CopyFromRecordSet to populate some data in Excel 97. The below creates the recordset but the CopyFromRecordSet fails with : error -2147467259 (80004005) Operation is not supported for this type of object If I change to another database (SpecData) and change the strSQL to select a table without the owner prefix the code works. The permissions on the two databases are id ...Show All

• Usai VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• mickhardy Avalon Adaptation

  Scenario Lets say that Avalon is released for XP (and in Longhorn) on time, Holiday season 2006, and that it is accepted as “wonderful” like we all know it will be. Question: How rapidly will it make its way onto the corporate desktop What percentage of corporate desktop machine will have Avalon install one year later, two years Are there any moderately reliable figure that we can use in our sales projections Anything will be helpful Tha ...Show All