|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 18th, 2006, 05:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Making a record of a CommandButtonClick
Hi!
I managed to make a button that makes a copy from the database and saves it somewhere else. Now I'm wondering is there a way to keep track of then it was last saved.... It overwrites the excisting copy, so there is only one copy at the time... Any help? elli 
|
|
#2
February 18th, 2006, 06:34 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Making a record of a CommandButtonClick
On Sat, 18 Feb 2006 19:04:58 +0200, elli wrote:
Hi! I managed to make a button that makes a copy from the database and saves it somewhere else. Now I'm wondering is there a way to keep track of then it was last saved.... It overwrites the excisting copy, so there is only one copy at the time... Any help? elli If you just want to know the date when the last time the database was saved, add a table to your database. Add one field: [LastSaved] DateTime Name the table tblSavedDate Code the command button on the form that saves the database (after the code that actually saves the database runs): currentDb.Execute "Update tblSavedDate set tblSavedDate = Date();",dbFailOnError Add error handling so that you do not update the table unless the database was successfully saved. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
February 18th, 2006, 07:07 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Making a record of a CommandButtonClick
Thank U very many
 )-e- "fredg" kirjoitti et... On Sat, 18 Feb 2006 19:04:58 +0200, elli wrote: Hi! I managed to make a button that makes a copy from the database and saves it somewhere else. Now I'm wondering is there a way to keep track of then it was last saved.... It overwrites the excisting copy, so there is only one copy at the time... Any help? elli If you just want to know the date when the last time the database was saved, add a table to your database. Add one field: [LastSaved] DateTime Name the table tblSavedDate Code the command button on the form that saves the database (after the code that actually saves the database runs): currentDb.Execute "Update tblSavedDate set tblSavedDate = Date();",dbFailOnError Add error handling so that you do not update the table unless the database was successfully saved. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| "Next Record If", Mail Merge Issues | [email protected] | Mailmerge | 8 | February 8th, 2006 07:11 PM |
| User Saving a Record else it deletes | Carter Wexler | Using Forms | 1 | August 2nd, 2005 11:57 PM |
| Creating Records in tables automatically | peterg290935 | Using Forms | 8 | June 22nd, 2005 08:12 AM |
| Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Linear Mode
