Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms+access+courses+london - updating

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms+access+courses+london - Updating

ms+access+courses+london - Updating

ResolvedVersion Standard

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

Updating

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

Queries, forms and tables in Microsoft Access

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

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.