Answer Questions

• Valentin Rozescu Excel Keyword search

  Hey folks I hope someone can help me. I am using excel 2003 and have written a VBA code to search about 10,000 hidden lines and unhide them when they come acorss a keyword. What I can't figure out is how to get it to run through the database once and stop. Anybody have any ideas. Thanks Hi Just to expand a bit on Derek's explanation.... If you like working with rows and columns, and you know ...Show All

• rokana3 Getting Excel Formulas to work in VBA

  I have formulas that need to be copied and pasted to the next row down from the original. The problem I ran into was when a formula that refrences some data on a hidden sheet tried to run it will bring up a dialog box wanting to know what file to use to Update the values. I need this formula to work without asking for updates. Here is the formula and the values it wants: Current Excel Formula = IF(M12 > 0, IF(M12 > 7630, ('Conductivity ...Show All

• athadu never heard back

  I signed up... never heard back. I do widows forms in C# in Dallas. .V Hello, Please send your name and email address to budsup@microsoft.com  and we will get you connected with your buddy. Thanks! Michelle (ISV Buddy Team) Hello .V, Please send your name and email address to budsup@microsoft.com  and we will get you connected with your buddy. Thanks! Michelle ( ...Show All

• fred79g Error VB6 when I run application in w2k3 Domain Controller

  HI, I have an application implement in VB6 and when I run in W2k3 Domain Controller give error 713 time execution. please, help me. Any suggestions are very much appreciated. I had the same error on both Server 2003 & XP pro using VB5, when trying to display a Data Bound Grid in the application. The only difference was my runtime error was '9'. CLSID: {00000010-0000-0010-8000-00AA006D2EA4} Found ...Show All

• dmcnulty XSL applied with VBA

  Hello, everybody, Derek, Brenda Acctually I'm doing a test based in Instructional program evaluation faced with library resources. The goal of these evaluationsis to assess the adequacy of library resources to the needs of courses offered within a program and to determine the ability of the library to support teaching and related research. This methodology of collection evaluation based on the analysis of the content of individua ...Show All

• Mimzo help on list box (Access)

  Hi can anybody help me with my list box. I created a form in design mode in access I added a list which gives me a set of data I addes a second list which has to give me a set of data depending on the result of the first list. But there seems something wrong with the link thx I resolved the problem, and seems to work ok. I created a query, with the selection = value of the ...Show All

• anonymizer cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. I have the same problem. i have'nt had yet the solution!! Okay, I found the answer! Download the fix from Kelly's site and save it to your desktop. ...Show All

• Engage Problem sorting dates!

  Hi, apologies if this is the wrong thread, I have Access 2000 and am running a queyr that conaints the following field: Date, Time, Site, Data Date is in the format dd/mm/yyyy, time is hourly from 00:00-23:00, Sites are Various fields and Data is the values for each hour. The day format I work in runs from 06:00-05:00 the foillowing day, thereby for running over two days. This wouldn't be a problem if it wasn't for the site field. ...Show All

• SHL Some Windows XP SP2 problem

  Hi, Not sure if this the correct place to post this, I've had service pack 2 installed on my Windows XP. Sometimes when I close a window or application, I either can't click on anything or type anything for at least two seconds, its really annoying. Have you guys ever encountered this problem before Please help me, thanks. Hi, I haven't run into this issue myself. With this troubleshooting issue with so ...Show All

• DavidYA 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!!!! Hi Denis, Here's the engineer's response to your question: Excel does not provide an interface for outside components to detect "Edit mode" (e.g. when a cell i ...Show All

• michael_miguel Client to SSAS

  I would like to know How I can use OWC11 with ASP.NET 2.0 because the past version we only put the control en ASP.NET page and working, How I can do that with a new version Thanks for your help Flavio are you know how I can use OWC11 with ASP.NET 2.0 because when I try select a control this are disable it's possible use similar last version of Visual Studio 2003 Hi Flavio, Here's some information from our support engi ...Show All

• Ajit Halder Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD OK, that worked. Thank you. I really ...Show All

• Fahad1 Extract code from .dot

  For some reason, (really not sure why, but it happens every now and then on my company's PC) my normal.dot file containing a few years' worth of customisations and home-grown macros was reset to the default a few days ago. My backup normal.dot has the toolbar customisations and lists the macros in the Tools>Macro>Macros window, but they do not run. ("Could not load Macro storage" error.) I can see snippets of the macros when I lo ...Show All

• OneBuckFilms Defining objects within a cell range

  Hey,     I've been working on writing a code where the user inputs different names into a worksheet, then the code selects these files and defines it: Sheets("Variable Output Order"). Select FieldStr1 = [A2:A21]   Then, I use that defined object to use in a recordset: Set rs1 = db.OpenRecordset(" SELECT " & FieldStr1 _         & " FROM R00" & TestNumber & " ...Show All

• Michael Harmsen PPT slide navigation using global variables

  On Slide 1 of a PPT presentation, I'd like to set a global variable (let's call it "mymode" ) by clicking one of several command buttons. For example, if you click one button, the variable will be "a", if you click another, it'll be "b"... Later on in the presentation, using the mymode value set on Slide 1, I want the navigation to fork, going to one slide if the variable is set one way, but another slide if ...Show All