Query based on a form

[John]

Hi,
I have a small database of news items about different types of sporting
events for local counties. I have about 900 records mostly based on
newspaper reports. I now want to have a form with drop-down boxes which will
allow me to select dates between which different types of events occured in
specific counties.

For example....show me all the records in the database which detail soccer
matches in Orange county between Janurary and March 2005. I am thinking
.....a form with input boxes "Date From ,Date To, County , Type of Sporting
Event,". I know how to do the basic form design, but need help deciding what
type of objects to use, eg. text boxes, combo boxes,etc. and most
importantly.....what criterion do I need to attach to each object.

When I press enter after selecting the criteria I need the form to return a
report based on that chosen criteria.
Tia, John

 

[Guest]

Hi John,

If you send me a private e-mail message, with a valid reply-to address, I
will send you two QBF (Query by Form) samples. Both samples build the WHERE
portion of a SQL statement on-the-fly. You'll need to be somewhat comfortable
working with VBA code in order to work with these samples.

Please do not post your e-mail address (or mine) to a newsgroup reply. Doing
so will only invite the unwanted attention of spammers. My e-mail address is
shown on the bottom of the contributors page indicated in my signature block.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi,
I have a small database of news items about different types of sporting
events for local counties. I have about 900 records mostly based on
newspaper reports. I now want to have a form with drop-down boxes which will
allow me to select dates between which different types of events occured in
specific counties.

For example....show me all the records in the database which detail soccer
matches in Orange county between Janurary and March 2005. I am thinking
......a form with input boxes "Date From ,Date To, County , Type of Sporting
Event,". I know how to do the basic form design, but need help deciding what
type of objects to use, eg. text boxes, combo boxes,etc. and most
importantly.....what criterion do I need to attach to each object.

When I press enter after selecting the criteria I need the form to return a
report based on that chosen criteria.
Tia, John

 

[Duane Hookom]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[John]

Hi Duane,
thanks for that, I am looking at it at present and trying to
figure how I can apply it to my problem,
it certainly similar in some respects to what I was tring to do, excep I
would like to be able to type in "To" and "From" dates into boxes and
select both the "County" and "Sports Category" from drop-down lists (because
they are fixed items) whereas dates are constantly being added. I should
have stated that in the first instance, but its just occured to me. Any
further hints are welcome and appreciated. John

 

[Duane Hookom]

Doesn't that version of the query by form allow you to select Between so you
can enter From and To dates? Also, I thought there was a check box that
filled the criteria combo box with all unique values from the field so the
user can make a selection.

I have used and improved the qbf so many times that I don't know which
version is on Roger's site.