sql view

[charles osborne]

Does anyone know why the SQL view may not be available to
use for a table of form? I have read that you can get the
SQL view by clicking on the view button drop down list, but
it isn't there for some reason. The only view options
showing are Design View, Datasheet View, Pivot Chart View,
and Pivot Table View. I don't see the SQL View option. Can
you tell me how to find it?

Thanks!

 

[Van T. Dinh]

Do you mean the SQL that creates the Table struture like in SQL Server?

This is not available in Access. The SQL View is only available for Queries
in Access.

 

[Byron]

The sql view you are refering to is one of the ways to
veiw a query when using the QBE to create or view a query.

If you have an sql statement as the record source of a
form and you go to a QBE view of that sql statement then
you can also see the sql view from there.

HTH

Byron

 

[Charles osborne]

Thanks for your help!

-----Original Message-----
Do you mean the SQL that creates the Table struture like in SQL Server?

This is not available in Access. The SQL View is only available for Queries
in Access.

--
HTH
Van T. Dinh
MVP (Access)






.

 

[Albert D. Kallal]

if you base the form on a sql statement, or query..then YES, you can most
certainly view/edit the sql used for the form.

While looking at the form in design view..look at the data tab in the
properties sheet.

if you whack the [...] box beside reocrdsouce property..then the sql view is
launched....