[mso] Re: MS Access 2003 - automating a data export - Thanks Tommy!
- From: "Allan Eddy" <AEDDY@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 29 Sep 2006 09:37:29 -0500
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
*************************************************************
Other related posts:
