Searching a SQL/ Access database ??

Enclosures, modding, blowholes, and the power needed to run it all.

Moderators: Nemesis, SpotTheCat

Searching a SQL/ Access database ??

Postposted on 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
commander2004
Gerbil In Training
 
Posts: 2
Joined: Fri May 17, 2002 11:42 am

Postposted on 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.
Coldfirex
Graphmaster Gerbil
 
Posts: 1109
Joined: Wed Dec 26, 2001 7:00 pm
Location: College Station, TX

Re: Searching a SQL/ Access database ??

Postposted on 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
becubed
Gerbil
 
Posts: 24
Joined: Fri Dec 28, 2001 7:00 pm
Location: Melbourne Australia

Specifics?

Postposted on 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
IntelMole
Grand Gerbil Poohbah
 
Posts: 3529
Joined: Sat Dec 29, 2001 7:00 pm
Location: The nearest pub


Return to Cases and Power Supplies

Who is online

Users browsing this forum: Exabot [Bot] and 3 guests