Answer Questions

• system.windows.forms.form Independant Awards / Approvals

  I work for an ISV and Microsoft Certified Partner, specialising in ASP to ASP.NET migration I am curious to know what (if any) channels there are for getting independant evaluation of your software/solutions I was thinking along the lines of an award or 'seal of approval' that could be conveyed to customers. We have customer testimonials, but if there are any recgonised awards or commitees that would be useful too. Thanks, P ...Show All

• NGTR Getting New Textbox value without using Afterupdate

  Hi. I'm fairly new with programming and I hope someone can help me with this. I trying to filter a list based on the value entered on a textbox but the only way I know of getting the new textbox value is wait for the AfterUpdate event. This works fine but I need to activate the filtering routine as the user types in the new value. Im thinking of using keypres, can anyone show me a way doing this. Any help would be appreciated. Thanks ...Show All

• KamiNoChikara Referring to a range on another worksheet from within the worksheet module

  I cannot seem to get the range with cells to work from a worksheet module for a range on another worksheet. The following code gives me an "application-defined or object-defined error" on the If statement line. With Worksheets("ConceptData") If Range("NumTechLines") <> .Range(.Cells(iRowNumber, 10)) Then MsgBox .Range(.Cells(iRowNumber, 10)) End With When I replace the cells method with an absolute address "J6", I do not get ...Show All

• Mawla Excel Data Read

  Hey people. I still can not find anything that directly explains yet how I can get a value in column D in an Excel File that I have linked, to a VB string, based on a selection of a value in column A. I am dealing with metal gauges and cost for metal I have a listbox pulling data through databinder from column A in my excel sheet. Now I need to assign the value cost of metal for that gauge to a variable. As easy as this sounds to me explaining i ...Show All

• SchallerJe Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve We are having the same problems to but our configuratio ...Show All

• darinn Calling procedure upon deactivate

  I am using the following code which gives me a run time error 1004 "Select Method of Range class failed" when the yellow line is executed from the worksheet_deactivate procedure. However, the code runs fine when executed directly from the Save button. This code is located in the Item Entry worksheet module. Can someone explain why and how to get this code to execute. I am guessing it has to do with the worksheet being deactivated. However, by de ...Show All

• Kaumil overflow error 6

  hi i've got a problem with my vba code.. when certain data is input it creates an overflow error for no apparent reason. In this code, I have to calculate the number of days spent alive in each year, and the input includes the date of birth, the date on which the period of investigation starts, and the date on which the period of investigation closes or death occurs. The individualexposed() program deals with one life at a time: Sub Individua ...Show All

• mzirino Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi, This time the application is failed on a call to ...Show All

• Dan.G Access 97 does not close after running code

  I have a number of access databases that do not close after I have run code attached to buttons on forms. All the databases read text files and open recordsets to write the data into my tables. I have ensured that I close each recordset and database object, and I set them to equal to nothing at the end of the code. I have tried using the repair option on the database, but I still get the problem. The only way I can close the Access window is ...Show All

• Mike asp access vba issues

  I am creating a series of access databases that connect to each other via buttons on a form -- ie... click a button and another db opens with it's main form. I created this system in MSAccess 2003 in 2000 format. On my development machine which is running office 2003, everything works perfectly, but as soon as I move the system to another machine running office 2000 (which is what most of my end users have) the program does not work. I am using ...Show All

• JoyceM Migrate Access Forms with VBA to VB.NET

  I have a lot of Access Forms with VBA code and now I need a tool or method to migrate them to VB.NET Per the support engineer: Base on my understanding, our partner wants to migrate Access forms to .NET. Be honest, I don’t think there’s a directly way or an import wizard to fulfill this task. However, this question depends on the real scenarios. For example, if we only want to leverage Access as the database and left all the forms to ...Show All

• The real Ethan Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Hi, thanks for the information, worked fine. However i dont think you h ...Show All

• harveyDBA Extracting Symbols from Word

  I'm trying to extract characters from a Word document which includes some Symbols (such as alpha, beta etc) When these characters are encountered (using the document's Characters collection) they all report their text to be "(". Any ideas as to how I can get the correct character values Current code is simply: Dim doc As Document Dim char As Range Set doc = Application.ActiveDocument For Each char I ...Show All

• Bernardm1 Does the VBA save word as XML???

  Hello! I'm really needing to know if there's any VBA code able to save a Word document as an XML doc. Any sample is appreciate. thanx Marcos Hercules dos Santos Got it working Marcos, check out my blog. http://dsmyth.blogspot.com/ Hi Derek, I' got it. Very good, man. Actually I'm working on,(at least trying to) extracting words from ms-word documents, surely this only can be done using XML and a progr ...Show All

• ukgy Partnering with Microsoft?

  I am a partner with Microsoft and a Small Business Specialist.  Our company provides technology solutions for Small Business.  Since we own our hardware that is provided, in the solution, does Microsoft provide a Partner Program for discount Software to be used I apologize, but I'm not clear on what it is you need. Are you talking about software licenses for MS product(s) that you integrate into your solutions If you ...Show All