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 Chriss Miller 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: farquar
  • Content: Threads
  • Order by date
  1. farquar

    recordset from stored procedure

    I have a form in Access 2000 and I have a stored procedure which queries a SQL-Server db. The sp returns a recordset and I want to view the contents of the recordset in a continuous form. My code is below but it only seems to want to return the last row in the recordset. Can you help ? I am...
  2. farquar

    View error mesg from Stored Proc in Acces form

    Has anyone got any stored procedures in SQL Server, that they run from an Access form ? My stored procedure has a print command in it, the contents of which gets displayed if it meets a certain criteria. I want to be able to run this SP from my Access form and display the print message in the...
  3. farquar

    Word 2000 won't open

    I have had Office 2000 installed on my pc and Word will not launch. I have searched for a file called Normal.dot and can't find one so I can't delete it. Any ideas. Access & Excel is fine.
  4. farquar

    switch function

    I have a ticket description field (ticket_desc) which contains E.g Single, Return I have an indicator field which can contain a ref number (card_no). I am using the switch function and I want to say: if the card_no field is not null then the ticket_desc field should display 'Free', if it is...
  5. farquar

    number of subreports within main report

    Has anyone experienced problems with the number of subreports in one main report. I have got 4 queries and 4 subreports. Each subreport is based on 1 particular query. When I put 3 of the subreports in my main report it runs fine. As soon as I put a 4th subreport in the main report, when I run...
  6. farquar

    Record Count in Report Header

    I have a report which is based on a query. I would like the record count for the result of that query, to be displayed in the Report HEADER. E.g Total number of records is 14. I can't really do a count in my query as you need to start using group by etc. I have been able to put a count in the...
  7. farquar

    running a report from a form based on the result of a query

    I have been looking at questions raised before and I now know how to determine whether a query has any records, i.e. recordcount. I have a form where you enter a location. I have a report which is based on a query. The query selects from a table where the location in the table matches the...

Part and Inventory Search

Back
Top