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!

Register Log in
  • Congratulations Rhinorhino 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
  • Order by date
  1. vladk

    How to convert SqlDataReader to a Recordset in VB.NET

    Thank you TopTeller, I do use a loop of cause, thinking some other approach could accelerate processing.
  2. 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
  3. vladk

    Collection was modified enumeration operation may not execute

    Found the cause: it was byref call to GetSqlReaderForEmailAddressesNew. Thank you
  4. vladk

    Collection was modified enumeration operation may not execute

    ...End While MyGroup = gdicGroups(strGroup) MyGroup.Recipients = dicRecipients '***** The next line throws the exception dicCopyGroups.Add(strGroup, MyGroup) Next strGroup...
  5. 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...
  6. 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...
    • vladk
    • Thread
    • Replies: 0
    • Forum: XML
  7. vladk

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

    Hi PHV, Your advice works just fine! Thank you so much!!! vladk
  8. 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...
  9. vladk

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

    Hi Andrzejek, Thank you for the response! I discussed this issue with our Citrix team, and they somehow fixed it. Have no idea what they actually did; Excel and Framework are the same across the board. Thank you again! vladk
  10. 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...
  11. vladk

    Executable is not working, but code inside VS2012 does

    Hi jebenson, Yes, you are right, it reads different files. The problem wos in Replace function. It looks like in IDE it is case insensitive, when in EXE it is case sensitive. Thank you for your advices so much! vladk
  12. vladk

    Executable is not working, but code inside VS2012 does

    There are more findings. I use StreamReader to read lines in text ANSI file, the regular notepad file. The lines it returns are correct in VS2012, but these lines are collections of chaotic characters, not even letters, when I run EXE. The font is Times New Roman. Can anybody help?
  13. vladk

    Executable is not working, but code inside VS2012 does

    Hi jebenson, I followed your advice and found the following. This condition is satisfied in VS2012 and it is never satisfied in EXE: If strTagBU.ToUpper.Trim = oCheckBox.Tag.ToString.ToUpper.Trim Then This is how I get strTagBU: strTagBU = strIniLine.Split("="c)(0).ToString Inside VS2012...
  14. 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)...
  15. vladk

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

    BigRed1212, Thank you for your brilliant explanation! :0)
  16. vladk

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

    BigRed1212, I can't post my query, it's at my work! But this is not really important, it was simple right outer join query. But thank you for your reply, I do appreciate it! PHV, When I only looked at your "name", I realized, that I will not need any other answers. Your query works...
  17. 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...
  18. vladk

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

    Skip, it does not matter for what. This is just a question - how to play with such settings in VBA? :0) Yes, combo, I also think that it was supposed to be in VBIDE. I still believe it can done without direct registry reading.
  19. vladk

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

    Guys, the only thing I wanted is to see if Option Explicit is On or Off to carefully insert lines if needed. I had no intention to leave it ON or Off on someone PC permanently - just wanted consistency. Still see nothing wrong with my question (question is always just a question) and do not see...
  20. vladk

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

    And, btw, there is still no code for this, engaging the EXCEL object model, this is what I would like to see...

Part and Inventory Search

Back
Top