Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: UrlOnz
  • Content: Threads
  • Order by date
  1. UrlOnz

    View From SP forget it.

    Ok, everyone said don't try to alter a view from an SP. The problem was getting a SP to be the RecordSource for a report in the Access front end. I put the proc in as the RecordSource and hard coded a parameter and the report ran. Then I make a form where the user entered the parameter in a text...
  2. UrlOnz

    Alter view from SP

    The problem is there are 40 users most of whom are not allowed to see records assigned to others. Theses users need reports. The reports are generated from an Access front end. The reports are altered when the underlying view is altered. When the record number is changed in the view the report...
  3. UrlOnz

    Can you alter a view from a stored procedure?

    Can you alter a view from a stored procedure? I need to send criteria to the view from the parameter of the procedure. I tried putting the ALTER VIEW code right after the AS in the CREATE VIEW statement. The error returned was “Error near key word VIEW”.

Part and Inventory Search

Back
Top