Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vladk
  • Content: Threads
  • Order by date
  1. vladk

    How to convert SqlDataReader to a Recordset in VB.NET

    Hi, I would like to use CopyFromRecordset Excel method to export data to Excel by avoiding looping through the records. I have SqlDataReader populated with data. Would it be possible to implement? Many thanks vladk
  2. vladk

    Collection was modified enumeration operation may not execute

    Hi everyone, How it would be possible to fix the exception in this procedure? Any help will be appreciated. Thank you! Public Sub LoadEmailAddress() Dim strRecipient As String Dim dicRecipients As New Dictionary(Of String, String) Dim dicCopyGroups As New...
  3. vladk

    Hi, I am not sure if this is rig

    Hi, I am not sure if this is right forum to ask since I am not a javascript developer. Can anybody please help me to find example of the link in the web form, which would start a desktop application. The catch is that the desktop application accepts command line arguments, and the arguments...
  4. vladk

    How to center a table at the page in XSLT file

    Hi, I am not sure to center this table: <fo:table text-align="center" border-color="black" border-width="0.25px" border-style="solid" margin="0.1in" table-layout="auto"> <fo:table-column column-width="12pt" /> ... <fo:table-body> <fo:table-row> <fo:table-cell...
  5. vladk

    How to execute stored query with parameters and &quot;IN&quot; clause?

    Hi, Can anybody help me with "IN" clause parameters in a stored query? My insert qryMyAmts query contains such a clause: WHERE MY_AMTKEY IN ('1','2','3') It runs fine. I want to call it from VBA in Access and I changed the clause to WHERE MY_AMTKEY IN ([MyAdmKeyList]) My VBA code is like...
  6. vladk

    The Type initializer for 'MyApp.modMain' threw on exception in Citrix, works fine directly

    Hi guys, I built VB.NET (VS 2012) application that works with Excel. Compiled exe and saved it on shared network drive. Works fine if I just locate the file and start it in Windows Explorer. Throws the exception (InteropServices, method not found) in Citrix. Found it happens when code deals...
  7. vladk

    Executable is not working, but code inside VS2012 does

    Hi, I built simple Windows Forms VB.NET application. It reads text files (like for Notepad) and creates another text files. At the end, it displayes a conformation message. The program works just fine from VS2012. Howevere when I run it's executable from bin/release (I built it for release)...
  8. vladk

    Several joins including self on a data table and two look up tables

    Hi, I am trying to build join query on Bank_Fees, Unit_Lookup, and Fee_Lookup tables: Bank_Fees Invoice_Mnth Invoice_Yr Unit_Name Fee_Type Amt 1 2013 Unit-1 A 12 1 2013 Unit-1 A 18 1 2013 Unit-1 B 13 1 2013 Unit-1 B 15 1 2013 Unit-2 A 10 1 2013 Unit-2 B 11 2 2013 Unit-3 A 5 2 2013 Unit-3 A...
  9. vladk

    Excel - Require Variable Declaration - How to set this option in code?

    Hi, I would like to check this setting, store the value, set to 'require' if needed and then set it to initial value - all in VBA. Thank you! vladk
  10. vladk

    Excel 2003 Error 13 Type mismatch

    Hello everyone This code breaks on line 1 with that error Private Sub HideExtrapolatingLines(ByRef ioobjWsht As Worksheet) Const METHOD_NAME As String = "HideExtrapolatingLines" On Error GoTo MethodExit 1 ioobjWsht.Rows("307:310").EntireRow.Hidden = True 2...
  11. vladk

    Pivot table and a thin book

    Hi, Is it possible to create a workbook with a pivot table, which is connected to a large, say ACCESS, table (may be 400MB), and still have a very light book? And if its possible, how it can be implemented? Thank you vladk
  12. vladk

    UPDATE QUERY

    Can somebody help me with update query? I have two tables: T and S. Both tables have fields F1,F2,F3,F4. These fields identify common records on the tables. Table S has [Calendar Year] and [Calendar Month]fields. Also, for each (F1,F2,F3,F4) record, table S has some numeric parameter in field...
  13. vladk

    How to copy content of a module from one workbook to another?

    I need to copy content of, say, Module1 in Excel Book1 to Module2 in Book2. And before I need to delete Module2, then create it and assign it a name. And also, copy not just a content, but entire Module1, but first delete Module2 in Book2, then copy Module1 from Book1, and then rename Module2...
  14. vladk

    ADOX and sorting the columns in the Access table

    Hi, When I try to retrieve column names from the ACCESS table using ADOX, I get them in the alphabetical order. And I need them in the order they are defined in the table. Can anybody help me with this? Thank you!
  15. vladk

    Building ADODB recordset from Excel worksheet. Error.

    The error is "Operation is not allowed when the object is closed. This error occures ONLY when I run code right after I opened my VB6 project. The code runs just fine when I repeat runs during the same session.... I have no clue... This is the code: Dim objRcrdstFromExcel As New...
  16. vladk

    From Excel to PowerPoint. Copy a range into the image box.

    Hi, I try to do the following one, using VBA: 1. Insert object (select Bitmap Image) into Powerpoint slide 2. Copy range in Excel workbook. 3. Paste this range INTO the bitmap image object in PowerPoint. So far, I was able to add an empty image to a slide and activate it to prepare for...
  17. vladk

    Order of fields in WHERE

    Hi, If I use a composite index, say Field1, Field2, Field3, the order in which these fields are listed in WHERE clause will be important? And if yes, then how should I list them: from top to bottom or from bottom to top? This is ACCESS database. Thank you! vladk
  18. vladk

    Cannot open Excel wbook from VB6

    I run this code: Dim objWbk As Workbook Dim objExcel As New Excel.Application Set objWbk = objExcel.Workbooks.Open("C:\Projects\2008 RateBase\PageMaker2008\RataBaseTemplates\AL\176_AL_PREM_LIMIT_FCTR.xls") The workbook exists, I hardcoded it. The location exists also, it's on...
  19. vladk

    VB6 cannot recognize String, Right, Chr...

    Got new PC, and my VB6 projects lost some basic references. Can anybody give a hint, what basic library(ies) I lost? Thank you!
  20. vladk

    ADODB connection string on sharepoint

    Hi, I have some VBA code inside Excel. This is the piece of code that does work on the network, but not on the sharepoint: Set ioobjConn = New ADODB.Connection Set ioobjCmnd = New ADODB.Command Dim strCnctn As String strCnctn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _...

Part and Inventory Search

Back
Top