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 TouchToneTommy 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: *

  1. youngchestnut

    Application.Printers.Count

    Hiya I'm firing the immediate window thru Access VBA (XP) and typing in the above statement. The object/collection exists as I'm getting a choice of which statements I'd but as soon as I hit return I get an unspecific error and Access closes. Any offers? Craig
  2. youngchestnut

    Accessing a View from a Stored Procedure

    Hiya folks, I'n need to access a view from within a SProc, to see if the view returns a recordset and if it does assign one the of the fields that the view returns into a variable. The syntax I'm using is as follows : SELECT TOP 1 @MyJobN = IJobN FROM MyView I keep getting an object...
  3. youngchestnut

    Returning a recordset from SQL back to Access 97

    I need to return a recordset that's generated by an SQL stored procedure back to an Access 97 database. And to honest I haven't got the faintest idea on how this is achieved. I've looked and looked but I can find hardly anything (anything I can understand at least). I've only just starting...
  4. youngchestnut

    Rollback / Undo Function

    Hi all, I have a table called FinalResults which contains 1 field 'Result'. A form links to this table (in continuious form view) and when the form is loaded displays all the results in the FinalResult table. The user can change any of the results shown. What I want to be able to do is to...

Part and Inventory Search

Back
Top