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 Rhinorhino 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. kb9prt

    Capture mouse click in excel

    thank you for the suggestions! and sorry I did not respond sooner - I was off line for a bit. I ended up positioning the focus one cell to the right on the dialog box close. It is not perfect but forces the selectionChange event if they should need to enter the data again. This is kind of the...
  2. kb9prt

    Capture mouse click in excel

    A rather silly question but sometimes my little mind gets wrapped around something and will not let go. I am trying to capture a mouse click in an excel spreadsheet. Worksheet_SelectionChange() works fine except if the user clicks on the same cell when the cell does not change. I have a...
  3. kb9prt

    Ranking Query help - over my head and going down

    PHV - You are the greatest! I have to let you know that I tried that modification as I tried to work through it myself but it didn't work. When I first tried your version it didn't work either then...Duhh - the underling query was hiding some of the lifters that scratched but the query was...
  4. kb9prt

    Ranking Query help - over my head and going down

    Hi SkipVought - I tried to keep the tables somewhat "Normalized". The total weight lifted or Expr5 is the sum of the maximum lift from Squat, bench press and Deadlift. Each lifter actually gets three attemps at each lift and the maximums are added for the total weight lifted. The "Lifters"...
  5. kb9prt

    Ranking Query help - over my head and going down

    Sometimes I have a hard time explaining what I am tring to do - the total weight lifted is actually the Expr5 field and I did name it as such (TotalWt)in the "live" query but because it is a calculated field and I put together a test DB to experiment with.... I did not document too much. Sorry...
  6. kb9prt

    Ranking Query help - over my head and going down

    Thanks SkipVought and PHV : works like a charm - maybe you can help with one other problem I found while testing this. When two lifters have the same total weight lifted then the lifter with the lighter body wt should rank first. I tried modifing your SQL but I didn't have much luck. Could...
  7. kb9prt

    Ranking Query help - over my head and going down

    I tried the following code but get an error message of "You tried to execute a query that does not include the specified expression 'IDKey' as part of an aggregate function" SELECT A1.IDKey,A2.IDKey, A1.Gender, A1.WtClass, A1.Division, A1.BodyWt, A1.Expr5 AS TotalWt,Count(A2.Epr5)AS WtClassRank...
  8. kb9prt

    Ranking Query help - over my head and going down

    Thanks cmmrfrds - I'll give it a try
  9. kb9prt

    Ranking Query help - over my head and going down

    I am relatively inexperience with Access and have found myself over my head. I have put together an Access database for a local power-lifting meet. It is a relatively simple DB but has preformed well over the last few years. Each year I have been asked to add a little something to it: this...
  10. kb9prt

    How to Populate the detail section of a report with line numbers

    That's what I needed to know. I wanted to make sure I was not missing something simple - like so often is the case. thanks for all your help. This Forum rocks
  11. kb9prt

    How to Populate the detail section of a report with line numbers

    Dhookom - The solution that you provided worked great! - I was able to match up the line with the current record and it printed 25 lines regardless of how many records were grouped. I was just wondering if there was a way to print the detailed section within the "On Page" macro a...
  12. kb9prt

    How to Populate the detail section of a report with line numbers

    The original idea worked fine but now there is an additional request. I would like to print out the Detail section of the report a multiple of 25 regardless of how many records are pulled into it. Let me try to explain further. If the report only has 5 records to print I would like it to...
  13. kb9prt

    How to Populate the detail section of a report with line numbers

    Thanks for the quick reply. This is what I was looking for, although it prints line numbers acrossed the header section of the report. I would like the line numbers in the detailed section only. I am sure that with a little adjustment I will be able to work it out. You have been most...
  14. kb9prt

    How to Populate the detail section of a report with line numbers

    Hello - I'm relatively new at this so please talk to me as if I am a three year old. I have a report with a page header, detail section, and a page footer. The detail section populates from a query with a sample identification (sample name). There can be a variety of samples for each report...

Part and Inventory Search

Back
Top