microsoft training access course - Forms

The UK's most regular instructor-led training courses.
Training information: microsoft training access course · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Forms

Taryn has attended:
Access VBA course
Access Advanced course

by - delegate Taryn [3 posts] (2007 Dec 5 Wed, 15:07) Reply

Can you link forms and subforms so that if you choose a certain date in a sub form, it will show all the forms it relates to?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Forms

by - trainer Carlos gold contributer [473 posts] (2007 Dec 10 Mon, 11:52) Reply

Hi Taryn

Could you please clarify what you require?

Do you want to select a date on the main part of the form and have the data appear in the sub form or do you want to open other forms?

Carlos

· Access VBA Training Adds Power to your Databases
· Why Do I Need To Use Access?
· Tips for designing databases in Microsoft Access
· Why a Microsoft Access Course Could Change the Way You Do Business
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips