By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Need Help around

P: n/a
HI all:
i hope that every body is just well fine 'cause i need a little help
around:
well i m trying (it's my first try) to work on the MS.Office Access....
i have build all the tables and the form and every thing i need but i
need to know if i can make a form that allow me to search all the data
that i have entred in the data base ....
i don't know if you got what i mean for example i have a value called
"SONG" can i create a form that allows to search for this value?!
thanks for you replies sooooo much
peace

Jan 17 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
kreepsss, that's much too much and just too very very

I suggest buying a book, and starting on page 1. There's just no way to
answer that question.

but if that is too much, try: ctrl + f

Jan 17 '06 #2

P: n/a
listen u didn't got my point i mean if i can create for example a text
box and enter for example the name of a contact and then next to it
press search and when i press search it will give me then a list of
matching values... for example :
i have a text box where i insert Mario.... and i press search ... the
result will be for example all the name which start with M, A & R....
i don't know if u got my point of view...
i am thanksfull for your re-ply :D

Jan 18 '06 #3

P: n/a
yes, it's very possible - there are quite a few approaches to it
aswell, ranging in complexity from ctrl + f to a vb search looping
through multiple recordsets. but you need to be more clear about what
or rather "Where" you are searching. is it just one field? or are you
looking to search through all the the fields on a bound form - or all
the fields in all the records of a bound form? is the search button on
the form you are searching - or are you indeed searching through tables
and returning multiple matches in a query format???

Anyway, I am guessing that the command "DoCmd.findNext ..." will
probably get you where you want to go if your search is to be form based

Jan 18 '06 #4

P: n/a
I would like to thank for you work and replies in fact i found a way
that allows me to do what i am thinking about ... i created a table
containing the following :
ID, Song Name, Artist, Album, Genre.
then from this table i created a QUERY where i have inserted the
following values from the table above and under the value of SONG NAME
in critica i wrote Like "*" &[Which Song Do You Want?]& "*", then i
transformed the Query into a form ... and this was what i wanted to
create :D
@ last i knew how!
thank for your replies
kreps

Jan 25 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.