File Saving

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

Resolved · Low Priority · Version 2003

File Saving

Bill has attended:
Access Introduction course

by - delegate Bill [1 post] (2008 Aug 4 Mon, 16:40) Reply

Can you turn on a automatic file save function in access

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	6	book now	£450	£485
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: File Saving

by - trainer Pete platinum contributer [799 posts] (2008 Aug 20 Wed, 08:51) Reply

Hi Bill
Welcome to the forum, and thank you for your post:
To answer your question: To my knowledge Access saves each entry as soon as you leave the field, whatever you do to the Database it will automatically save the new information without confirmation.
When you leave the database it will prompt you for any changes to the structure of the database to be saved, this could be overcome by writing a macro which will both save and exit when you close the database.
I hope that has helped, regards Pete

· Microsoft Access as a Business's Database Management System
· Why Do I Need To Use Access?
· How Reorganising Your Data Can Take Your Business to the Next Level
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Three Myths About Microsoft Access

Please browse our web site to find out more about
access vba and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips