Apostrophe&'s within an access data

Completed Posted Aug 4, 2003 Paid on delivery
Completed Paid on delivery

Apostrophe’s within an access database

Example Database

Field: UserName

a$ = "Kim's WorkShop"

[url removed, login to view] "UserName = " & chr$(34) & a$ & chr$(34)

The above line does not work...

Can some provide the correct syntax for searching for the a$ above - using [url removed, login to view] ?

Thanks

## Deliverables

1) Just the working source posted is fine.

## Platform

Windows

Engineering Microsoft Microsoft Access MySQL PHP Software Architecture Software Testing Visual Basic Windows Desktop

Project ID: #2959908

About the project

9 proposals Remote project Active Aug 4, 2003

Awarded to:

HGDiaz

See private message.

$1 USD in 14 days
(31 Reviews)
4.8

9 freelancers are bidding on average $7 for this job

TakeRealUK

See private message.

$8.5 USD in 14 days
(552 Reviews)
6.7
tobsvw

See private message.

$21.25 USD in 14 days
(67 Reviews)
6.0
sawamu

See private message.

$8.5 USD in 14 days
(215 Reviews)
5.9
praveenmenonvw

See private message.

$6.8 USD in 14 days
(88 Reviews)
5.7
arcan08

See private message.

$4.25 USD in 14 days
(28 Reviews)
3.4
russellsmithvw

See private message.

$3.4 USD in 14 days
(23 Reviews)
3.4
impactwebgroup

See private message.

$6.8 USD in 14 days
(4 Reviews)
2.5
ex3000

See private message.

$4.25 USD in 14 days
(6 Reviews)
0.8
satwizard

See private message.

$8.5 USD in 14 days
(0 Reviews)
0.0