Microsoft ISV

Page 211




  • Topics
    Replies
    Last post
  • 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 '
  • Help with Excel VBA
    by Pablo Terevinto
    2 Replies
    Last post by Pablo Terevinto
      • Hi all, I created an application using Visual Basic .Net 2005, that reads a log (in txt format) and using VBA code, it transforms it to an Excel file. The question i have is that the output of the app i an excel file and i want to (inside the generation) add a module and a form in the excel. Does someone knows how to do that If you have any question about it, please ask for ex
  • height of a field in word
    by vsyam
    6 Replies
    Last post by Shasur
      • Hi, Any idea as to how we can get the height of a field in word in vba Thank you.
  • 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,
  • Generate log file when updating Excel Worksheet file
    by mrtaktak
    1 Replies
    Last post by ke wenzel
      • Can anybody giving advice or help if I want to generate a text log file whenever I open an Excel Worksheet file and update it Would that be possible to be handled by VBA code Thanks a lot for any help. Victor.
  • Outlook 2007 crashed in Windows Vista PC
    by cecelia
    1 Replies
    Last post by B. Ward
      • I am running on: Windows Vista Outlook 2007 Exchange Server 2007 The application crash problem occurred when I runs the customized outlook form. Any help Below is the error message:- Problem signature Problem Event Name: APPCRASH Application Name: OUTLOOK.EXE Application Version: 12.0.4518.1014 Application Tim
  • Strange Outlook 2007 POP3 Behavior & Slowness
    by Ring0
    1 Replies
    Last post by jttaynton
      • Outlook 2007 is sending "AUTH "<crlf> as the first command to POP3 servers. This confuses the server and on some, causes a 3 second delay! Thus: 2007.01.02 13:04:47 POP3 (mira.net): Connected to host 2007.01.02 13:04:47 POP3 (mira.net): +OK POP3 Ready mailproxy2 0001bff0 2007.01.02 13:04:47 POP3 (mira.net): Authorizing 2007.01.02 13:04:47 POP3 (mira.net): [tx] AUTH ** note 3 seconds
  • Dynamic Lists in Excel
    by SHolst22
    4 Replies
    Last post by suna2006
      • I created a list in Excel as described in http://www.contextures.com/xlDataVal02.html I want to have the following structure of dependant list. List 1 List 2: Contents dependant on List 1 List 3: Contents dependant on List 2 List 4: Contents dependant on List 3 List 5: Contents dependant on List 1 I created List 1-4 using the method described in http://www.con
  • Outputting histograms and graphs
    by une
    4 Replies
    Last post by une
      • Instead of outputting data in text from in a message box, I would like it to appear on screen as a histogram or graph in a window (message box ). Where should I start to get this done
  • Conditional Formatting Problem/Bug?
    by FaV1105
    8 Replies
    Last post by FaV1105
      • This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this: I don't know if this is a bug in excel or if I am doing something wrong. I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
  • Easy msgbox Query
    by jaxgev
    8 Replies
    Last post by Andy Pope
      • Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
  • Office 10 \ winword.exe runtime error
    by Kdean6869
    14 Replies
    Last post by Jyh-Cheng Chen
      • I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe.
  • WorkbookActivate or WindowActivate not firing in excel VBA
    by kvreddy
    6 Replies
    Last post by kvreddy
      • I have written excel VBA for office 2007. WorkbookActivate or WindowActivate not firing while switching the windows or excel applications. can any one help me. Thanks
  • Network Interface Card (NIC) Enable/Disable in VB 6
    by Gilbee
    0 Replies
    Last post by Gilbee
      • Hi All I have 2 NIC in my pc and one Virctual NIC I want to Programatically (visual Basic 6) enable and disable these nic, if you have any idea please share with me any clue also welcome. programm codes are most welcome. gilbee
  • Spooler error 1068
    by Terminator484
    14 Replies
    Last post by virginia3443
      • I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa
  • CRM 3.0 Outlook Client
    by keithpsft
    18 Replies
    Last post by keithpsft
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • Compile rrror: syntax error
    by gibger
    5 Replies
    Last post by gibger
      • Hi, When I run the following code: Code Snippet Private Sub btnClickMe_Click() Dim intrandom As Integer Dim index Dim person Dim match As Boolean Dim personx Dim persony Dim n Dim birthday() Dim counter match = False ReDim Preserve birthday(23) intrandom = (Rnd * 364) + 1 Randomize counter = 0 For n = 1 To 100 For persony = 1 To 23 birthday(person) = in
  • Setting a header to all pages except the cover sheet
    by Megaman1982
    6 Replies
    Last post by Megaman1982
      • Hi all, i'm pretty new to Excell in the workplace and would really love it if you lot could help me with this difficult (TO ME) macro i'm struggling with. I'm trying to finish off this macro, or mod it so that i get the page number, tab number, a cell reference in the respective headers and footers as explained in the macro below. only thing is i don't really want the tab label, cell refere
  • Once copied, can we export as a GIF file?
    by Perry Choy
    28 Replies
    Last post by Perry Choy
      • How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much    
  • important
    by ali malmirzadeh
    1 Replies
    Last post by duck thing
      • i do uncheck special key but shift key is not disable before startup.
  • How do I update a cell in a closed workbook?
    by MyLady
    5 Replies
    Last post by MyLady
      • Hey, How do I, with VBA code, update a cell in a closed workbook when a cell in the active workbook changes When the update is done, the cell value in the closed workbook shall have the same value as the changed cell in the active workbook. Best Regards Cathrine
  • Outlook 2007 crashed in Windows Vista PC
    by cecelia
    1 Replies
    Last post by B. Ward
      • I am running on: Windows Vista Outlook 2007 Exchange Server 2007 The application crash problem occurred when I runs the customized outlook form. Any help Below is the error message:- Problem signature Problem Event Name: APPCRASH Application Name: OUTLOOK.EXE Application Version: 12.0.4518.1014 Application Tim
  • VBA for Access 2003 not seeing ADOX nor some ADODB objects
    by anhyzer
    2 Replies
    Last post by anhyzer
      • I have the basic install of Access 2003 and am using the standard VBA that installed with it. When I'm adding code and start a line with "ADODB.", I can get some objects such as Fields or RecordSet, but not others such as Stream or Record. If I manually type in either "ADODB.Record" or "ADODB.Stream", I get a "User-defined type not defined" compile error. Th
  • Events
    by rtmos
    1 Replies
    Last post by Shasur
      • Could someone please point me to an article defining all the (access) form-related events and the sequence in which they occur. Thank you
  • Subtract a date
    by F&amp;#38;&amp;#35;225
    6 Replies
    Last post by Fábio Nobre
      • Hi, I'm creating a aplication whith Visual Basic and I need to subtract dates, now I'm using a simple method: Subtract a Month: --------------------- If optmes.Value = True Then (DateValue(Now) - 30) & " " & TimeValue(Now) Subtract a Year: --------------------- If optano.Value = True Then (DateValue(Now) - 365) & " " & TimeValue(Now) But this met