Search results

Just to confirm, even a simple msgbox in the On Close event is overidden by a Windows Start/Turn Off Computer action. I suspect what's needed is something within Windows rather than Access/VBA - possibly a Windows API call .....

Thanks for replying Freshman. I'm not sure it really matters how application closure is achieved if that method is overwritten by the PC shutting down? Somehow, the PC shutdown process needs to be interruped before it can do anything so that the user can get back into the application and shut...

Folks My sailing club race management system works very well when all the many users exit elegantly from the system. This elegance includes following a number of 'Exit' buttons which finally sends the days results by email before finally exiting Access. All very good but, some users just don't...

It's the following morning in the UK. I may have misunderstood the use of 'score'. Here's how I have used it. I only need to do this claculation if there were ties in the original processing. Let us say that four people have all tied in 8th place. The tie break should try to determine which...

Doc Man, Sorry for the delay in responding. Your code works in so far as it does, in VBA, what lagbolt's query did - great. However, when there is a true tie, it seems to be assigning the 'wrong' ORDINAL value in that it seems to assume that one is greater than the other - ie it assigns a 1...

The_Doc_Man and lagbolt. Bingo! I guess I have never paid attention to how ORDER BY is working. It does the job even where is no value in one of the fields. But as The Doc Man points out, there's no way to tell if there is a genuine tie at the end of the process. Can I impose on more of your...

Thanks lagbolt that sounds encouraging ... The new table would look something like the attached? (see tievaluetables) I still don't see though how this would help me to sort the data. I think there's a need for some sort of bubble (or other sort) across the columns that stops when there is...

Folks, in my Access app I'm looking for an approach to dealing with ties in series of races. The winner of each race gets 1 point, second place gets two points etc. Races are parts of series and it is the series results that give me the problem. For example (see seriesresults.doc) You can...

Thanks Ian, I understand now that it's quite complex to filter records that have already been filtered. Much of what I'm doing follows this sort of process:- 1. select a set of records from multiple tables based on user criteria selected from combo boxes on the user form. Perhaps wrongly in...

Thanks Ian and Mark, The form I'm developing makes use of user selected criteria from a number of combo boxes (it's management statistics so single user). I've used the combobox(es) selections into CASE statements and used filters to apply filters to get the initial recordset. Following some...

Hi Mark Sorry for the dely. Thanks very much for these thoughts. The Help seems to assume that one wants to work on a particular record whereas what I more often do is work with all the records on the form in different ways. In this case, it's a multiple table query. As you say, I could take an...

Hello Geekay, Yes thank you, I have used the third version. I am in Shrophire in the UK. The application is for my sailing club and seeks to replace the current system which relies on paper and some complex calculations undertaken by different people each week which inevitably results in...

Geekay, I have just read through your solution. It works very well and will just slot into the rest of the application. It will take me some time to get my head around the approach - it looks very complex - but there look to be some great ideas that I can try to learn. You produced the code...

Folks From a newbie ... I've started using the the recordsetclone property and it's very useful. Is there a way however to use if more flexibly? Suppose that you have a set of records in a form and are using the clone ... is it possible to select a reduced set of records by introducing a WHERE...

Thanks geekay I've sent a larger database to your email address as requested. with best regards helmpost

Sorry, first time I've tried an attachment. Should be there now? Brian

Thanks Ken and geekay I've attached a zipped file with a small amount of data and a query. When the sub is run, the user enters the minimum number of events required to qualify (x) and a "best of " value (y), so for example, the minimum number of events to qualify might be 4 (x) and we are...

Ken, By all means, whenever you have time Regards, Brian

Ken, Sorry. I think I can present the problem in a much simpler way. What it all comes down to is this. I have a number of people (sorry that it's text rather than numbers) that have taken part in a series. I then need to do this:- 1. test the number of events that each person has taken part...

Thanks Ken, that was quick! I hope you don't mind a page and a half of A4. This code taks me to a point where I have the results but there may be several people with the same number of points. You can probably see that the code includes mechanisms to select the best (lowest) results and that...