Search results

How do I set the report so it only shows 5 records per category This is a report for a marathon and it only pays for the top 5 runners per category. It is all set, except for this issue, it shows me all records per category and I don't want to modify the query because it contains the overall...

How do I set a text box to display the last string text entered? Ok I want to enter the placement number of runners of a marathon... there are various persons giving me the names of the runners in the order they are arriving. I want to have a text box displaying the last number I entered in the...

Thanks Bob...I understand..anyway when you have time and want to brainstorm consider this one. ;)

Thanks Bob what about this situation? Another problem I am having is that there won't be two prizes for one person, but there is a Local Category additional to the 22 Categories and the open Category. Open category will pay only for the first 10 so this 10 runners are easy to isolate because on...

The problem is that I have all the 22 categories in one single report (11 Female and 11 Male)... selecting 5 on the query as you proposed won't display the correct info... only 5 records across all the categories and not 5 records per category.... anyway thank you for answering (I didn't know...

I want to create a report to display the results of a marathon. I have all the tables, forms and queries set. Now I want to create a report that displays only the top 5 runners for each category (there are 11 Categories (Female, Male)), another one that display the first 6 runners this is for...

I'm trying to find some examples of databases that used to be in this forum... one was for DJs and another for a small business, both of them were projects, I just can't find them if anyone knows please post the link. Thank You. I need it to see how it is arrange the form. Thanks!

Im lost on step 6

I got stucked after the append... I have the new main table wit the new field and appended all the record from the original main table.... now I'm lost because I don't understand the Join query.. before you told me to create a copy of each table with one more field... but later you said to join...

I'll do it right now and will tell you if i succeed.. THANK YOU

How do I reassign a new PK for may tables.. they're already related and there about 2,000 records on the Main Table and like 6000 records on the related table.... I used a wrong PK and I want to create a new (long Integer Auto-Number) but I don't want to lose what I've done already.

Thanks... and I really appreciate all of your help when I get stuck (specially with vba) Excellent Forum, excellent people too... lets serve the world making applications that offer productivity to others...

Thanks bob for the observation... I've been designing and testing this db since the moment I began to work with it... three coworkers have been working on the db on every upgrade I made, entering data and testing.. I know this doesn't mean it's bug free but on the run every bug reported has been...

ok gemma.. and how I do that?... I'm a newbie on VBA

I want to use a heading for a lot of reports. This heading will be the company's name, address and phone number. But I don't want to store that info on a table in case someone want to use it without paying for it. This db is designed to work for different municipalities so it has to be...

dcobau thank you for you help, but now I have to go to sleep.. 2am and I have to be awake at 7am... really thank you for giving me direction... I'll continue this later in the day tomorrow, have a nice day, God Bless you.

Look At the report... it comes perfecty.. why life has to be so difficult.. Billy!!! add sorting and grouping to the forms!!

1) The main form is based on tblContactInfo, 2) the subform is based on tblPayments 3) the subform is linked to the main form by field id (registro?) <-- Correct 4) field id must also appear in the query underlaying the subform <--- Correct

Also trying the form based on the query... the subform is not presenting me the new record with the defaults until I click on the row and type something.. then it fill the fields with the default values established making annoying the data entry.. for example if I type 125 the record...

If I base the form to a query based on only one table I will have the same situation.... could not sort because I need that ID to sort the months