Search results for query: *

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

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

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

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"...

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

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

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

Thanks cmmrfrds - I'll give it a try

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

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

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

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

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

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