Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Search and Replace Trim function in SQL statements in Access 97

Posted on 2003-03-06
7
Medium Priority
?
521 Views
Last Modified: 2006-11-17
I need to remove any instances of the Trim function in about 685 queries. I am using Access 97.  The tables used are MSDE linked ODBC data sources.

Is there a Search and Replace function out there that could automate this.

Thanks for your help.

John Desselle
0
Comment
Question by:John Desselle
7 Comments
 
LVL 26

Expert Comment

by:Alan Warren
ID: 8085872
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 2000 total points
ID: 8085929
An alternative shareware tool:
http://www.rickworld.com/products.html

Works rather nicely and is *considerably* cheaper than SpeedFerret, if you choose to register it.
0
 
LVL 26

Expert Comment

by:Alan Warren
ID: 8085960
trial version o either should get the job done.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 8085974
Ah, I was looking in the wrong place for the demo version of SF - found it now.
0
 
LVL 3

Expert Comment

by:Koka1
ID: 8095370
Maybe this would help:

Dim q As QueryDef
For Each q In CurrentDb.QueryDefs
q.SQL = Replace(q.SQL, "TRIM", "")
Next q

Good luck
0
 
LVL 12

Expert Comment

by:nexusnation
ID: 8785327
Hi jwdesselle,
This question has been abandoned and needs to be finalized (107 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
0
 
LVL 18

Expert Comment

by:1William
ID: 8884896
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, split points to alanwarren and shanesuebsahakarn
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question