Comparisons - Microsoft Access / VBA

Hi,

Can someone tell me if this is possible? I have 2 fields in an Access 2000
db - one is the product name, the other is the product description. If the
product name is contained in the product description, I put bold tags around
it ( ). Would it be possible to do that with a query or some kind of
expression or something else? So that it could be done automatically. I have
to go through several 100 or 1000 new products per month!

Thanx!

Apr 20 '06 #1

Subscribe Reply

1186

Rick Brandt

JA wrote:

Hi,

Can someone tell me if this is possible? I have 2 fields in an Access
2000 db - one is the product name, the other is the product
description. If the product name is contained in the product
description, I put bold tags around it ( ). Would it be
possible to do that with a query or some kind of expression or
something else? So that it could be done automatically. I have to go
through several 100 or 1000 new products per month!
Thanx!

Quick attempt tested on three entries with the ProductName appearing at the
beginning, middle, and end of the ProductDescript ion. The WHERE clause it just
to filter out rows where this has already been done before.

UPDATE Products
SET Products.Produc tDescription =
Mid([ProductDescript ion],1,InStr(1,[ProductDescript ion],[ProductName])-1) &
"" &
Mid([ProductDescript ion],InStr(1,[ProductDescript ion],[ProductName]),Len([ProductName]))
& "" &
Mid([ProductDescript ion],InStr(1,[ProductDescript ion],[ProductName])+Len([ProductName]))
WHERE (((Products.Pro ductDescription ) Not Like "**"));

(Please try first on a test copy of your table)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Apr 20 '06 #2

arthurjr07

Update Product Set ProductDesc = " " & ProductDesc & "" where
ProductID in (SELECT ProductID FROM Student where ProductID =
ProductDesc)

Apr 20 '06 #3

PC Datasheet

Check out the Instr function in the Help file. It will do what you want.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdata sheet.com
"JA" <ja*****@kc.rr. com> wrote in message
news:pA******** *******@tornado .rdc-kc.rr.com...

Hi,

Can someone tell me if this is possible? I have 2 fields in an Access 2000
db - one is the product name, the other is the product description. If the
product name is contained in the product description, I put bold tags
around it ( ). Would it be possible to do that with a query or some
kind of expression or something else? So that it could be done
automatically. I have to go through several 100 or 1000 new products per
month!

Thanx!

Apr 20 '06 #4

PleaseStopAdvertising

"PC Datasheet" <fa***@email.co m> wrote in message
news:nd******** *********@newsr ead2.news.atl.e arthlink.net...

Check out the Instr function in the Help file. It will do what you want.

No. No it won't.

To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Apr 20 '06 #5

Similar topics

1583

Removing language comparisons

by: A.M. Kuchling | last post by:

python.org has a page of "Python vs. X" language comparisons at <http://www.python.org/doc/Comparisons.html>. They're all pretty outdated, and often unfair because they're written by a person who knows Python well but has only a nodding acquaintance with language X. I'm planning to drop this page from python.org because it's so outdated and no one is around to maintain it. If anyone wants to grab the contents and turn them into a Wiki...

Python

1185

Fw: Removing language comparisons

by: Mike Rovner | last post by:

Mike Rovner wrote: > A.M. Kuchling wrote: >> python.org has a page of "Python vs. X" language comparisons at >> <http://www.python.org/doc/Comparisons.html>. They're all pretty >> outdated, and often unfair because they're written by a person who >> knows Python well but has only a nodding acquaintance with language >> X. >> >> I'm planning to drop this page from python.org because it's so >> outdated and no one is around to maintain...

Python

1508

Inconsistency in Python's Comparisons

by: Dietrich Epp | last post by:

Without invoking double-underscore black magic, it is possible to choose a, b, and c in Python such that: a >> class t(object):

Python

3410

sorting K+1 vectors with NlogN comparisons not (K+1)NlogN

by: Pratyush | last post by:

Hi, Suppose there is a vector of objects of class A, i.e., std::vector<A> vec_A(N); The class A satisifies all the STL vector requirements. Now I wish to add some attributes for each of the objects in the vector vec_A. Suppose there are K attributes to be added. For each of the attributes I define K vectors of appropriate types. Say, the attributes have types type1, type2, ..., typeK. So I define std::vector<type1> attr1(vec_A.size());

C / C++

4598

merge sort #of comparisons

by: Kevin King | last post by:

I have a question about an assignment I have. I need to count the number of comparisons in my merge sort. I know that the function is roughly nlog(n), but I am definately coming up with too many comparisons. It seems to me like I should just use a single counter in the merge function's 'if' statement, but this can't be right because an array of 50 takes about 100 comparisons this way. If anyone has any suggestions I would greatly...

C / C++

1560

Requirements of floating point comparisons

by: Peter Ammon | last post by:

I'm fuzzy on exactly what I can depend on when doing floating point comparisons. I know that calculated values can differ, e.g. I'm not guaranteed that 1. + 2. == 3. What about comparisons with literals? float f=3.; int v = f==3.; is v guaranteed to be one? What about situations involving conversions

C / C++

1533

Boxing causing problem during comparisons

by: Aamir Mahmood | last post by:

Hi I am on framework version 1.1 (SP1). Consider the following code. public static void Main() { int i=1; int j=1;

C# / C Sharp

1394

coding tip to prevent comparisons becoming assignments

by: Jim Michaels | last post by:

This is a simple coding tip I learned to prevent comparisons from becoming assignments (and this becoming a hair-pulling session during debugging): in comparisons, try to put your constants on the left hand side of the operator and variables on the right hand side. example if (3==$x) { //do something }

PHP

1815

Delegate comparisons

by: Quimbly | last post by:

I'm having some problems comparing delegates. In all sample projects I create, I can't get the problem to occur, but there is definitely a problem with my production code. I can't give all the code, as there's simply too much, but here's the general gist: I have a connection object which connects to a custom back-end server of one type or another. Clients of this connection object send requests via a method (e.g....

.NET Framework

1660

XPath String Value Comparisons

by: Nishad | last post by:

Is anybody know how to write xpath for string Value Comparisons thank you

.NET Framework

8421

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8844

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8621

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7354

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6177

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5643

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4330

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2743

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1734

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General