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 wOOdy-Soft 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: Leeeon
  • Content: Threads
  • Order by date
  1. Leeeon

    Problem with OpenRecordset

    Hi I'm using Access XP, and having a problem with the OpenRecordSet method. If I try the code below, I keep getting a type mismatch error at the 'Set MyRs' line. Function testit() Dim MyDb As Database Dim MyRs As Recordset Set MyDb = CurrentDb() Set MyRs = MyDb.OpenRecordset("MyQuery")...
  2. Leeeon

    Show Totals on Details Line

    Is it possible to force Access to print the totals from a group_footer next to the last entry in the details line eg assume Apples and Pears are two records from Details Section, and Total is sum of two in Fruits_Footer, I want report to look like: Apples 24 Pears 12 Total: 36 Instead of...
  3. Leeeon

    Locked Excel Sheet

    I am using Excel 97 on Windows XP. Every now and then I get an error which causes Excel to shut down. If that isn't bad enough, when I then go to re-open the file I get a message: FileXYZ.xls is locked for editing by 'Leon' and I can only open the file in read-only mode. I'm 'Leon' and the...
  4. Leeeon

    Resetting &Pages after group

    I have a report that prints information grouped on different departments. At the bottom of each page I have the standard 'Page 1 of 20' footer using &Page and &Pages. For each group I would like to be able to print the number of pages for just that group and then reset it for the next group eg...

Part and Inventory Search

Back
Top