Good to hear from you too Crystal! I did add some DoEvents because I recurse through and get thousands of records. NICE tool.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 6, 2018 1:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: shout out to Allen Brown and Crystal Long
hi Liz,
I've updated the ListFiles tool -- latest (public) version is here:
http://www.accessmvp.com/strive4peace/DB_ListFiles.htm
I would have asked Allen to post it, but he is busy doing God's work .... new version has some cool reports and incorporates Wayne Phillips' code for getting extended properties so it records more file data.
This tool, like my Analyzer, is dear to me, and I do plan to post another version of it ... sometime. I've added lots more stuff but haven't weeded it out for posting yet.
> "express my gratitude"
thanks!
> "I'm doing something wrong though so I am debugging.� It isn't doing the recursion."
did you add DoEvents or MsgBox anywhere? Well if you are stepping, then you are essentially doing a DoEvents with each statement... let it get the filenames without you watching -- DoEvents can make it not recurse properly.
nice to hear from you, Liz
have an awesome day,
crystal
On 3/6/18 1:45 PM, Duane Hookom duanehookom@hotmail.com<mailto:duanehookom@hotmail.com> [MS_Access_Professionals] wrote:
Liz,
I copied the code into a new module, created the table, and tested/ran the code. The table filled with the file names as expected with no errors.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> <MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com<mailto:liz_ravenwood@beaerospace.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, March 6, 2018 11:40 AM
To: 'MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>'
Subject: [MS_AccessPros] RE: shout out to Allen Brown and Crystal Long
�
I'm doing something wrong though so I am debugging.� It isn't doing the recursion.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rockwellcollins.com%2F&data=02%7C01%7C%7Cdc7a26779a6c4a02de6308d5838953b5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636559548188600975&sdata=%2BHrhxVksLJCLW5l2Ayqiyp8XmEOHz%2FxUeoLpuVGhsGk%3D&reserved=0>
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 6, 2018 9:54 AM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Re: shout out to Allen Brown and Crystal Long
Dilly Dilly! True friends of the [Access] Crown.
Duane Hookom
________________________________
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com>> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com<mailto:liz_ravenwood@beaerospace.com><mailto:liz_ravenwood@beaerospace.com><mailto:liz_ravenwood@beaerospace.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com>>
Sent: Tuesday, March 6, 2018 10:41 AM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] shout out to Allen Brown and Crystal Long
I believe it is Crystal who contributed here.� (list of files to a table)
I need to build something together fast and found this snippet so lovingly and willingly shared, so I want to publicly express my gratitude.
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fallenbrowne.com%2Fser-59alt.html&data=02%7C01%7C%7C34fed2a8e34a471474f108d58381196b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636559512855164880&sdata=lUcfkXprMjPUY4t5P3OK%2Bz5KJApx7FTbyXR8%2Bn8bCf0%3D&reserved=0
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com%3cmailto:Liz_ravenwood@beaerospace.com><mailto:Liz_ravenwood@beaerospace.com%3cmailto:Liz_ravenwood@beaerospace.com>>
rockwellcollins.com<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rockwellcollins.com%2F&data=02%7C01%7C%7C34fed2a8e34a471474f108d58381196b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636559512855164880&sdata=NJcQtYc1%2FA%2FcO3%2BV3Xn4GUuBANrI7G%2FF6fkZdV0Pbb4%3D&reserved=0>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com<mailto:Liz_Ravenwood@beaerospace.com><mailto:Liz_Ravenwood@beaerospace.com><mailto:Liz_Ravenwood@beaerospace.com>>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com><mailto:Liz_Ravenwood@beaerospace.com>
------------------------------------
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar