Microsoft ISV

Page 175




  • Topics
    Replies
    Last post
  • Failure Using VxD loader
    by Thisorthat
    6 Replies
    Last post by lumpy55
      • I am using Vista Premium on a brand new Dell computer and I ran the Reliability and Performance Monitor. The following messages appeared: A device has a configuration problem that prevents it from working properly. The device, Microsoft Tun Miniport Adaptor, is reporting "tv_ConfigMgrErr19". This device will not be available untill the issue is resolved. The Plug and Play ID for t
  • Excel CheckBox - Enabled "False" but I don't want it grayed out
    by suznal
    6 Replies
    Last post by Andy Pope
      • Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality. I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.
  • ODBC import to Excel
    by sfaust
    4 Replies
    Last post by Cringing Dragon
      • I am trying to import several queries into excel based on an ODBC database. All I did was record inserting the queries with a macro and changed the path to a variable so that I could change the path of the mdb file. The reason is that we will have an mdb file per project and all mdb files will have the same tables and parameters with different values. Anyway, I have probably 30 queries to insert,
  • Counting words
    by une
    10 Replies
    Last post by une
      • Does there exist a predefined function that counts the number of words in a string
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • How can I print only items marked with Check boxes?
    by -jm
    4 Replies
    Last post by -jm
      • Hi All, I'm new to creating my own apps, but I've been coming along here fast in the past few weeks. However, I am having trouble with the following project. I would like to create a checklist of items, with many of the items being paragraphs long. It is effectively a bill of materials, and I would like to print out only the items that are checked-off upon completeing the form. (In e
  • Validation with List drop down?
    by Scott Boyd
    8 Replies
    Last post by Handyman_994
      • Hi I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg I can remember doing this before and used some VBA code but c
  • FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
    by damienm38
    5 Replies
    Last post by Andy Pope
      • Hello, I am implementing a lookup Method to find translation matches in XL tables. For example, if I call the Method: Translate("world") in the following cells: A | B -------------------------------------------------------------------------- hello world | bonjour le monde world | monde
  • Excel Time Help
    by MoPatel
    6 Replies
    Last post by MoPatel
      • Hi all, This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me. Here goes, this is the problem i'm having at the moment with my formulas and vba. I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:0
  • Tabbing between text boxes
    by une
    2 Replies
    Last post by Andy Pope
      • I have a userform with 5 text boxes and a command button on it. When the macro that shows the userform is executed the cursor is sitting in the first text box. However when the user presses TAB the cursor does not go to the next text box on the userform, it jumps to the third one. After fillling in text box 4 and pressing TAB the cursor does not go to text box 5, it highlights the command button.
  • VBA for excel - plot series data on secondary axis
    by Lived
    2 Replies
    Last post by Lived
      • Hi, I'm quite noob with VBA and currently working on a project using excel. I need to programatically plot two data series on the same chart, one on primary axis and the other on secondary. if i use SeriesCollection.NewSeries to add new series, by default, the series will be plotted on primary axis. So do anyone know a way to plot the new added series on secondary axis Please help me, thank ver
  • Scripts Object in Excel
    by Viren341
    0 Replies
    Last post by Viren341
      • I want to know up to how much data/Scipt can be storted into Script in Excel This sentence returns ScriptText from script Object Sheet1.Scripts(1).ScriptText I want to know up to how much character It Can store Data Thnxs Viren
  • Searching / Hilighting OCR text in Office Document and Imaging
    by wajhi
    14 Replies
    Last post by Prathap
      • Hi, I have been given following Tasks using MS Document Imaging 11.0 API        Read TIF perform OCR on it        Show it in AxMODI.AxMiDocView    Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result i
  • Importing multiple textfiles into Access
    by DJRave
    4 Replies
    Last post by DJRave
      • Hi, For a project I need to import multiple textfiles into Access. Between 40 and 50 files everytime. Using the wizard wouldn't be a great sollution in this case. I've tried to use the transfertextmethod but the only problem is that I need to specify the exact location of all files in VBA but since the number of files varies every month this creates an error when a file isn't present that m
  • .mdmp files not being created
    by David Ching
    28 Replies
    Last post by David Ching
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • Combobox Userform Code
    by SNl
    0 Replies
    Last post by SNl
      • Good Morning I was hoping someone could perhaps assist I am really overlooking something I am currently creating a second userform (combobox) in my word document. (Reason i am using the user form is due to the fact that I have more than 25 items listed in my combo box.) I have A skills Selection part in my word doc This Selction consist of a variety of 20 different fields to choose from The
  • Listing of files in intranet with VBA
    by Jürgen1234
    0 Replies
    Last post by Jürgen1234
      • Hello there Up to now we have all our templates (xlt, dot, pot) in a standard folder on a server. The access is via a suite of macros which incorporate a search function for a document. (sample: docis = Dir("P:\templates\*expenses*.*"). The templates will now be transferred to our intranet. Now my problem is to implement the search function for templates on the server, that is
  • Dragin and dropin file names
    by Dougy
    2 Replies
    Last post by YaelS
      • Hello All I am relatively new to VBA and have a question that I cant seem to find an answer to on then net. Not sure if it is possible, but here goes anyway. I would like to drag and drop a file path\name from explorer into a text box in an excel form where the text box would then display the full path and file name. Thanks D
  • ComboBox Usage
    by James Simm
    1 Replies
    Last post by Andy Pope
      • Hi there, I'm trying to use a combobox on a form in my Excel VBA application. I'm used to using comboboxes in .NET with no trouble, simply using the DataSource, DisplayMember and ValueMember properties. However, these properties do not exist in the VBA version of this control. Does anyone know how I can have a hidden value for a ComboBox item I need to display the text, and have the ID for thi
  • Excel Solver VBA Problem
    by cgufl
    10 Replies
    Last post by Redskin9
      • I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005'     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"     SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11"     SolverOk SetCell:="$H$10", MaxMi
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • Display a TextBox or Non-modal Message Box
    by sg549
    6 Replies
    Last post by Andy Pope
      • Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show Alternatively, is it possible to put up a "non-modal" system
  • control to appear on top
    by arkiboys
    2 Replies
    Last post by Andy Pope
      • Hi, In VBA, I have placed a flexgrid and a textbox on a form. How is it possible in run time to make sure the textbox is visible on top of the flexgrid control please Is this to do with the z-order I tried that but no success. Thanks
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • Protecting formulas in cells
    by chrstdvd
    6 Replies
    Last post by js06
      • Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd