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 Swi

  1. Swi

    VB6 Successor

    Hahahahah. Love it strongm.
  2. Swi

    VB6 Successor

    strongm, Thanks I really appreciate the feedback and your insights. Yes, please poke around their community edition. Their IDE seems to be pretty good and I haven't ran into too many issues. Also I agree with what you are saying about VB.net however many C# programmers are saying it is a...
  3. Swi

    VB6 Successor

    Hi, What is everyone's thoughts on TwinBasic or even RadBasic and their future? Curious on people's thoughts and opinions. Sure, you have VB.net but Microsoft is dumping that too. Thanks.
  4. Swi

    Pulling Minimum Lengths

    Hi, Agree about the split fields however this is the output data format that is needed for the machinery it is running on so I am stuck with this format. I did get this working earlier today. It was spacing so I just added the TRIM and all was good. Thanks all.
  5. Swi

    Pulling Minimum Lengths

    I will give that a shot. After I posted I think I may have found the issue but had to leave for the day. I will check it Monday and report back. Thanks.
  6. Swi

    Pulling Minimum Lengths

    Hi, I have the below query. My thought was the part at the end would only select records that had a +4 zip code (12345-1234), however this does not seem to work. Any ideas? Thanks. "SELECT Min(Len([NAME])) AS [NAME], " & _ "Min(Len([ADDR2])) As [ADDR2], Min(Len([ADDR1])) As...
  7. Swi

    Select X of each variation of a field

    Thanks. This is very similar to the way I was thinking of trying Andrzejek. I just did not know if there was a more efficient way.
  8. Swi

    Select X of each variation of a field

    SEQ, NAME, ADDR, CSZ, VERSION 1,John1 Doe,1 Any St.,Anytown US 11111,A 2,John2 Doe,2 Any St.,Anytown US 22222,A 3,John3 Doe,3 Any St.,Anytown US 33333,B 4,John4 Doe,4 Any St.,Anytown US 44444,B 5,John5 Doe,5 Any St.Anytown US 55555,C In a quick example, I would like to return the following if...
  9. Swi

    Select X of each variation of a field

    Requirement now change so I am actually going to read it from a CSV using ADO. Ex. of CSV header - SEQ, NAME, ADDR, CSZ, VERSION Random records would be fine. Just need to work out the query. Set connCSV = New ADODB.Connection connCSV.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &...
  10. Swi

    Select X of each variation of a field

    Hi, What is the best way to select X records of a version within a database. Ex. - SEQ, NAME, ADDR, CSZ, VERSION I would like to pull X records of each unique version. There could be 2 versions to an infinite amount. Thanks.
  11. Swi

    Printer.Print to PDF

    strongm is correct. Got it working using his recommendation. Thanks 👍
  12. Swi

    Printer.Print to PDF

    If you have the code I would like to look at it. Thanks.
  13. Swi

    Printer.Print to PDF

    Hi, Is there a way to use Printer Print method to Microsoft PDF printer and save as a file without the save dialog? Thanks.
  14. Swi

    UPS API - Landed Cost

    Hi, got this worked out. I needed to use the live URLs. The test ones were not working.
  15. Swi

    UPS API - Landed Cost

    Hi, I was doing some testing and it seems everything is connection fine however I keep getting an 400 error that says Unable to validate HS code(s). I have used their sample on UPS but having no luck. Any ideas? Thanks. https://developer.ups.com/tag/Landed-Cost?loc=en_DK&tag=Landed-Cost...
See more

Part and Inventory Search

Back
Top