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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 2007 VBA: Find and Replace a Character in a Table
Consider this item closed. Thanks dhookom and Andrzejek! I had to make one minor adjustment to my code, but got it to work using the above. Both of you take out $50 from petty cash!- brownrek
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007 VBA: Find and Replace a Character in a Table
Please bear with me, I'm new at these online helps. I apologize if I did not specify in a more direct way exactly what I am trying to do. I need to replace ONLY the apostrophe with a null value. For example: [PLANNAME] "Tony's Pizza" needs to read "Tonys Pizza". I am trying to automate a SQL...- brownrek
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007 VBA: Find and Replace a Character in a Table
Got a Run-time error '3075': Syntax error (missing operator) in query expression 'REPLACE(PLANNAME,'.- brownrek
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2007 VBA: Find and Replace a Character in a Table
I have spent several hours trying to write the code to search for an apostrophe (') in a specific field in a table and have it replaced by a null value. The code could either be on this specific field or the entire table. Usually the data generated would be less than 100 records. I can get...- brownrek
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
