Answer Questions

• XImplosionX unable to register comsvcs.dll

  Hello, I have a VB application that has been evolving for several years. I have installed and used it on work stations running win95,98,NT,2000 and XP. The developement computer has evolved from a win95 to win2000 machine. Recently, I have begun to experience "an error occured while registering the file ... comsvcs.dll" when installing it on a win98 work station. winxp installs fine. I have always installed dcom98 and mdac prior to the ...Show All

• Jay T103328 VBA SDK with VB.NET(2005)

  I'm trying to build a Project in VB.Net 2005 Beta2 which includes the VBA Editor from the VBA SDK. But i didn't find any sample Code in the SDK, and so i don't know how to do this. Could anybody help me e.g. with a small sample ciao stephan Per one of our support engineers: Please let us know the details of the application are you trying to develop so that we can suggest appropriate technologies for the same ...Show All

• Dick Schroth Change Data Source in Word Document

  I have a lot of word documents used for mail merge. Actually this documents have configured a data source that is not valid anymore. I search for a VBA procedure that update the data source information in all the documents. Please help me !!!! I'm not able to find a solution. In order to provide some suggestions, the engineer needs some additional information. I would need some clarification in the prob ...Show All

• nkat2112 Copying and pasting between spreadsheets

  I have an Excel Macro which copies from a Source spreadsheet and pastes on the working copy. The Source spreadsheet is the result of a report gleaned from a non Microsoft database. Usually all works as expected. The problem comes when one of the items in the working copy does not appear in the Source copy. (If no activity occured, instead of displaying a zero, that particular item is excluded from the output. Since the procedure is copying an ...Show All

• NicoTech Emailing from an Access form.

  Hi I have been asked to create a tracking system that will automatically email team leaders of when they need to add to data are that comments or other wise. What I need to do is develop a form that allows the selection of a record and then who to send a reminder email to and a comment text box that will be added to the email. is it possible to do this I can get the form to show the records and build the form but I have no idea ho ...Show All

• k mac Using HTML Help in Microsoft Excel VBA

  Hi I am using a HTML Help File (.chm) with Microsoft Excel VBA. How can I specify the Topic ID in the HTML Help Contents File. I want the help to be context sensitive. Can i change the topic id in my function modules  and display the accurate topic when the user presses 'F1' Thanks, Shasur Per our support engineer: Here is one article about how to use HTML Help API in VB,I hope it’s helpful. How to us ...Show All

• scorpionguy Problem with integer function

  I have been trying to troubleshoot the following code, but cannot figure out what is causing "Type Mismatch" error. Sub PutData() '\ called by other subroutines         If Me.CheckTech.Value Then Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = Int(Me.TextD) Else Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = 0 End Sub When I take out the integer function a number is written as text.  ...Show All

• Brian Houston, TEXAS Accessing Tables in Access 2000 that are linked from an SQL Server using VB code

  Hello, I am not sure if I am posting to the correct forum, but here it goes: I am trying to create an Access 2000 application to pull data from a table that is linked to a SQL Server Database using VB code. However, I cannot seem to get it to work, as I keep getting type mismatches and object not defined errors. I would post my code, but I have made a complete mess of it. Would anyone be able to show me simple code to accomplish setting u ...Show All

• cdalglish Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp

  Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open) On debugging we find that in the problematic c ...Show All

• Nathalieg23 Controlling a Word Mail Merge with Excel

  I'm having trouble running a mail merge in Word using Excel.  I've followed the example in the help file, and have the Workbook opening the appropriate Word Document.  My problem, is I can't control the mail merge from code embedded in the Workbook or in the Document.  The reason I'm using Excel to run the code to open Word, is because I have three different mail merges with three different "Forms" and depending on the ...Show All

• Manoj_Raj VBA, Access, & SQL Server

  Access 2003, SQL Server 8 Hello, I'm having some problems calling a stored procedure from Access VBA. The stored proc is rather large, calls a few other procedures, and takes about two hours to execute from Query Analyzer (it's the second EXEC statement listed below). The problem I have is calling it from VBA. I've used ADO and DAO; but no matter what I use the SP terminates early (like after 3 minutes) and doesn't do what it should ...Show All

• Sayhan Disable "Unprotect Document" in Tools Menu Item

  Is it possible to disable "Unprotect Document" in Tools Menu Item in MS Word using VBA We are accessing and modifying documents in Java using JACOB. If the document is protected we are unprotecting the document and doing modifications. But if the document is protected using a password there is no way we can provide the password programatically as each document could have different passwords. So if it is possible to disable the "U ...Show All

• lvying What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• simflex Live Communications Server tab does not show up

  I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show u ...Show All

• Dah_Live 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! Hi again, You'll need to create a form with a textbox as you'll need to handle the keypress event of the textbox and thats something you can't do with an input box. You can't apply any validation with the input box until after you have the whole string input. Checking that a whole string only c ...Show All