Answer Questions

• lexxmt Generate XML from Excel Data

  Hi, I would like to be able to create XML output from data entered on an excel spreedsheet based on my own xsd.  I am using Office 2k.  I have tried using the XML data mapper in Office 2003 however it does not support Lists of Lists in an XML file which I have defined in my schema.  I would appriciate it if someone could steer me in the right as to the best way to go about this or point me in the right direction where I can get mo ...Show All

• spandey1982 a big thank you!

  Hi All, I just wanted to express my thanks to Derek and all of you who have stepped in to help your fellow coders! It takes some time on my end to escalate these questions and I'm so glad that many of you are getting answers to your questions more quickly with the help of other community members. - brenda (ISV Buddy Team) I love to code, so i'm glad i can be of service to anyone who needs help. (^_^ )-b Every once and a while, b ...Show All

• eshu DataGridView and ComboBox Column Problem

  Hiii all I have a problem in DataGridView, and i need help. I use DataGridView has column its "column type property" is ComboBox ok..., i want to add items into every cell of type comboBox, i want to add items in a cell of type comboBox different from items in another cell. this line adds items in all cells of type ComboBox Column1.Items.Add( "value" ) please help me Thnx Hi, I'm just wondering w ...Show All

• David Vestal Serial Port Communication Using MS Access VBA

  Need help using MSComm.ocx in MS Access 2000. I have successfully registered the file and have gotten passed licensing issue. However, I am not sure how to use the control to read the data. My code reads: mscomm1.comport = 2 mscomm1.settings = "9600,N,8,1" mscomm1.portopen = true mscomm1.inputlen = 0 buffer = buffer & mscomm1.input (this line of code returns nothing) Any help is greatly appreciated. ...Show All

• Thicks18 Help with: hiding main menu in Visio 2002 with VBA

  I don't know a thing about VBA but see myself in need to try to make this work. My goal here is to hide the menu bar when this particular document (let's call it "test.vsd") is opened in visio. After looking at the references and help files I put this together: Sub HideMenuBar() Dim fileName As String Dim uiObj As Visio.UIObject Dim menuSets As Visio.menuSets Dim OneMenuSet As Visio.menuSet ' get all built in menus into ui o ...Show All

• Kausar Parveen Multithreading, Callback & VBA in PowerPoint 2003

  Hi, I'm currently trying to get to work a VBA application which uses an external DLL (which I program parallely). The DLL starts a separate worker thread which calls a previously registered VBA callback function. This works perfectly (e.g. I can do a MsgBox "I was called with argument " + str(arg)) but if I try to change a slide in my slide show, PowerPoint says that "Hyperlink ^0" doesn't exist and crashes. At the end of ...Show All

• kcongdon ActiveDocument.FollowHyperlink acts funny

  well, not funny as in ha, ha. please let me know if there is a better forum to access for my situation. i am using a macro to download word document files from urls. the following call is within a loop to access all urls in the specified array: ActiveDocument.FollowHyperlink Address:=sURL__$(i), _             NewWindow:=True, AddHistory:=False most of the time the word file is downloaded and ...Show All

• scate Using a Macro (VBA) to select a variable number of rows

  I have an Excel spreadsheet that I need to copy a variable number of rows from 1 worksheet to another within the same spreadsheet (workbook). I have a variable (NRRows) that contains the number of rows that I want to copy, ie: from row 1 torow "NRRows". I need to be able to select the entire set of rows at one time, copy them all at once and then paste them on another tab in the same spreadsheet. How can I do this or for that matt ...Show All

• Li Wang 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

• fristi reportbuilder

  Hi all, I have seen forms in databases where users select from unbound fields and click a button that would give them a report based on their selections. Here's is the code but it give me an error "object required" Private Sub cmdPreview_Click() On Error GoTo Err_cmdPreview_Click Dim strSQL As String Dim strnewQuery As String strSQL = strSQL & "[" & ctl.Name & "] " & " like " ...Show All

• aanaruna Problems with Project Server

  Hi, I’m having a problem with my Project Server. Whenever I assign a task to someone and some time later I remove the assignment, the task is no longer asigned to anyone and I cannot delete it. It works like if it’s still assigned to someone. Because of that I have a couple of tasks that are marked for deletion, but i’m not being able to. Does any knows how can I solve this Thanks, Hi Ricardo, I can ask our support ...Show All

• Loren Shumway screen resolution

  G'day I am new to this forum and hope i have the correct one ....What I want to do is to change /or resize a screen resolution for a access db depending on what a user has their screen resolution set on there monitor.. can this be done in VBA / access db in a simple way ..... ( I use 1024x768 all the time)some users use 800 x600 some 1024x768, so some forms do not fit the screen...I am not an expert coder so some help may be required Chee ...Show All

• Anonymous0011 Our Application meets Client, but no other componant.. HELP

  We are looking to attain ISV status, but the application that we are looking to get approved will only pass the Client test. The Program does not have any other componantsand so will not allows us to attain ISV status unless we modifiy the program to include on of the additional componants. e.g. Web Service/Office/SQL/Managedcode. The program is written in VB6 does a differant set of rules apply Cheers Charli ...Show All

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

• jimmybon Application in the Task Bar

  Does any one explain why the application is not shown in the task bar if the form is shown modally. Is there a better way of handling the code without showing the form modally Hi Shasur, What program/versions are you using Can you provide more details or repro steps on this issue thanks, -brenda (ISV Buddy Team) Hi Shasur, The engineer is having some trouble figuring out exactly what you need help on. Please note that VB 6.0 is a ...Show All