Query by Form

[Jeremy]

Does anyone have a link to a good Tutorial/Reference
about creating QBF's as far as the programming side is
concerned? Im trying to create a "Search" capability in a
Database and I think this would be the best method of
achieving the results i desire (supposing i can get it to
work) LoL

Any info would be appreciated!

 

[John Viescas]

Jeremy-

Most of the "big" books on Access -- Using, Bible, Running -- have one or
more examples for creating a custom QBF. You can find examples
(frmXXXSearch) in the Books and Entertain sample databases on my website:

http://www.viescas.com/Info/links.htm#Downloads

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Duane Hookom]

You might want to download the Corp Tech Demos
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. It contains a QBF
applet that dynamically builds a SQL statement based on field selections,
sorting, and criteria.