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!

Recent content by farquar

  1. farquar

    recordset from stored procedure

    I tried what you suggested, being me.recordset and it said object variable or with block variable not set. I have tried me.recordsource = rst1 but it doesn't like that either. all my code is on the on load of a form. thanks.
  2. farquar

    recordset from stored procedure

    Thanks - I have tried all those sorts of things, even setting recordsource but it doesn't like it. I put a counter in the loop and it goes through the 2400 records in my table but displays the last one in the form and the record selectors say 1 of 1.
  3. 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...
  4. 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...
  5. 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.
  6. farquar

    switch function

    cheers, ta, thank you, merci
  7. farquar

    switch function

    Thanks, I failed to mention that I am doing this in an sql query, is this ok ?
  8. 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...
  9. farquar

    number of subreports within main report

    It's not a particular report that is causing the problem. I can run each of the sub reports or 2 or 3 of them and it works. I think I have a problem when the report needs to display more than 1 page. It just seems to hang. This is why when I put a 4th subreport in, it fails. Doesn't matter what...
  10. 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...
  11. farquar

    Record Count in Report Header

    Thanks for the replies. The one about using Count(*) in the text box won't work. Count(*) will only work in the Detail or Footer Section.
  12. 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...
  13. 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...
  14. farquar

    Internet Explorer 6 - broken photo links

    I have noticed the same problem and it looks like it affects jpgs. Gifs seem ok.
See more

Part and Inventory Search

Back
Top