Personal computing discussed

Moderators: SpotTheCat, Nemesis

 
commander2004
Gerbil In Training
Topic Author
Posts: 2
Joined: Fri May 17, 2002 11:42 am

Searching a SQL/ Access database ??

Fri May 17, 2002 11:50 am

Hi,
I need a search formular to search my sql/ access database with special atributes !!
is it possible to realize something like that with sql or even better access ??
For examble I got a tabel with
name
genre
language

I give an attribute of my chose(for examle name) and get displayed the other parameters !!

thx
 
Coldfirex
Graphmaster Gerbil
Posts: 1116
Joined: Wed Dec 26, 2001 7:00 pm
Location: College Station, TX
Contact:

Fri May 17, 2002 12:17 pm

are you asking for the sql code for a query under access?

ohya, wrong forum
Your bargaining posture is highly dubious.
 
becubed
Gerbil
Posts: 24
Joined: Fri Dec 28, 2001 7:00 pm
Location: Melbourne Australia

Re: Searching a SQL/ Access database ??

Fri May 17, 2002 6:16 pm

commander2004 wrote:
Hi,
I need a search formular to search my sql/ access database with special atributes !!
is it possible to realize something like that with sql or even better access ??
For examble I got a tabel with
name
genre
language

I give an attribute of my chose(for examle name) and get displayed the other parameters !!

thx


Open Access, create a new query, click on the view menu and select SQL view. Type in the following. Select * from Table where Name = [EnteredName];

Table should be the name of the table that you are using.
When this is run it will prompt you for a value for EnteredName.

becubed
 
IntelMole
Grand Gerbil Poohbah
Posts: 3505
Joined: Sat Dec 29, 2001 7:00 pm
Location: The nearest pub
Contact:

Specifics?

Fri May 17, 2002 7:06 pm

You wanna search/ view results in a table or form?

I've got a CPU parts database that I did for a school project kicking about somewhere, I'll dig that out and remember how I did it all...

But basically, if you wanna use buttons and stuff to search through a table, make the search criteria the item you're using to search (drop-down box, text box etc.)

I can't remember the exact syntax, but it should read something like this:

=[forms]![FormName]![SearchBoxName]

That way, it's more fun and easier to do multiple searches...
:-)

Something along those lines,
IntelMole
Living proof of John Gabriel's theorem

Who is online

Users browsing this forum: No registered users and 1 guest