Search results

I am trying to create a database for recording boat race results. The set up is as follows... There are boat classes which contain boats... Classes have a number of series throughout the yaer which would consist of several races... Each race has a number of entrants with respective results...

Hi Bob Thanks for your help the other day. I am though stuck again! I am trying to create a database for recording boat race results. The set up is as follows... There are boat classes which contain boats... Classes have a number of series throughout the yaer which would consist of several...

Re: Simple problem got me thinking Thanks Bob PK I guess is Primary Key FK? And what relationships?

I need to create a simple database where I have a list of boats, a list of boat classes and all I want to do is select which boats belong to specific classes. All I need is to create a form where I have a list of my boats and a tick box next to the classes to show which boat belongs to which...

Simple problem got me thinking I need to create a simple database where I have a list of people, a list of groups and all I want to do is select which people belong to specific groups. All I need is to create a form where I have a list of my people and a tick box next to the groups to show who...

Many thanks, such a simple solution. As I said I am new to this and the help is much appreciated. Tim

Thanks Missindlinq. I have found a way to replicate the error. Open the form "Repair Input" from the Switchboard Double click the "1" repair number on the repairs tab. This opens the repair details form. Change the "Status" of the first item (Sprayhood) using drop down box Then try and...

The steps are open the form "FrmRepairDetails" This contains a subform which has repair Items that a customer has brought in. When clicking in the fields of the subform the focus sometimes goes to the first field (Item) on the first row without warning. As a consequence of the focus moving...

Just to let you know the database I attached has had most of the 10000 records removed, just a few records are left in to show the problem.

Created both forms from scratch again, apart from Boat name drop down box which I copied from other form as it had some code that I could not remember how to create! I do not believe I have any requery code within the forms.

Thanks for the reply, Yes I guess I am talking about focus being sent to the first control of the first record in the subform. I have recreated the form and subform from scratch and still get the same problem. The new forms are FrmRepairDetailsNew and SfrmRepairDetailsNew. It is as I say...

I am new to access and have created a databse in Access 2000 for logging customers and orders at my workplace. I am having a huge problem with a subform which when entering data into it randomly puts the cursor to the first field of the first record within the subform. The consequence of which...