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!

Search results for query: *

  • Users: Swi
  • Content: Threads
  • Order by date
  1. 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.
  2. 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...
  3. 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.
  4. 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.
  5. 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...
  6. 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&...
  7. 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...
  8. 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...
  9. 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
  10. Swi

    PDF Interrogation

    Hi, Does anyone know of any code base that would allow me to interrogate a PDFs size, spot colors, etc... after a user uploads a file? Thanks. Swi
  11. Swi

    12 Month Rolling Average

    I have a Access database that has a shipment_date, SKU and plannedQty field. I would like to do a 12 month rolling average of how much is being used of each SKU. What is the best way to accomplish this? thanks. Swi
  12. Swi

    FedEx REST API

    Has anyone used VB6 and FedEx's REST API to look up a package by the tracking number? If so,can you provide an example? Swi
  13. Swi

    Read Excel Sharepoint File

    Hi, Does anyone have any experience reading an Excel file on Sharepoint? Thanks. Swi
  14. Swi

    Jet Sql Statement - Select Distinct Multiple Columns

    Is this the best way to select multiple columns from a table that has a distinct order ID field? [code] SELECT Master.[OrderID], Max(Master.[customer]) AS MaxOfcustomer, Max(Master.
  15. Swi

    HTML Entities

    Hi, I am writing XML files out and wondered if something like this is the best solution for my issue. I am getting a lot of data that has Spanish characters, etc... and it is causing the XML parser to fail that is ingesting my files. Basically, should I keep adding *Replace* lines below for...
  16. Swi

    Date/Time Conversion

    Hi, I have the following date format. I would like to split out the date (which would be easy enough but how would I translate the time to HH:MM AM/PM? Ex. - 2023-07-06T14:34:21-04:00 I would like to have: DateToUse = YYYY-MM-DD TimeToUse = HH:MM AM/PM Thanks. Swi
  17. Swi

    REST API - Shopify

    Hi, I have a legacy app that connects to an online store database to pull orders and integrate into a MIS system. The client is migrating away from their current site and going to Shopify. I would like to just swap out the module that reads the DB and add an API call to pull orders from the...
  18. Swi

    CRLF in middle of comma delimited file

    Hi, Many users like to put a CR or LF in Excel to split out two address lines. Ex. - 123 Any Street Apt. 123 This is fine when importing as I normally read files with an EOR marker of CRLF, pretty standard. However, now I am receiving a file where the address lines within a field are...
  19. Swi

    Adobe SDK

    Has anyone ever used the Adobe SDK to pull a list of all colors used in a PDF? I've pulled text from, pulled size from, added pages to, deleted pages, etc... from a PDF using the SDK however I have not located anything to do this. Any help would be greatly appreciated. Thanks. Swi
  20. Swi

    IMB - USPS Barcode Conversion

    Does anyone have a VB6 solution to decode a USPS Intelligent mail barcode? Ex. - DFTDTTTTDFDDAFTAAATFAFAFTTTTDADTDDTTAFFDDDTFAFFDATFTATAATFTTAFDTT Basically convert it to its numeric translation. I found a few online converters but it only does one at a time. I need to do this in bulk. I...

Part and Inventory Search

Back
Top