Search results

Indeed you did, it works (thanks!)... CorrectedShippingAddress2: Replace([ShippingAddress2],Mid([ShippingAddress2],InStr(1,[ShippingAddress2],"Ebay")),"") ...but if I understood correct, wouldn't that cause problems if the word Ebay appeared anywhere in StreetAddress2 legitmately? Would I not...

Thanks guys, this may not be that elegant, but you can perhaps see my direction of travel, a query to isolate chunks of ShippingAddress2... so using the above query, I just need to test for the existence of "Ebay", so something like this... MyShippingAddress2...

For some bizarre reason Ebay has just started randomly adding to the the following text to StreetAddress2 field (the following are just 3 random examples).. Ebayj4jvksc Ebayv4jmfz6 Ebayp4jjqv3 ...it's always Ebay...followed by 7 random characters (therefore 11 characters in total)...when...

Thanks guys...that seems to have done it (I'm pretty sure I tried that earlier, but having spent quite some time on this my head is a bit fried so perhaps there was another issue at that point!)

Tearing my hair out here (I've not worked with forms much, must be missing the point here!) I'll keep it simple.....let's say I have a table with a field in it called "Barcode" So I have a form setup with the field Barcode showing (ready to accept input) What I want to do is take the data...

That worked a treat...thank you soooo much!

I have a working solution for UK/US addresess, which typically follow this format 123 Station Road but Germans Italians & Spanish etc reverse things, for example... Via Trieste 22 ...any ideas how I can break out the above to 22 (Property number) Via Trieste (Street Name) So, I need to...

could you be a bit more explicit (as I don't know what you mean) ...do you mean delete the current ODBC linked mySQL table & then create a new ODBC link to it again? This is a remote mySQL database running on a webserver ....being candid - I wouldn't know how to! It's not my table (it was...

Thanks for the input, it might be a bug with the mySQL ODBC connector... https://bugs.mysql.com/bug.php?id=92947

So I've set up an MS Access ODBC connection a remote mySQL database (shopping cart database) - I've deleted some linked table records on the remote mySQL database using MS Access ...they have deleted, but now whenever I open the - just shows #Deleted ...I'd expected them to actually disappear...

it wasn't because I want to keep stuff secret, but more that the actual field names involved are a little obtuse, hence trying to make it a little easier to read ...the reason I didn't make the disclaimer., is because I'd overlooked the fact that they were reserved words(!), but in future I will :-)

I think I got a syntax error for the command (not 100% sure, it was many iterations ago!) I managed to get it working with this syntax.... DLookup("surname", "members", "[age] = " & search_age & " And [name] = """ & search_name & """") Point taken about the reserved words...I'm not actually...

[Post Self deleted - I spoke to soon & still haven't solved the problem yet!]

if I have two criteria for a dlookup...one being text & the other a number ...bot stored in variable what would the command be? So for example, two variables.... search_name = "john" search_age = 49 I wish to use those variables above to search a table called members for a surname using...

Thanks...I googled tempvars, but there's a whole lot of learning for me there! I've just managed to sort it ...all I had to do was use the 'Browse' option in references, to locate FM20.dll in windows/system32 Once done, this code works... Dim obj As New DataObject Dim txt As String 'Put...

I seek a way of selecting a table field, then having a preset autokey (shortcut key) configured, that when pressed, runs a bit of VBA, that inserts a number (1 more than the last) into the selected field. I know how to do autokeys. I know how to store a number, recall it, increment it, then...

I was lying in bed last night & this conclusion popped into my head (it's not great to think about VBA when lying in bed!) ...thanks for the clarification. the main body of code has an IF test, as follows... ElseIf InStr(Description, "DSPT") Then OriginalDisputeID =...

To give some feedback/closure, June7's solution worked a charm ... OriginalDisputeID = Mid(Description, InStr(Description, "DSPT") I have not got a clue what's going on with the command (I always thought that with the MID() function that it was necessary to give the number of characters to be...

Thanks...perhaps I should have been clearer, the numbers following on from the DSPT will be different each time As it goes the text is a variable named Description, therefore I seek the final part of the solution you offered... mid(Description,instr(1,Description,??)) EDIT: Just seen June7's...

Any ideas re an elegant dependable way that I can extract the bit in red out of a text string... 7501243706 For Transaction: 7501021926DSPT21174531807 ...in other words when the characters DSPT are found, get everything that follows....so from that long text string, I'd like to end up with...