Re: Build a form from SQL
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 02 Aug 2007 11:55:50 -0600
On Thu, 2 Aug 2007 08:50:01 -0700, PJFry <PJFry@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I am reaching the point in my Access development where I want to know how to
build forms off of SQL, rather than doing an Autoform from a query. Can
anyone recommend an online resources for how to do this?
Check the resources at
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
You can easily use the Forms window without wizards. I'd suggest creating a
new Query using your SQL string, and save the query; you can then create a new
Form, and select that query as its record source. You can then use the Toolbox
and the list-of-fields tool to add controls to the form, bound to the query
fields.
John W. Vinson [MVP]
.
- Prev by Date: Re: Place actual selection name in table instead of ID #?
- Next by Date: RE: Show value in one field from another?
- Previous by thread: Re: Place actual selection name in table instead of ID #?
- Next by thread: Re: Build a form from SQL
- Index(es):
Relevant Pages
|
