A question about parameter queries

[Guest]

I am creating a simple database and am trying to figure out how to make this
easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for someone to
be able to enter the make, model, and year, and get a list of vehicles that
fall into these parameters. I am running off of VERY basic knowledge that I
pretty much figured out through trial and error. Any help would be greatly
appretiated.

 

[Rick B]

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B

 

[Rick B]

Note that YEAR is a reserved word. Hopefully you did not name your field
"Year". You can use the word in your parameter since that is simply test
that the user will see, but Name your field something else.

Rick B

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B

I am creating a simple database and am trying to figure out how to make this
easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for someone to
be able to enter the make, model, and year, and get a list of vehicles that
fall into these parameters. I am running off of VERY basic knowledge

that

I
pretty much figured out through trial and error. Any help would be greatly
appretiated.

 

[Guest]

Rick that worked perfectly. Now...can make a shortcut to this query so that
the person won't have to look for it on the database menu? Some of the people
that will be using it aren't exactly computer literate. Basically, can I make
a desktop shortcut for this query that would activate the prompts and then
show the data, or is that not possible?

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B

I am creating a simple database and am trying to figure out how to make this
easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for someone to
be able to enter the make, model, and year, and get a list of vehicles that
fall into these parameters. I am running off of VERY basic knowledge that I
pretty much figured out through trial and error. Any help would be greatly
appretiated.

 

[Rick B]

I don't think you can make a shortcut to a specific query outside of ACCESS.
You could create a switchboard and hide the database window so that the
first thing to pop up is a nice menu that you have built. It could contain
a button for each task you wish your users to perform.

Rick B

Rick that worked perfectly. Now...can make a shortcut to this query so that
the person won't have to look for it on the database menu? Some of the people
that will be using it aren't exactly computer literate. Basically, can I make
a desktop shortcut for this query that would activate the prompts and then
show the data, or is that not possible?

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B

I am creating a simple database and am trying to figure out how to

make
this

easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for

someone
to

be able to enter the make, model, and year, and get a list of vehicles that
fall into these parameters. I am running off of VERY basic knowledge

that
I

pretty much figured out through trial and error. Any help would be greatly
appretiated.

 

[Guest]

LOL Alright that sounds complicated, and I'm not going to ask you to explain
all that. Thank you for all your help

I don't think you can make a shortcut to a specific query outside of ACCESS.
You could create a switchboard and hide the database window so that the
first thing to pop up is a nice menu that you have built. It could contain
a button for each task you wish your users to perform.

Rick B

Rick that worked perfectly. Now...can make a shortcut to this query so that
the person won't have to look for it on the database menu? Some of the people
that will be using it aren't exactly computer literate. Basically, can I make
a desktop shortcut for this query that would activate the prompts and then
show the data, or is that not possible?

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B






I am creating a simple database and am trying to figure out how to make
this
easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for someone
to
be able to enter the make, model, and year, and get a list of vehicles
that
fall into these parameters. I am running off of VERY basic knowledge that
I
pretty much figured out through trial and error. Any help would be greatly
appretiated.

 

[John Spencer (MVP)]

Actually, you can make a shortcut for the query. Not a good idea in my opinion,
but you can do it.

Open up the database, go to the query in the database window, drag and drop to
desktop or whereever....

Rick that worked perfectly. Now...can make a shortcut to this query so that
the person won't have to look for it on the database menu? Some of the people
that will be using it aren't exactly computer literate. Basically, can I make
a desktop shortcut for this query that would activate the prompts and then
show the data, or is that not possible?

The easiest way would be to create a query with all the fields you want to
show the user.

Under the "MAKE" field, enter something similar to the following in the
criteria square...

= [Enter MAKE to search]

Under the MODEL enter...

= [Enter MODEL to search]

Under the year...

= Enter four-digit YEAR to search]

When you run it, it should do what you want.




Now, What if they leave a field blank? What if they only want to enter SOME
of the criteria? To make this possible, change the above to...

Like [Enter MAKE or blank for all] & "*"

Like [Enter YEAR or blank for all] & "*"

Like [Enter MODEL or blank for all] & "*"

This will also let them enter a partial make, model, or year (if year is
simply a text field). For example, entering "F-" in the model would give
you F-150s and F-250s and F-350s.


You can also let them make a partial entry ans search WITHIN the field.
What if you want to find all Models that contain an "x" anywhere in the
model?

You would change your criteria to...

Like "*" & [Enter MAKE or blank for all] & "*"
Like "*" & [Enter MODEL or blank for all] & "*"


Personally, I'd select the last option for the make and model, and I'd use
the second option for Year.


Hope that helps,

Rick B

I am creating a simple database and am trying to figure out how to make this
easily searchable. I have 6 categories :Make, Model, Year, Engine,
Transmission, Transmission weight. I am trying to make a way for someone to
be able to enter the make, model, and year, and get a list of vehicles that
fall into these parameters. I am running off of VERY basic knowledge that I
pretty much figured out through trial and error. Any help would be greatly
appretiated.