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 Chriss Miller 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: Swi
  • Order by date
  1. 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.
  2. 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.
  3. 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...
  4. 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.
  5. 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...
  6. 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=" &...
  7. 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.
  8. Swi

    Printer.Print to PDF

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

    Printer.Print to PDF

    If you have the code I would like to look at it. Thanks.
  10. 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.
  11. Swi

    UPS API - Landed Cost

    Hi, got this worked out. I needed to use the live URLs. The test ones were not working.
  12. 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...
  13. Swi

    Excel Webservice

    Hi, I am using the following code to return a web service API call from the USPS. =FILTERXML(WEBSERVICE("http://production.shippingapis.com/ShippingAPI.dll?API=TrackV2&XML=%3CTrackRequest%20USERID=%22"&$E$1&"%22%3E%3CTrackID%20ID=%22"&D3&...
  14. Swi

    Parsing Names in multiple formats

    I truly wish I could get good names at the start... Here is a sampling of the formats. Looks like Last Name is always first. Like a government inverse but the suffix is not consistent. DOE,JOHN J DOE,JANE MARIE DOE,JOHN J III DOE JR,JOHN J OLIVER,CHARLIE DOE FAHLER,JANE
  15. Swi

    Parsing Names in multiple formats

    Hi, I see the following link for parsing names. https://www.experts-exchange.com/articles/1819/Parsing-Names-in-MS-Office-Visual-Basic-6-and-Visual-Basic-for-Applications.html It does a pretty good job. However, for off the wall formats like LastName,FirstName MiddleName Suffix The only...
  16. Swi

    API - multipart/form-data

    Thanks strongm. Appreciate it. I did get it working but with something I had paid for a few years back. https://www.example-code.com/vb6/rest_form_data_upload.asp Thanks. Swi
  17. Swi

    API - multipart/form-data

    I found this online but still no luck. BAsically it return a 200 success but if I check the responsetext it is not a response but the whole webpage of the API. Any ideas? Sub UploadFile() Dim url As String Dim filePath As String Dim fileContent As String Dim boundary As...
  18. Swi

    API - multipart/form-data

    Hi, I have the following curl but I've never posted a CSV file to a REST API this way. I am stuck on the part shown below. Any ideas? curl --request POST "https:/xxxxxxxx.com/api/reports/upload" --header "Authorization: Bearer {YOUR_AUTH_KEY}" --header "Content-Type...
  19. Swi

    Rotate every 6th page in a PDF

    Hi, I do have the full version of Acrobat but has anyone ever rotated the nth page in a PDF document programatically? Thanks. Swi
  20. Swi

    12 Month Rolling Average

    Thank you for your help. Swi

Part and Inventory Search

Back
Top