michael40card

hi there i need a simple piece of code...
what i need to do is enable the user of my data base to search through that data stored in tables from a form
being a total newbie to access (i avoid it because i HATE IT :-s) i have no idea where to begin!

PLEASE HELP

zorin

OK, first you should start by using the Query functon, under the query tab, after you have created a relational database eg..so the query looks through all the tables and the form, google this or try to figure it out yourself "PFO RULES" dont ask ohers to do homework for you

zorin

Oh, Eveything is hard to learn, I hated ms access to but had to study it at college and got the hang of it over a few months. Now its one of my best subjects and im hoping to learn SQL server next

michael40card

I am not asking for people to do it for me, i just want a starting point ie.
what it the term is for tis sort of thing because i have looked in all the resource books in college and the help topics in access and all the search / find functions i can dig up all relate to table searches out side of the form

i would like the user to be able to input a keyword and press a button...and hay presto much like any other search engine but i cant find the code statement...and because of this my program has come to a stand still

please give me a keyword just to start me off please (dont make me beg)

stevengs

Do you really attend college? In an English speaking country? I wouldn't have even pegged you at middle school. Due to the lack of punctuation and extremely shabby sentence structure, I had to read your post a few times before I had a clue as to what you want (and I am still not 100% sure).

__________________
-Steven
"Is this a piece of your brain?" - Basil Fawlty

zorin

I agree with stevengs, so lets get this straight this help you need is in ms access so its not techinally your program and from what I know im pretty sure you dont need code to make this work. And its not a visual basic question so why the hell is it in the Visual Basic forum.

Infinite Recursion

SELECT sounds like a good keyword if you are looking for something in a database.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

michael40card

well i am sorry is my grammer and puntuation insults you (don't even start on my spelling)
i am asking questions in VB forum because access used VB editor and i am more familiar with VB then access
and if i wanted sarcasm, i would have joined:

http://www.king_of_sarcasm.com/my_co...s_you_can.html

my course work is quite important and it just so happens that i would like to do it so can you help me rather then insult me?!

stevengs

Your grammer and punctuation do not insult me. They do make it difficult for us to help you though. Rather than complain about what you feel to be undeserved criticism, why don't you make an attempt to explain the problem better. ( or at least complain AND explain )

So, what is your native tongue?

__________________
-Steven
"Is this a piece of your brain?" - Basil Fawlty

zorin

ok sorry if i insulted you, but if you just take time to read what you write then you will get much better responses and more people will help you (this wasnt to insult you), so hope your next post will be easier to read. Just messin