Answer Questions

• Amitkumar Updating Hyperlink Addresses in VBA (MS Access)

  Hi, I am making a database which uses labels to link to external files. I have the path of the file defined in a table and there is a test box on the form that displays it also. On the form load event the hyperlink address is set to whatever is in that text box: Me .txtgroundFloorPlan100.Visible = True Me .txtgroundFloorPlan100.SetFocus groundFloorPlan100 = Me .txtgroundFloorPlan100.Text Me .cmdRefresh.SetFocus Me .txtgroundFloorP ...Show All

• S. Unal HKCR Permission changes at top level

  Hi, My self developed / built COM+ and even regular MS COM DLL's were giving ASP Server.CreateObject errors for the IUSR_machinename (800401f3). I had Anon logon in IE. Worked on other machines but on mine gave the above error - (Win2003 SP1 by the way - that I'm using). I google'ed for hours, listened to Webcasts (and learnt some cool info on IIS Auth.) but could not get it to work. VBS was fine; as I am Admin on my box. CreateObje ...Show All

• sharon n. Word 2002 VBA weird Find problem

  Below is part of a program that takes in a list of specific words and if it finds them in a document is supposed to set the background to grey: For intLoop = 0 To UBound(arrSpecials)     With ActiveDocument.Range.Find             .ClearFormatting             .Text = arrSpecials(intLoop)      & ...Show All

• BradA-MSFT (0x800A03EC): Paste method of Worksheet class failed

  I just recieved this error message when i try to copy and paste some text using the right click method in excel. Any ideas why (0x800A03EC): Paste method of Worksheet class failed Hi Mike, The engineer needs additional information before he can investigate your issue: As there is too little error information of the issue, we can’t find useful information to resolve the issue. Would you please ask our ISV ...Show All

• Natacuin Live Communications Server 2005 SP1 - no login accepted from MSN 5.1

  I have installed Live Communication Server 2005 Standard Edition and the SP1 on my win2003standard domain controller and i cannot login from messenger 5.1 as i used to in my old server (win 2003standard + live coomunication server 2005 se sp1). I have check the ports in firewall and with the help of network scanner seems ok . Port 5060/TCP is open. The authentication fails! The message i get is Signing in to SIP Communications Service f ...Show All

• Prasad Naik ISV Competency Partners left behind for Office 12 Beta

  As I was renewing our partnership with Microsoft, I took a look at the "Benefits" provided to various Microsoft Competencies.  To my surprise, I found that only the Information Worker Competency will be privileged enough to recieve the Office 12 Beta.  Frankly I am surprised, most ISV's develop solutions to leverage Microsoft's products.  Product development of line of business applications certainly come ...Show All

• James Y Optimise VBA for Multi-Processors

  How do I tell my VBA it is allowed to do several things at once I am moving my project to the server, which has 4 CPUs. I know that sections of my code have no interaction with each other, and do not work with the same cell ranges. Imagine my code is as such: Main Routine Call Task 1 Call Task 2 Call Task 3 End This is programmed in linear code, so I know that it won't start Task 2 until it has finished Task 1. I need some way of te ...Show All

• SharkBait How print picture

  Hello, I have small question about printing graphic file. How send to printer picture ( graphic file) under VBA Per our support engineer: Hi, you need a container in office to contain that picture, then print it out. For example, you can insert that picture into a word file, then print that word doc. Here is a sample code for you. === Selection.InlineShapes.AddPicture FileName: ...Show All

• Anoop.k Date Problem

  I need to gather yester days date to us in a few place in my script.   I thought it would be easy but the way I previously planned this out I would always have a problem with the last day of the month.   Can some help me out with an easily way to do this.   Below is the code I use for the current date, but how is the best way to get yesterdays date   I Need the it in the following format 12032005 Thanks! Dim varDay,varM ...Show All

• qbs29 SubForm - ActiveCell

  Hi - I am using Office 2002 SP3. I have an Access database with a form and a subform - normal, standard stuff, nothing fancy. Is it possible, in code, to find out which cell on the subform is selected by row and column number I think I have the row bit sorted but the column (field) has me beat. Dear Brenda Thanks very much - just what I was looking for. Per our support ...Show All

• http200 PPT VBA - Automatic undo

  Is there a way in vba for powerpoint to code an automatic undo. I have a form that is used to create a powerpoint. I have an exit and what i want is on the exit button click (the use the exit button to close without saving) every change done to the presention will be undown automaitcally on the exit click event. How do I do that Thank You. Per our support engineer: Base on my understanding, our b ...Show All

• Doug Haacke Close Access Form After Video playing

  Dear All, I've creat an Access Form which contain a Video Shot but I need to close this form automatically just after the end of video without need for user action. Please Help Dawy What type of Player Plugin are you using to display the video If you are using the Windows Media Player (Windows\System32\wmp.dll) then you could use the command: If WindowsMediaPlayer1.playState = wmppsMedia ...Show All

• ColinGQ LCS complience with IMS / SIP standards ?

  1. It seems, to register to Live Communication server from a SIP client, NTLS or Kerbaros authentication is a must. How to register from a SIP client which doesn't support NTLS or Kerbaros Is there any configuration required on LCS to acheive the same 2. If LCS doesn't support HTTP Digest Authentication then its not interoperable with SIP standard rfc 3261 and IMS Please correct me if I am wrong Please revert back !!! Best R ...Show All

• artzoop Determine if a file is already open by another user

  I want to check to see if a file is already open Normally I would open the file and if it was read only I would close then open again until I was able to write the file Hi, john Here's how I check if the file is already opened by someone:     Dim filenum As Integer     On Error Resume Next   ' Turn error checking off.     filenum = FreeFile()  ...Show All

• trknssr How do I do to work with two XML files in VBA

  Hi, I'm doing a simple use of XML and trying to display the results in MS Excel. in the moment I have one XSLT that compares datas between two XML files and I'd like to know how to do to view the final datas from this comparation, in Ms-EXCEL, to be worked by other sheets. By now I don't have any idea how to do it (work with 2 xmls + 1 xslt), I already  do transform using an XML and a XSL file and it works nice, but now Coul ...Show All