Search results

yes I am. Aaah ..this sounds interesting (& would explain why I can't simply dump their returned shipping label print data to a file & open it as a gif) it's a very long document....too much info/detail in places (!) but I certainly couldn't locate anything that allowed me to progress, but...

Thanks...ok, I pulled the data out of the XML & piped it into a gif file but windows can't open the file - therefore my attention now goes back to the type of gif data UPS are supplying me with embedded the XML

So I'm using UPS's API to create a shipping label...quite an ordeal, but I'm at the last stage now. Ultimately, they return the shipping label to be printed in the following format (GIF or HTML Image) via XML... <GraphicImage>895UIGJ89XCASDVIGFUISDFNKLFSDANUI43UIT34IONSDFK...

Thanks, I've never been hit by this before....I let access create text fields all the time...it usually defaults to 255... it's only here, when I've converted from hyperlink to text have I seen access apply a character count of 50.

Sorted!! In the end the suspect ? truncation was a misnomer. What has happened is that when I converted from a hyperlink to a text field, without me knowing, access has decided that the text field length should only be 50 characters! (first time I've had this happen). I've set it to the max...

A bit more meat on the bones. This is going to be a hyperlink. I find updating hyperlinks easier if I first convert them to text in access (as then I can see what's going on!)...afterwards I then convert back to a hyperlink(this was a tip I found out about on the web) here's the actual full...

How do I compose the syntax in an update query to avoid a question mark affecting (truncating) the update string? For example, when I have this as the update text... "UK Revise#http://cgi5.ebay.co.uk/ws/eBayISAPI.dll?UserItemVerification&item=" ...It actually results in the following...

Agreed, but this is textual data that has been pulled in from an external source.

Doh, of course "Replace" - definitely a case of me trying to over-complicate things Thanks! Edit: I've worked out how I can actually see the occurrences first (as Replace doesn't show how many were wrong)....just use a basic query with the criteria... Like "* *" ....gotta love databases!

Any idea how I'd do this? e.g. "The quick brown fox" ...two spaces between quick & brown - I'd like to be able to see such instances (so I can fix them!)

Agreed ...I changed it to 180 seconds (that allows for even my slowest day at confirming)

All valid points. The file is downloaded via a browser, which dumps it into the PC's (default) download directory ...so I can't have a separate directory. As I say, there's only me & my colleague use this...there's barely anything else in the download directory & with only one of us using the...

Thank for your input. This code is intended to slot into some larger preceding code...the preceding code prompts the user to download the file from the remote server & "click ok once done" blah blah), This is just for me & my colleague to use (so not being deployed in a massive corporation)...

Thanks guys ...my problem was I didn't know the command/utility in play to be able to search how to deploy it I've gone with the code below (basically loop through all files in a directory & if there's one with a .txt extension that was created within the past 1 second, then that's the file...

I've a pressing requirement to rename a file that has just been downloaded by the user ...but which will have a filename that is not known prior (& forever changing e.g. 10985693759384544.txt ). I know how to rename a file using VBA, but what I don't know is how to identify the file that has...

Thanks. As you say, it only needs trim... Dim strContent As String Dim SettlementDate As Date strContent = "Transaction Summary for 10 April 2018 to 18 April 2018" SettlementDate = Split(strContent, " to ")(1) Debug.Print SettlementDate the above works :-)

This code.... Dim strTemp As String Dim myDate strTemp = Left(strContent, InStr(strContent, Chr(13)) - 1) SettlementDate = CDate(Split(strTemp, "To ")(1)) ...worked for on the string I provided in my opening post, i.e.... Transaction Summary for 10 April 2018 to 18 April 2018 However on...

Correct, but I always read the first line of the text file into a string (as a pre-cursor to handling the overall text file separately), therefore to all intents & purposes I needed a solution for pulling date info out of a single string.

Thanks to all who contributed...some great ideas, in the end I've gone with Markk's code (I'd forgot about the split function ...even though I've used it elsewhere in the past couple of weeks - doh) ...Mark's code works a treat :-)

I have a text file that I'm reading into Access with VBA. The first line of the text file will always follow this format )(though obviously the dates will change)... Transaction Summary for 10 April 2018 to 18 April 2018 The to in that line will always be a constant (& the date I wish to...