problems with "like" 1

[patrysib]

I want to search a name in a database, but not whole name, only a part. I put in query the condition: (BAZA.NUME) Like '*me.forms!main!nume*. Main is my form where I type the name, and my table is baza. The query is not returning any row, only an empty one.

 

[TheAceMan1]

GHow are ya patrysib . . .

Perhaps:

[blue]Like "*" & Forms!Main!Nume & "*"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[patrysib]

tnk. it works!

 

[TheAceMan1]

patrysib . . .

Great! . . . Be sure you understand [blue]why it works[/blue] or you'll have many more bouts with this type of syntax issue!

See Ya! . . . . . .

Be sure to see thread181-473997

 

[patrysib]

I have a database witn 3 tables. the access at this tables is restricted. I can't open them. Ther is a program who cam help me? Or what can I do to have administrator rights?

 

[HarleyQuinn]

Who set the access to the database? Why is it set so you can't view/edit tables?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

what can I do to have administrator rights?
Ask your DBA (DataBase Administrator)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886