Answer Questions

• Zoran Stipanicev Access 2003 VB code does not execute in form

  In my very simple Access 2003 db, none of the VB code will execute, whether automatically generated or written by me. No errors are displayed, it is just that nothing happens. The problem kind of comes and goes - if I wipe out all code and rebuild the form, it will work for a little while. Has anyone seen this Thanks, Mike These forums are for VB.NET questions. It sounds as though you are tr ...Show All

• Amrish Deep Ravidas Extract text within several tables in word document

  Hello everyone, I have several word documents where there is some text inside some tables that I want to extract. The formatting of this text is (or at least, should be) pretty unique where no other text within this word document has a table around it like it. The text I want to extract looks something like this: Rack 4, Breaker 3 The script should basically scan through the whole word document looking for all instances o ...Show All

• Fer Mayorga Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• Pardasani Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Boots Another piece of code Kind regards FiftyFive Is this ...Show All

• Richard Day Linking Outlook to Excel

  I would like to have a button in Excel than when clicked sends an email through Outlook that uses the data in the Excel spreadsheet. I have read the Installing and Using the Office 2003 Primary Interop Assemblies. I have now my Office 2003 updated as needed but still I am far from being able to use it. Can someone please point me to a solution or to some examples Thanks, Antonio Ant ...Show All

• KWH Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• John Fabian Problem with RecordCount by CrossTab

  Hi, i'm getting a problem with a CrossTab in Access 97. When I open the query by clicking twice it returns 4 records. Thats OK and correct. The problem is when I open the query with VBA code, it returns 1 record (property recordCont = 1) I'm opening the query this way: Dim DB As Database Dim MyQuery As Recordset Set DB = CurrentDb Set MyQuery = DB.OpenRecordset("CrossTAB_Compras") Anyone can help Thanks, Felipe ...Show All

• Franck EMSALLEM Programmatically inserted inline image is dithered in Word 2003

  I am inserting a .tif as an inline image into a Word document. In Word 2003 the image is dithered. Word 2000 Word 2003 (difference in size is due to monitor resolution in Virtual PC) This is how the image is diplayed and printed. Code: 'Logo Dimensions (in inches) Global Const LOGO_HEIGHT As Single = 2 Global Const LOGO_WIDTH As Single = 2 '************************************************************************************** ...Show All

• k2msdn 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 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: 1. Select the whole list object. 2. From the menu, choose ...Show All

• evilc Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s)   Yes but Application.Ready is not an event !!! and tranfsorming a state reading in an event by a timer is ugly and buggen!!!! Per the engineer:   Depending on the version of Excel, you can check the "Application.Ready" property to see if Excel will accept automation commands.  Th ...Show All

• 3js SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 ...Show All

• Kevin Downs 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

• David Eccleston - DX MVP How to read directory information into a combobox.

  Hi, I have a requirement to list all subdirectories under a specified directory in a combobox. - Srini. Hello Srini A couple of questions first: 1) What application are you using 2) What version of that application are you using 3) What platform are you using, Windows, or Mac Have you checked the FileSystem Object You could do something like what you are asking using the FileSystem Object model. Hope th ...Show All

• Dami# 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!   Hi, I just wanted to clarify some information on my original post. This info is direct from the product team. We are absolutely supporting VBA in O12. " We realize that our customers have an enormous investment in VBA solutions. VBA will contin ...Show All

• JJ-Blackbay Can this be done via an array formula?

  Hello Guys and Gals OK if you have not seen V for Vendetta, disregard this post. No I'm just kidding. OK in the movie the character V rambles on some 140 words that either begins with a "V", has a "V". or ends with a "V". Don't ask just go see the movie. Now I know that you can find the positions of the Vs by using the FIND and SEARCH functions. My question is how do I write the set of FIND and/or SEARCH functions a ...Show All