Search results

Yes, it is possible. Make a MainForm on the ATHLETS table, and make 2 subforms, (on the RACES table, and the RACE DETAILS table). Link them all via AthletsID (number). Populate a LINK CHILD FIELDS, and LINK MASTER FIELDS properties for the both subforms.

Try to do that with LIKE in the query criteria.

Look at "DemoListBoxA2000.mdb" (attachment, zip). Open Form1 and try. Look at VBA.

Look at "DemoWindowsTiresInteriorA2000.mdb" (attachment, zip). I added "Table2". Look at Tables, Query3, Module1. Run Query3. I think it is what you need.

Look at "DemoReportFootnoteA2000.mdb" (attachment, zip). Open Report1 and see. I think it is what you need.

Not SELECT DISTINCT..... but SELECT TOP 1....

Do this via COMBO BOX. Look at "DemoComboB3A2000.mdb" (attachment, zip). Open form and try.

Look at "DemoQueryExcelA2000.mdb" (attachment, zip). Open form and try. Look at VBA, Query1.

What is the look of your table ? What is the primary key ? Write some records in your table.

Try this: me.SubTotal = Me!Parent!Total / me.Quantity

In properties "Data Entry" put NO.

Try next: The code put in "On Current" event, (in subform).

As I can understand you, yor table is not normalized well. Learn something about DATABASE NORMALIZATION.

Hello lala! Look at "DemoNumberRowsA2000.mdb" (attachment, zip). Open Form1 and try. Look at VBA, but if you delete a record 4.0 the next record will be 4.3. Adapt it as you need.

Look at "DemoExtraDetailA2000.mdb" (attachment, zip). Look at Tables, Queries, Forms(VBA), Module1. Try with Form1, or Form2. Adapt it as you need.

In Sub Form_Load put this code; DoCmd.GoToRecord , , acNewRec

Look at "DemoSaveRecordA2000.mdb" (attachment, zip). You don't need any code for the SAVE RECORD. Record will be saved automatic always when you go on the next record, or a new record, or when yu close the form, (for close the form click on the X button in right upper corner on the form). The...

Put the "Order No" Unique = No.

Look at "DemoWeekendsA2000.mdb" (attachment, zip). I suggest to put it in Date_BeforeUpdate event. Look at tables, Form1 (vba). Open Form1 and try.

Look at "DemoTop5QueryA2000.mdb" (attachment, zip). Look at Table1, Query1, run Query1.