[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

VBA Microsoft Access Function to find/replace for a whole table

Posted on 2007-03-20
2
Medium Priority
?
2,443 Views
Last Modified: 2013-11-27
Hi,

I'm trying to create a function in VBA to replace all occurences of "<br>" in a table with a carriage return.

Could anyone help me with this?

Thanks in advance for any help!
0
Comment
Question by:siono2
2 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 2000 total points
ID: 18760171
why not just use an sql statement

update tableName set tableName.fieldName = replace(tableName.fieldName, "<br>", vbcrlf)
0
 

Author Comment

by:siono2
ID: 18760237
because I'm not bright enough to think of such solutions! Thanks for the help!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

607 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