Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / February 2008

Tip: Looking for answers? Try searching our database.

Parameter Query Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PA - 15 Feb 2008 20:47 GMT
I have created a series of Parameter Queries in a db (Access 2003), using the
square brackets [  ]  to fill - in a Criteria.  How can I specify the maximum
number of characters allowed in the fill-in box, for example we have state as
two characters, MD, PA, Ca in the tables and wish to limit the characters in
the fill-in box to match the field size.

Thanks
Paul
Conan Kelly - 15 Feb 2008 21:05 GMT
PA,

You can't.

Your only option for that (and a much better way to go) is to create a form.
Put a textbox on the form.  Set the appropriat properties on the form to
limit the number of characters.  I would also put a button on your form that
will run/open your query.  Then change the criteria in your query to point
to the form instead of asking for input.  You would do that by changing your
parameter [prompt text that was entered] to [Forms]![FormName].[TextBoxName]
(I think that syntax is correct...I can never remember the placementes of
the !'s and .'s...this would need to be verified if you want to use this
method).  You don't need to put a button on the form to run the query but it
helps.  Although the form does need to be open when the query is run/opened.
You can program the button to hide the form so it is not in front of your
data,

Another option would be to put a list/combo box on your form and have its
source be a table/query of all possible values (or type in all possible
values into the appropriate properties).  Then it is just a matter of
selecting the option you want from the list and clicking the button to run
the query.

HTH,

Conan

>I have created a series of Parameter Queries in a db (Access 2003), using
>the
[quoted text clipped - 8 lines]
> Thanks
> Paul
Duane Hookom - 15 Feb 2008 21:14 GMT
http://www.tek-tips.com/faqs.cfm?fid=6763
Signature

Duane Hookom
Microsoft Access MVP

> PA,
>
[quoted text clipped - 35 lines]
> > Thanks
> > Paul
Conan Kelly - 15 Feb 2008 21:46 GMT
Ahhh....

Grassy-a.s, Seen-yor Hookom

> http://www.tek-tips.com/faqs.cfm?fid=6763
>
[quoted text clipped - 48 lines]
>> > Thanks
>> > Paul
PA - 16 Feb 2008 12:47 GMT
Ahhh....

Grassy-a.s, Seen-yor Hookom y Seen-yor Kelly

> Ahhh....
>
[quoted text clipped - 52 lines]
> >> > Thanks
> >> > Paul
Conan Kelly - 18 Feb 2008 17:28 GMT
Da nada.

Glad to help.

> Ahhh....
>
[quoted text clipped - 66 lines]
>> >> > Thanks
>> >> > Paul
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.