0

The question I am going to ask involves Mircrosoft Access and VB and I am stuck with it.

This is the question:

I have 4 peoeple: L, M, N, O, P
there are 4 object: a, b, c, d, e

L has: a, c, d
M has: a, d, e
N has: b, d, e
O has: b, c. d

If I change the a to another name call 'z', I want onli L and M to change as well.

Is there any code which I can use?

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by AndreRet
0

Yes there is. It will be something along these lines -

MyRS.Open "SELECT * FROM MyTable WHERE MyObject LIKE 'a%'", MyConnection, adOpenstatic, adLockoptimistic

Edited by AndreRet: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.