Recent content by vladk

Thank you TopTeller, I do use a loop of cause, thinking some other approach could accelerate processing.

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

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

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...

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...

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...

Hi PHV, Your advice works just fine! Thank you so much!!! vladk

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...

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

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...

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

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?

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...

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)...

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