Build a form from SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

I don't have particular project that I need this for at the moment, I just
want to have the skillset to use that option.

I am using 2003 with XP.

Thanks!
PJ
 
You will have to write the SQL in the Row Source property of the form. After
that, it is just like creating any other form.
Just open a new form in design view, select the properties dialog, the Data
tab, and write the SQL in the Row Source property. Than to create a control,
click on the type of control you want, place it on your form, select the
Control Source property on data tab of the properties dialog. You can enter
the name of the field or if you drop the combo down, it will have a list of
available fields.
 
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?
Click to expand...

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]
 
John W. Vinson said:
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]
Click to expand...
 
I'm new at this so bare with me.

I've got a major problem with my Access 2002 that started when I split the
database between the data and the rest of the Access database. When I did
this I had to change a lot of the dlookups on my forms to ADODB queries
because I was getting this "Cannot open any more databases" error. Now I'm
finding that my combo boxes are getting the same error or they are not
returning any data. I think the source of the problem is that my form and
combo boxes are all pulling data through the Jet links to my backend database
an apparently each linkup or query accross the links opens a database. Now
I'm trying to load my forms through ADO to avoid this problem and I am
hitting a dead end.

My application is grinding to a hault and I need it for my business which
may grind to a hault also unless I put the two segments back together which
is going to be a painful process.

My application may have 3 or 4 forms open at any point in time. I use a I
use a lot of Combo boxes. Can someone help me?
 
I've got a major problem with my Access 2002 that started when I split the
database between the data and the rest of the Access database. When I did
this I had to change a lot of the dlookups on my forms to ADODB queries
because I was getting this "Cannot open any more databases" error
Click to expand...

Dan, I'd suggest you start a new thread with a reference to this error in the
subject. I have not encounterd this problem and don't have any useful advice,
and some of the other regulars may not be following this thread.

John W. Vinson [MVP]
 
Back
Top