Dear friend
Searching it is ok now,
That is great for searching with any part of word,
I have more questions can I ask or post new.
How I make the Form3 and Query no one can change
Properties except me?
____________________________________________
-----Original Message-----
Change the criterion expression in the query to this:
Like "*" & [Forms]![Form3]![TCityN] & "*"
This will make your query search for all records that
have any part of what
you enter in the TCityN textbox.
If you just want to search for things that begin with
what you type:
Like [Forms]![Form3]![TCityN] & "*"
--
Ken Snell
<MS ACCESS MVP>
Thank you so much, you gave me enough answers, I
appreciated to you.
Now everything is all right. And I am happy to get
instruction from you.
I am sorry my English is not so good.
Excuse me!
Now I can search by complete name, can you help me with
this; reach by half name or letter for city name?
______________________________
-----Original Message-----
Replace
Me.Requery step
with
Me.Requery
You don't need the step text.
--
Ken Snell
<MS ACCESS MVP>
thank you so much MR Ken Snell
I reach this page and I make as you said but when I
click
compile error:
wrong number of arguments or invalid property
assignment.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Form3"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command6_Click:
Me.Requery step
Exit Sub
Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click
End Sub
_____________________________________
-----Original Message-----
You're trying to put the code step in the box next
to
the
OnClick event in
the Properties window. That is not the correct
location
for it.
Clear this code step from that box. Then click on
the
dropdown arrow and
select [Event Procedure] from the list. Then click
on
the "..." box next to
this box. Visual Basic Editor will open for you and
will
show three lines:
Private Sub cmdButtonName_Click()
End Sub
where cmdButtonName will actually be the name of
your
command button. The
cursor will be on the blank second line.
On that second line, type the Me.Requery step.
Then close VBE and save the form. It then should
work
for
you when you click
the button when in forms view.
--
Ken Snell
<MS ACCESS MVP>
When I copy and paste this expression:
Me.Requery on
the
command button's OnClick event or on the TCityN
textbox's
then open the form and write on the textbox TCityN
then
enter I get error message as:
(((Microsoft Access can't find the macro 'Me.'
the macro(or its macro group) doesn't exist or the
macro
is new but hasn't been saved.
note that when you enter the
macrogroupname.macroname
syntax in an argument, you must specify the name
the
macro's macro group was last saved under))).
note
I didnot create any macro
_________________________________
-----Original Message-----
To run the query, you must tell it to run. It
doesn't
know to do that
otherwise.
I am assuming that Form3 is displaying the
results
of
the
query as its
recordsource. With this assumption, you can put
the
following line of code
on the command button's OnClick event, or on the
TCityN
textbox's
AfterUpdate event:
Me.Requery
If you use the textbox's AfterUpdate event, then
the
query will run when you
"leave" the textbox (pressing Enter, pressing
Tab,
or
clicking into another
control) after you've entered the value.
--
Ken Snell
<MS ACCESS MVP>
I used this expression: [Forms]![Form3]!
[TCityN],
now it
open without box asking but when I write in the
textbox
(TCityN) then enter or tab I don't get
information.
YES I plan to call the query? Using a command
button
on
Form3,
and I want it to run after the user enters a
value
into
TCityN and then presses
Tab or Enter or clicks on another control to
get
information.
________________________________________
-----Original Message-----
Form3 MUST be open when the query runs if you
use
the
[Forms]![Form3]![CityN] as the criterion.
This most recent answer says that the name of
your
text
box is TCityN. Your
original post said it was CityN, which is why
I
gave
you
the example that I
did.
If indeed the textbox is TCityN, then use this
expression:
[Forms]![Form3]![TCityN]
How do you plan to call the query? Using a
command
button
on Form3? Do you
want it to run after the user enters a value
into
TCityN
and then presses
Tab or Enter or clicks on another control?
--
Ken Snell
<MS ACCESS MVP>
$a001280a@phx.gbl...
yes i tried in two way sometime open and
sometime
close
the Form3 and it run ok by box ask me to
enter
parameter
value ( entre city name ) or([Forms]!
[Form3]!
[CityN])
but i don't want inquiry by open the query,I
want
make
inquiry by writing in the text box
names "TCityN"
in
the
form.
__________________________
-----Original Message-----
Is Form3 open when the query is being run?
--
Ken Snell
<MS ACCESS MVP>
$a401280a@phx.gbl...
I tried two query first criteria [Enter
city
name]
in "CityN" field for city name and second
[Forms]!
[Form3]!
[CityN].but still the problem.
if you can receive the form I will send
it
to
you
-----Original Message-----
I cannot see your setup. Describe what
you're
using,
what
actions you take,
etc. Post the SQL statement of the
query.
--
Ken Snell
<MS ACCESS MVP>
message
$a601280a@phx.gbl...
thanks
I changed it but the still the same
problem
------
-----Original Message-----
Change the
[Enter city name]
to
[Forms]![Form3]![CityN]
Be sure that Form3 is open when the
query
runs.
--
Ken Snell
<MS ACCESS MVP>
message
$a501280a@phx.gbl...
I have table names "TableAreaCod"
contain
fields
as:
CountryN: for country name
CityN : for city name
CountryC: for country code
CityC : for city code
Rate : for price each minute
Discount : for discount and time of
discount
I have query names "Query2"
created by
previous
table "TableAreaCod" , the
criteria
in
the
CityN
field
[Enter city name]
And I have form names "Form3" ,
record
source "Query2"
My Question
When I open query or form always
come
box
ask
me
to
enter
the city name it is ok query but I
like
without
ask
I
want make inquiry by writing city
name
in
the
text
box "CityN"in the form
.
.
.
.
.
.
.
.
.
