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!

Recent content by MakeItSo

  1. MakeItSo

    Word Art Anomaly, or Am I Dreaming?

    Hi Skip, adding to Mike's suggestion: choos "Transform", then "Rectangle". This should basically leave your optics unaltered but give you an option to stretch/compress. You might need to play a bit because of automatic wrap. Hope this helps. MakeItSo "Knowledge is power. Information is...
  2. MakeItSo

    Join two select statements and collecting data from both

    Your output data does not match your query. state='TN' and you expect outputs with states FL and CA? Please clarify what exactly it is you need. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA...
  3. MakeItSo

    splitting a field based to create a new field for every line after a carriage return

    Hi Tony, Sounds more like a SQL question to me; perhaps forum183 or forum436 would be a better suited forum? Depends on your DBMS. In that case you also might want to rethink your DB structure. You should not hold multiple values in one field. Hope this helps. MakeItSo "Knowledge is power...
  4. MakeItSo

    Holding up for Ridicule

    Following a hunch, I used bugger translate to have this sentence translated into Chinese and back. Replacing "ting" with "thing" did not yield anything meaningful but replacing it with "Ting" led me to this: With "Ting" possibly referring to Shu Ting, a Chinese poet associated with the Misty...
  5. MakeItSo

    Hallo, kann mir jemand eine Beis

    Hi Chefe, please use English in these forums to make sure others also understand your needs and the solutions provided. [smile] That said, you can download a release package including the specification for ZUGFerD 2.x here: https://www.ferd-net.de/standards/zugferd-2.1.1/index.html Best...
  6. MakeItSo

    StreamReader doesn't read

    Hi Ilya, Sounds like you are thinking of a class. Take a look at the following. It is C# but then again that is also .Net and can easily be converted/translated into VB.Net: https://www.tek-tips.com/viewthread.cfm?qid=370520 Hope this helps. MakeItSo "Knowledge is power. Information is...
  7. MakeItSo

    StreamReader doesn't read

    Hi Ilya, my guess is the problem lies here: Meaning: your gcStrINI="" and your gcStrINI = loStreamReader.ReadToEnd() are not in the same scope and therefore two different variables, albeit with the same name. Can you post a larger portion of your code? P.S: When using a StreamReader or other...
  8. MakeItSo

    SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas

    You could try a quick workaround using OpenOffice / LibreOffice. open the csv there, save as csv with "adjust filter settings" option checked. Enclose in quotes. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi...
  9. MakeItSo

    new website renders fine in IE/Edge but not in Chrome - test site was fine

    Can you please clarify? Site looks pretty identical to me in FF, IE, Chrome. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever...
  10. MakeItSo

    Konami code help

    First of all: LOL! Secondly: https://www.cambiaresearch.com/articles/15/javascript-char-codes-key-codes ;-) Oh, for point 2): You could try with a cookie as counter. A simple if / switch case should suffice for the rest. "Knowledge is power. Information is liberating. Education is the...
  11. MakeItSo

    Need clarification for using {} statement in C#

    Hi Ilya, the usage of "using" is similar to that of "if" or "for": if only one statement follows, no need for braces, even if that one statement following is another "using" statement. Therefore, your code is equivalent to something like this: using (XmlWriter writer = XmlWriter.Create(result...
  12. MakeItSo

    C# - Visual Studio - Excel COM Add-In error...?

    Hi Ilya, I though the other acronyms were explanatory enough: ACTA ;-) "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name...
  13. MakeItSo

    String.Contains() - how about a literal string?

    Hi Ilya, I'd make use of "StartsWith" instead of Contains: If cJustFileName.StartsWith("CD") OrElse cJustFileName.StartsWith("GH") Then End If This is assuming you got something like this: cJustFileName = Path.GetFilename(cFile) or cJustFileName = Path.GetFilenameWithoutExtension(cFile)...
  14. MakeItSo

    C# - Visual Studio - Excel COM Add-In error...?

    Howdy! [ol a] Don't worry about InternalStartup. That's normal Are you using 64-Bit Office or 32-Bit? That's important Is your solution local or on a network drive? Addins need to be compiled and added locally I believe your code in Application_WorkbookBeforeSave is not quite OK [/ol]...
  15. MakeItSo

    Backup using a vbscript

    Glad to know it worked right away. Removing unnecessary physical action is what a script is for. [bigcheeks] "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom...
See more

Part and Inventory Search

Back
Top