Answer Questions

• Cheryl Marland Sql Server 2005 Resource Kit

  Hi all,   how do I view the slides that accompany the webcasts on the DVD. I can hear the audio stream fine but just get 'page not found errors' for the graphics. I just found out that all of the Webcasts that were included on the Resource Kit have been archived and are available on http://msdn.microsoft.com/sql/webcasts/default.aspx The SQL team has also added new Webcasts to this location sin ...Show All

• dsani How to handle CLOB Data in VBA for Excel?

  Please, somebody, I need ASAP a solution to handle CLOB Data in VBA. I need to pick a String variable and insert and update it in a CLOB field. I need also, to store whatever is in the CLOB field in a string Variable. Does anyone know how to do it Thanks! Hello, I tried what was on that document. When the recordset is open and runs the SQL statement, it gives me an error: Run-time error '-214767259 (8 ...Show All

• Toni Leitao - MS Problems compiling an MDB to an MDE

  Hi all, I have a front end/back end split 2002-2003 file format mde which I have been using for 3 years, and tweeking every now and again. All of a sudden I can not compile the development mdb file into an mde file, and keep getting the same error message saying that I "probably have too many forms". The error msg mentions problems associated with 500+ forms, but I have nowhere near that many. (Linked Tables:33, Tables:2, Delete ...Show All

• Frent Windows Vista beta

  I am hoping this is the right place to post this request... I own my own computer repair business and I have very many clients. Some of them happen to be extremely computer-illiterate, so I write simple programs to change settings that may be harder to find. for example, instead or clicking start, clicking run, typing in msconfig, clicking startup programs, and unchecking and checking programs, I created a list of very commonly used programs ...Show All

• ScottK11203 paste values from multiple sheets to another sheet

  Good day, I am brand new to VBA for Excel.I have a workbook with a bunch of different sheets. I have checkbox buttons on one page that will unhide the desired sheets. What I'm having trouble with is getting the code to work that will allow me to: 1) Search specific sheets (most of them - all but 4) for the last row in columns L through O. 2) paste the values in that range to another sheet. 3) on the destination sheet I'd like the ...Show All

• ACM Borland Out, where to go from here?

  I've found the best way to get a straight answer, or some honest advice is to simply ask another developer. I'm a small ISV designing software on multiple platforms. In the past years, I've been studiously avoiding Microsoft development tools for a variety of reasons - mostly cost and preference. I used Borland for a decade, and it performed well most of the time. Now that Borland is no longer in the developer business, I have to have an eye for ...Show All

• Kim Hansen Access Developer Extensions

  Will there be an Access Developer Extension in VSTO 2005 VSTO 2005, which ships in the next month, will not have any support for Access. We're looking to support Access in VSTO v3, which is the next release after this one. If you have any specific requirements that you'd like us to address, please forward them so that we can add them to our planning for v3. ...Show All

• loganX Can I unProtect a document?

  My VB code protects a Word object without setting a password, like this: Call Document.Protect(2)  Is it possible to Unprotect this document If so, how  (Did I post this in the right forum ). Thanks in advance for help. -Jeff Use the uprotect method of the document If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument. Unprotect Password:=strPassword End If ...Show All

• z1000 vba access updating a record

  Hi all Currently i have a form that using the following press button event it displays details from my DB: Private Sub cmd3_Click() Me.RecordSource = "qCountUserDir3" Me.Requery DoEvents mylbl.Caption = "Selected: " & cmd3.Caption lblSelected.Caption = "Selected: " & cmd3.Caption End Sub This works well the only thing though is that i want to be able to update 1 field when i double click o ...Show All

• Govert van Drimmelen Visual Studio vs SharePoint/Front Page

  What is the 'connection' between these two seemingly unrelated development tools I have been reading some evangelical blogs on the sharepoint v3 site, and it seems as though Sharepoint v3 will offer a lot of "infrastructure" (security, web parts, asp.net) for business-oriented / collaboration / scheduling web sites that may require a lot more effort using Visual studio. From the look of things, it's apparent to me that Microsoft is be ...Show All

• newbob Installing SharePoint 2007

  Hi All, Does anyone knows how to install SharePoint 2007 beta.I have downloaded its binaries got in a ISO image, made that into a CD.After installing its pre-installs when i tried to install for error like this. "The configuration file is not valid.Try again setup with out config file or rectify the config file" Have anyone faced problem like this or any one has any idea Thanks in advance. Hi Amarendra, Your best ...Show All

• Wenyang Needing extract elements XML to a listcolumn in a Get method(HttpRequest)

  And going on .. Does anyone know how to extract the elements in na XML obtained through a Get method I've been trying to use VBA Excel to connect Web Services. What have I got 'till then It brings me just an XML in a cell. I tried many ways to put this datas in a listcolumns, no success. Any help is appreciate. See my code, Dim oHttp As New WinHttpRequest Dim wks As Worksheet Dim amzURI As String Di ...Show All

• TedToal Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified ...Show All

• NorCis suppress content overwrite message in TextToColumns?

  My big problem is, that I use the TextToColumns to populate several columns. Before calling it, I clear the target area with range.clearcontents. It works 99% of the cases, but in some cases it asks 'Do you want to replace the contents of the destiantion cells ', though nothing is there at all. I've found out that in some cases if I change the formatting of the target range it is ok. Sometimes not. This messages is not acceptable, as I run the t ...Show All

• solmyr72 Business Scorecard Manager 2005 Webpart problem

  Problem with the Business Scorecard Manager 2005(Maestro) on an Analysis Services cube of SQL Server 2005 Apr CTP While using the Office Report View Webpart (Pivot Table) in WSS, cannot see the Toolbar with the Save option. So if i create a Pivot table with the Dimensions & measures, click another link and come back to this page, the Pivot table gets reset without any fields Any solution I think we are diverting from the query. I ha ...Show All