April, You would probably want to use an Update Query rather than an Append query for this if all you are doing is clearing the single field. James -----Original Message----- From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx] Sent: Friday, January 17, 2003 8:34 AM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Append Records?? :VSMail mx2 April- You can do this, but there are some conditions. Create a macro and name it autoexec, it will run when the database loads. In the macro have it RunCode and set the function name to StartCode. Create a new module and name it mod_Start. In this new module create a new function Public Function StartCode() ~some magic~ End function Now when Access opens, the code in StartCode() will execute. In StartCode() you can write some more code that will check for the date and if it's the first of the month, do your append query. Of course this only works if the database is opened on the first of the month. If it's not opened on the first of the month your code will not append the records. So you need to keep track of when the last append was done. You need to create a table of the last append date. Your code can check today's date, if it's after the first of the month, check the date in the table, if that is not the first of the current month, then append the records and update the date table. Pretty simple huh. Or you could just do it manually. -Anthony -----Original Message----- From: April Pace [mailto:4office@xxxxxxxxxxxxx] Sent: Thursday, January 16, 2003 5:03 PM To: Office (E-mail) Subject: [mso] Access Append Records?? I just want to check... I have a field.... Medicare ID Number... that we will fill in for appropriate patients... On the first of each month I need this to be cleared out and re entered.... Can I automatically do this, or to I need to set up an Append Table query that triggers this to be cleared out... April ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************