[mso] Re: MS Access 2003 - automating a data export - Thanks Tommy!

  • From: "Tommy Armstrong" <tfa@xxxxxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Fri, 29 Sep 2006 10:25:03 -0500

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
*************************************************************

Other related posts: