Microsoft Office Access 2003  for PC
Problem for Microsoft Office Access 2003 (077-02871) for PC

Macro solution to search for character within a text string.




By keithbaskett on Apr 25, 2009

" "
Access 2000 Macro solution wanted. I have created a macro that looks at an address field (43 Oxford St)and reads the last two characters entered to complete the address. For example if the last two characters are 'ro' it adds 'ad' to read road. Similarly 'st' would be concatenated with reet' to read street. This works well but there are some two letter sets that have multiple endings, e.g. 'gr' could mean 'grove' or 'green', ['me' = 'mews' or 'meadow']. In the underlying lookup table for these scenarios I have entered 'ove/green' [ws/meadow] as the text to be concatnated. Now I want to alert the person entering the data to select one of the options offered and delete that which does not apply. To do this I need to be able to search for a '/' somewhere in the text string and should one be found have a warning message pop up. If I could use a query I might be able to use Like "*/" but I can not find an equivalent in the macro formula. Anybody got any ideas. In anticipation of your help, thank you.

Solution #1

posted on May 27, 2009
Not Rated)

AccessHelp

Rank: Wiz 
Rating: 79%, 24 votes
Use Instr: If (Instr(yourString, "/")) then ...
Was this helpful?
Yes
No

Popular Solutions for Microsoft Office Access 2003


Questions and Unsolved Problems for Microsoft Office Access 2003


Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer

Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file... (More)

Answer
I am getting the message "Module not found" after deleting a form that I no longer use... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Access 2003 ...:

Top Business and Pro... Experts

Rank: Guru Guru  

Solutions: 1454
Member Since: July 2009

Experience: I have owned a computer networking sales and service company.

Ask Me
Find more Business and Pro... Experts

Top Computer & Laptop Repair

(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com

(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

X
Continue
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!
Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select