[mso] MS Access 2003 - automating a data export - pointers?
- From: "Allan Eddy" <AEDDY@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 29 Sep 2006 07:31:05 -0500
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.
Thanks in advance
Allan F. Eddy
*************************************************************
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).
http://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
*************************************************************
- Follow-Ups:
- [mso] Re: MS Access 2003 - automating a data export - pointers?
- From: Tommy Armstrong
Other related posts:
- » [mso] MS Access 2003 - automating a data export - pointers?
- » [mso] Re: MS Access 2003 - automating a data export - pointers?
- » [mso] Re: MS Access 2003 - automating a data export - pointers?
- [mso] Re: MS Access 2003 - automating a data export - pointers?
- From: Tommy Armstrong