Search results for query: *

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)

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

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

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.

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

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