TR Forums

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

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

ohya, wrong forum

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

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