ms+access+courses+london - Updating

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

Resolved · Low Priority · Version Standard

Updating

Justin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Justin [2 posts] (2007 Mar 5 Mon, 15:09) Reply

I added another field to my table, but how do I get it to up date in Queries,Forms and reports with my other two fields that are already there?

Thank you

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

Queries, forms and tables in Microsoft Access

by - trainer David gold contributer [428 posts] (2007 Mar 6 Tue, 10:54) Reply

Hi Justin

The queries and forms will not update themselves in MS Access, so you will need to add the table field into your query and re-run it. Then you will need to add this new field to your form, you should be able to this in design view.

Hope this helps
David

· Innovation with Microsoft Access
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· MS Access and Database Normalisation
· Microsoft Access Tighten your Security Controls
· Why go on a Microsoft Access Training Course?

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips