Search Box

[Al Campagna]

Shakeel,
On my website below, I have a sample file called Quick Find Combo, which allows the
user to enter a value, and go to that record for editing.
Combo boxes have a property called Auto Expand, and when set to Yes, drills down
through you combo choices as you type.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Shakeel Ahmad]

I have completed a database of School. Now I want to make a search box on my
main form. there are 3-thousand students almost. now when a student comes
and i want to either check/enter his progress or check/submit his fee. How
will i walkthrough the Data of hundreds of Students. I want a search box
where i will enter the name (first of last) and it show me the entries same
like my search and i could go to the record.
----------------------------------------
otherwise
------------->>>>>>
when a student comes to me: I will enter in Student Name's box the name of
student>>> at that time it should work like this::::

for example the name of Student is "Ahmed"

now when i write "A" it should show a list of all names starting with "A" as

Abbas
Anthony
Ahmad
Andrew
Ali .. etc... and when i writ the second letter "h" it will be "Ah"
so now in the list it should show the names starting with "Ah" and so
on.......

is this possible?

(Shakeel Ahmad)



--
Best Regards

Shakeel Ahmad

(e-mail address removed)
www.groups.yahoo.com/group/islam-the-final-truth
www.geocities.com/shakeelahmad_79

 

[Shakeel Ahmad]

This time i am working on this database but my internet connection have some
limitations.

here in Pakistan it is now 7:10 PM and after 5:00 PM my administrator has
stoped downloading.

so i can't download the zip file that you told me. pls help me in someway
else.

best regards,
Shakeel Ahmad

 

[Allen Browne]

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

(There's actually a combo box wizard that writes this code for you if you
can't get to the websites we suggest, though it's code is not a good
example.)

 

[Al Campagna]

I assume you have email...
I sent you both the A97 file and the A2003 file, to the address on your post. So far, it
hasn't kicked back.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[CoachBarkerOJPW]

This is the code and instructions I got from the forum a couple of years ago
from one of the experts here, couldn't tell you now who it was but am glad to
pass it on.

Add an Unbound combo box to your form and change the word Player to what you
need

Name it cboFindPlayerID

In the All Properties window set
Row Source Type Table/Query
Row Source Select Query from your students table
Column Count 2
Column Heads Yes
Width 0â€; 1â€
Bound Column 1

Limit to List Yes
Expand Yes

Under Event Tab
After Update Click the ellipse and create an event procedure

Add this code

Option Compare Database
Option Explicit
Private Sub cboFindPlayerID_AfterUpdate()
DoCmd.GoToControl "PlayerID" ‘(name of whatever control you use to store
Primary key for student)
DoCmd.FindRecord cboFindPlayerID
DoCmd.GoToControl "PlayerName" ‘(or whatever your control is that has
the students’ name that you want to use)
End Sub

Hope this helps if you can not link to either site

CoachBarkerOJPW

 

[Shakeel Ahmad]

Thanks Alot.

I have done it.

Al Campagna has sent me two attached files which I tried on my database but
one thing was very difficult to understand. in the row source there were a
code (Select tblNames.RecordID, [LastName]& "," &[FirstName]....and so
on.....

i understood this code with some efforts.
but when coachBarkerOJPW sent me msg and there i learnt, it can be done
simply by selecting quesry from my students table.

but i have learnt both of the methods, thanks you very much (both of you "Al
& Coach")

hope i will get help and Assistance from you in future...

 

[Shakeel Ahmad]

can i use this method (combo quick find) within a new form.

I dont want to make this combo box on the main form.
i want to make a button on the main for with the caption "search by name"
and when this button will be clicked, a new popup form will be opend and
that form will contain a combo box, when i would enter name in that combo
box, that should be closed and the searched result should be come to the
main form.

Thanks Alot.

I have done it.

Al Campagna has sent me two attached files which I tried on my database
but one thing was very difficult to understand. in the row source there
were a code (Select tblNames.RecordID, [LastName]& "," &[FirstName]....and
so on.....

i understood this code with some efforts.
but when coachBarkerOJPW sent me msg and there i learnt, it can be done
simply by selecting quesry from my students table.

but i have learnt both of the methods, thanks you very much (both of you
"Al & Coach")

hope i will get help and Assistance from you in future...

I assume you have email...
I sent you both the A97 file and the A2003 file, to the address on your
post. So far, it hasn't kicked back.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[CoachBarkerOJPW]

I have not done it that way, but you should be able to by referencing the
form ypu want to search as well as the the control.

can i use this method (combo quick find) within a new form.

I dont want to make this combo box on the main form.
i want to make a button on the main for with the caption "search by name"
and when this button will be clicked, a new popup form will be opend and
that form will contain a combo box, when i would enter name in that combo
box, that should be closed and the searched result should be come to the
main form.

Thanks Alot.

I have done it.

Al Campagna has sent me two attached files which I tried on my database
but one thing was very difficult to understand. in the row source there
were a code (Select tblNames.RecordID, [LastName]& "," &[FirstName]....and
so on.....

i understood this code with some efforts.
but when coachBarkerOJPW sent me msg and there i learnt, it can be done
simply by selecting quesry from my students table.

but i have learnt both of the methods, thanks you very much (both of you
"Al & Coach")

hope i will get help and Assistance from you in future...

I assume you have email...
I sent you both the A97 file and the A2003 file, to the address on your
post. So far, it hasn't kicked back.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


This time i am working on this database but my internet connection have
some
limitations.

here in Pakistan it is now 7:10 PM and after 5:00 PM my administrator
has
stoped downloading.

so i can't download the zip file that you told me. pls help me in
someway
else.

best regards,
Shakeel Ahmad

Shakeel,
On my website below, I have a sample file called Quick Find Combo,
which allows the user to enter a value, and go to that record for
editing.
Combo boxes have a property called Auto Expand, and when set to Yes,
drills down through you combo choices as you type.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I have completed a database of School. Now I want to make a search box
on my main form. there are 3-thousand students almost. now when a
student comes and i want to either check/enter his progress or
check/submit his fee. How will i walkthrough the Data of hundreds of
Students. I want a search box where i will enter the name (first of
last) and it show me the entries same like my search and i could go to
the record.
----------------------------------------
otherwise
------------->>>>>>
it can be done by this way:

when a student comes to me: I will enter in Student Name's box the
name of student>>> at that time it should work like this::::

for example the name of Student is "Ahmed"

now when i write "A" it should show a list of all names starting with
"A" as

Abbas
Anthony
Ahmad
Andrew
Ali .. etc... and when i writ the second letter "h" it will be
"Ah" so now in the list it should show the names starting with "Ah"
and so on.......

is this possible?

(Shakeel Ahmad)



--
Best Regards

Shakeel Ahmad

(e-mail address removed)
www.groups.yahoo.com/group/islam-the-final-truth
www.geocities.com/shakeelahmad_79

 

[Al Campagna]

Shakeel,

can i use this method (combo quick find) within a new form.

Yes, it can be used on any form.

i want to make a button on the main for with the caption "search by name"...
a new popup form will be opend....

Creating another form (pop up) just to look up a record is really a bit of "overkill."
I'm sure if you're an experienced Access user, you can alter my code to make that work.
Good Luck...
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

can i use this method (combo quick find) within a new form.

I dont want to make this combo box on the main form.
i want to make a button on the main for with the caption "search by name" and when this
button will be clicked, a new popup form will be opend and that form will contain a
combo box, when i would enter name in that combo box, that should be closed and the
searched result should be come to the main form.

Thanks Alot.

I have done it.

Al Campagna has sent me two attached files which I tried on my database but one thing
was very difficult to understand. in the row source there were a code (Select
tblNames.RecordID, [LastName]& "," &[FirstName]....and so on.....

i understood this code with some efforts.
but when coachBarkerOJPW sent me msg and there i learnt, it can be done simply by
selecting quesry from my students table.

but i have learnt both of the methods, thanks you very much (both of you "Al & Coach")

hope i will get help and Assistance from you in future...

I assume you have email...
I sent you both the A97 file and the A2003 file, to the address on your post. So far,
it hasn't kicked back.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


This time i am working on this database but my internet connection have some
limitations.

here in Pakistan it is now 7:10 PM and after 5:00 PM my administrator has
stoped downloading.

so i can't download the zip file that you told me. pls help me in someway
else.

best regards,
Shakeel Ahmad

Shakeel,
On my website below, I have a sample file called Quick Find Combo, which allows
the user to enter a value, and go to that record for editing.
Combo boxes have a property called Auto Expand, and when set to Yes, drills down
through you combo choices as you type.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I have completed a database of School. Now I want to make a search box on my main
form. there are 3-thousand students almost. now when a student comes and i want to
either check/enter his progress or check/submit his fee. How will i walkthrough the
Data of hundreds of Students. I want a search box where i will enter the name (first
of last) and it show me the entries same like my search and i could go to the
record.
----------------------------------------
otherwise
------------->>>>>>
it can be done by this way:

when a student comes to me: I will enter in Student Name's box the name of
student>>> at that time it should work like this::::

for example the name of Student is "Ahmed"

now when i write "A" it should show a list of all names starting with "A" as

Abbas
Anthony
Ahmad
Andrew
Ali .. etc... and when i writ the second letter "h" it will be "Ah" so now
in the list it should show the names starting with "Ah" and so on.......

is this possible?

(Shakeel Ahmad)



--
Best Regards

Shakeel Ahmad

(e-mail address removed)
www.groups.yahoo.com/group/islam-the-final-truth
www.geocities.com/shakeelahmad_79