In it I have a table named DEADLINES. In the table DEADLINES, I have a field named ACTIONDUE.
I want VBA (visual basic) code to go through the field ACTIONDUE and make the following changes.
Search for the word "REQ" and replace it with REQUEST (Anywhere in the field)
Search for the word "REISSUE DL" and replace it with "REISSUE DECLARATION" (Whole field)
I'd prefer to do this using VBA instead of in SQL because I have about 75 changes to make.
This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…