You are awesome!!
I did keep Pxbefore since it makes most sense for my sanity. I will just do an update query to the final table.
Again, you are awesome and thank you very, very much!
osmosisgg
Last Activity: Jun 12 '17, 02:46 PM
Joined: Dec 13 '13
Location:
-
I added [PhilsPX] to the Scan table. First try I received runtime error '3265' onSo I renamed the my field from Px to [Pxbefore]. It worked like a charm. Now of course, my luck- here it goes. I thought I would use the actual Scan table, changed within the code you created to !px and get runtime error 94 onCode:StrSearchIn = Split(!Pxbefore, " ,")
hmmmm...maybe I should just leave it as...Code:StrSearchIn = Split(!PX, " ,")
Leave a comment:
-
Thank you for sticking with me on this. Phew! Glad I made some sense finally! The Px AFTER column should be the results.
-osmosisgg...Leave a comment:
-
Yesterday was a late night, but after sleeping and having some good coffee, I realized that I actually did not run the dropdupewords function and that is one reason I saw the dupe strings in [px]. I have now inserted that into my run.
Hopefully the JPEG file is attached this time.
It has been quite a while since I have done something with Access and never had much training...goog le was it. That is why I came to the folks who know...Leave a comment:
-
See line 304 or 317 for examples. These fields are text formatted due to some of the data contains actual text. They may be found in any order and are either in the format xxxxx-x or xxxxx-xx-x or xxxxx-xx-xx and occasionally as xxxxx-xx-xx-x.
I just noticed the EM column was not wide enough, but 304 actually has 99213-25-1 at the end. What should end up in [px] is 90471-1 90715-1
And now that I looked at that line, I just noticed...Leave a comment:
-
Just looking over anything I missed. Not sure where to go with this, but replace [px] with instr[em]...?Leave a comment:
-
I used this and did not receive any errors, but the string in [EM] is still in the [px] field.When I tried the below, no errors and no changes to the [px] field.Code:UPDATE SCAN SET SCAN.px = Replace([px],"*" & [em] & "*","");
...Code:UPDATE SCAN SET SCAN.px = Replace([px],"*" & [em] & "*","") WHERE px = Replace([px],"*" & [em] & "*","");
Leave a comment:
-
When I ran them, "Syntax error (missing operator) in query expression 'Replace([px], "*" & [em] & "*","") from SCAN.Leave a comment:
-
osmosisgg started a topic If field[Px] contains string[EM], delete the string[EM] from the field[Px]in AccessIf field[Px] contains string[EM], delete the string[EM] from the field[Px]
Good Morning,
I need assistance with finding and deleting a string found in field[EM] from another field[Px] within the same table. I've tried in SQL and returned #error on fields with no data and the strings from field[EM] were still present in [Px].
One example of Tried & Failed in SQL:
I did find a previous post with...Code:SELECT SCAN.ID, Replace([px],"*[em]*","") AS Test FROM SCAN;
-
Sorry, been so busy this week. oh darn. I read some stuff on late binding it seems it's not that easy and folks seem to have issues with it. I believe in you :)Leave a comment:
-
Ok I will get familiar with it. I would like to avoid head banging- the 80s are over even though they were the best years lol.
oh- oops you mean I wasn't suppsoed to eat the treats for you? hehehheeee...Leave a comment:
-
LOL! Thanks :) The last updated powerpoint by the wonderful zmbd worked. Upon trying to insert/update the same ppt with my data, it would not work. I updated one of my access db's to NOT use Q# (yeah one of many I created)- it doesn't work in VBA as mentioned in the above. In short, please pay attention to which one you update so you can reference the correct db data as I made the mistake of not referencing the appropriate updated db.Leave a comment:
-
whoah - it works that way. I will research.Leave a comment:
-
Ok - arrow is initially red. Using the keyboard arrows going forward and back turn the arrow green. (pretty cool trick, but not intentional) After that, data populates.Leave a comment:
-
ok - I tried on 2 different computers, both with access 2010 and I went ahead and tried with access 2013 and to no avail. :(
Also the access files only contain the people data and not the data table, but I used the people table field names.Leave a comment:
-
I deleted everything and am wondering if you could please post the file with the data table. Please?Leave a comment:
-
No warnings and security settings are in order. I'm going to delete all files and begin again.Leave a comment:
-
I can't figure out what I am doing wrong. I only am using your files and the arrow is red the first time around. I have to close out the ppt and re-open since the arrow disappears on the second go around. I must be missing something somewhere. :(Leave a comment:
-
Compiled with no errors. yay!
(I did not set my reference to MSO 14.0 access db engine object. I will do so if/when you instruct me to do so)
I followed the instructions. Where exactly did you want me to put the below into the sub cleanuptheobjec ts? After end with?
The slides whiz by and there are no popups at the end for "done" or "goodbye"...Code:If slidecoderan > 0 Then slidecoderan = 0
Leave a comment:
No activity results to display
Leave a comment: