Well you were ahead of me--this way if the export fails for some reason, you just do not set to yes. When you get it working, let me know--I have a use for just such a routine. Tommy Armstrong PO Box 484 Lillington, NC 27546 http://www.brickengraver.com tfa@xxxxxxxxxxxxxxxxx "If you're a big enough fool to climb a tree and like a cat refuse to come down, then someone who loves you has to make as big a fool of himself to rescue you." W Percy -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Allan Eddy Sent: Friday, September 29, 2006 9:37 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: MS Access 2003 - automating a data export - Thanks Tommy! The light turned on - I got it Tommy - thanks. With a yes/no field added, my routine exports all records set as false then a second pass to set all records to yes. I knew I was going to go Duh! Thanks again, Allan F. Eddy -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Allan Eddy Sent: Friday, September 29, 2006 9:26 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: MS Access 2003 - automating a data export - pointers? Thank you Tommy but with this method wouldn't I need to manually check each record after it was exported? How could I get a routine or macro to flip the no to yes automatically at time of export or before exiting? Allan -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Tommy Armstrong Sent: Friday, September 29, 2006 8:35 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: MS Access 2003 - automating a data export - pointers? One could add yes/no Boolean field to the table, and when exporting check as exported. Use a query whereby selects all where "Exported=3D3Dfalse" When you export it, and looping through all the records, then simply set it to true so the next time the query "eliminates" those.=3D20 =3D20 "If you're a big enough fool to climb a tree and like a cat refuse to come down, then someone who loves you has to make as big a fool of himself to rescue you." W Percy Tommy Armstrong PO Box 484=3D20 Lillington, NC 27546 http://www.brickengraver.com 910-893-5508 =3D20 -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Allan Eddy Sent: Friday, September 29, 2006 7:31 AM To: mso@xxxxxxxxxxxxx Subject: [mso] MS Access 2003 - automating a data export - pointers? I need to automatically export only recently entered records from a single table Access database without exporting records which have been previously exported. Is there a way to "flag" records as having already been exported? Basically I want to automatically retrieve records that an operator has entered on the previous workweek day. Due to weekends, holidays, etc. I don't see how I can use any calendar driven scheme for the export. I am experienced in Access and have working knowledge of VBA but cannot seem to get the light bulb to turn on in my head about the best way to do it. Is there a VBA function or routine or any macro available in Access? I welcome any and all suggestions and I'm sure I'm going to go "Duh" when you guys point out the solution. My little brain is simply not working on this one. =3D20 Thanks in advance Allan F. Eddy =3D20 ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************