<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Bericht</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=343253816-15092003><FONT face=Arial color=#0000ff size=2>Up
until a year ago, my VBA was limited to Excel and Access (with a tiny bit in
Word). But now I've gotten into Outlook, FrontPage, and PowerPoint.
Loads of fun. In fact, I spoofed our spam blocker at work, on my home
machine, using VBA inside of Outlook 2000. (It filters the email using the
same pattern files I have at work! grin)</FONT></SPAN></DIV>
<DIV><SPAN class=343253816-15092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343253816-15092003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Erwin Craps
[mailto:Erwin.Craps@ithelps.be]<BR><B>Sent:</B> Saturday, September 13, 2003
3:56 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] Live Top 5 in Powerpoint based on
Access data<BR><BR></FONT></DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff size=2>Ah
yes ofcourse...</FONT></SPAN></DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff size=2>I
was hoping for a simple wizard thing....</FONT></SPAN></DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff
size=2>Never use vba in pp.</FONT></SPAN></DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406195508-13092003><FONT face=Arial color=#0000ff size=2>New
challenge ahead...</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT face=Arial
size=2></FONT> </P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana>Erwin
Craps</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana>Zaakvoerder
</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana size=1><A
href="http://www.ithelps.be/jonathan">www.ithelps.be/jonathan</A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"> </P>
<TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" borderColor=#111111
width="100%" border=1>
<TBODY>
<TR>
<TD width="100%"><FONT face=Verdana size=1>
<P align=center>This E-mail is confidential, may be legally privileged,
and is for the intended recipient only. Access, disclosure, copying,
distribution, or reliance on any of it by anyone else is prohibited and
may be a criminal offence. Please delete if obtained in error and E-mail
confirmation to the sender.</FONT></P></TD></TR></TBODY></TABLE>
<DIV align=center>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 3px"><B><FONT face=Verdana
color=#000080>IT Helps - I.T. Help Center </FONT></B><FONT face=Symbol
color=#000080 size=2> · <FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT>
</FONT><B><FONT face=Verdana color=#000080> B</FONT></B><FONT
face=Verdana color=#000080><B>ox Office Belgium &
Luxembourg</B></FONT></P>
<P style="MARGIN-TOP: 1px; MARGIN-BOTTOM: 1px"><FONT face=Verdana
color=#808080 size=2><A href="http://www.ithelps.be/"
eudora="autourl">www.ithelps.be</A> </FONT><FONT face=Symbol
color=#808080 size=2>·<FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT
size=2><FONT face=Verdana color=#808080> <A
href="http://www.boxoffice.be/">www.boxoffice.be</A> </FONT><FONT
face=Symbol color=#808080>·<FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT>
</FONT></FONT><FONT face=Verdana color=#808080><FONT size=2> </FONT><A
href="http://www.stadleuven.be/"><FONT
size=2>www.stadleuven.be</FONT></A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps bvba</FONT><FONT face=Symbol color=#808080
size=1> <FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> · <FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT size=1><FONT face=Verdana
color=#808080>Mercatorpad 3 </FONT><FONT face=Symbol
color=#808080> ·</FONT></FONT><FONT face=Verdana color=#808080
size=1> 3000 Leuven</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps </FONT><FONT face=Symbol color=#808080
size=1>·</FONT><FONT face=Verdana color=#808080 size=1> Phone: +32 16
296 404 </FONT><FONT face=Symbol color=#808080 size=1>·<FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT face=Verdana color=#808080
size=1> Fax: +32 16 296 405 E-mail: <A
href="mailto:Info@ithelps.be">Info@ithelps.be</A> </FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>Box Office </FONT><FONT face=Symbol color=#808080
size=1> ·<FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT face=Verdana
color=#808080 size=1> Fax: +32 16 296 406 </FONT><FONT face=Symbol
color=#808080 size=1> ·<FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT
face=Verdana color=#808080><FONT size=1> Box Office E-mail: </FONT><A
href="mailto:figures@boxoffice.be"><FONT
size=1>Staff@boxoffice.be</FONT></A></FONT></P></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=nl dir=ltr align=left><FONT face=Tahoma
size=2>-----Oorspronkelijk bericht-----<BR><B>Van:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>Namens </B>Drew
Wutka<BR><B>Verzonden:</B> vrijdag 12 september 2003 19:20<BR><B>Aan:</B>
'Access Developers discussion and problem solving'<BR><B>Onderwerp:</B> RE:
[AccessD] Live Top 5 in Powerpoint based on Access data<BR><BR></FONT></DIV>
<DIV><SPAN class=936501917-12092003><FONT face=Arial color=#0000ff
size=2>You can use VBA within PP, so I would say the answer is
yes.</FONT></SPAN></DIV>
<DIV><SPAN class=936501917-12092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=936501917-12092003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Erwin Craps
[mailto:Erwin.Craps@ithelps.be]<BR><B>Sent:</B> Friday, September 12, 2003
8:47 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> [AccessD] Live Top 5 in Powerpoint based on
Access data<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=889294113-12092003>Can I create a
slideshow page in Powerpoint (running endlessly in show) that displays
a hitlist based on data in a Access
database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=889294113-12092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=889294113-12092003>The hitlist is dynamic, so each time the
slideshow passes this slide in the endless slide loop, it should show live
data on screen.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=889294113-12092003>The activity
should be from Powerpoint, I mean by that that PP should get the data in
the MDB file and NOT Access pushing (exporting) the
data.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=889294113-12092003><FONT face=Arial
size=2>thx</FONT></SPAN></DIV>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT face=Arial
size=2></FONT> </P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana>Erwin
Craps</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT
face=Verdana>Zaakvoerder </FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
size=1><A
href="http://www.ithelps.be/jonathan">www.ithelps.be/jonathan</A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"> </P>
<TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 width="100%" border=1>
<TBODY>
<TR>
<TD width="100%"><FONT face=Verdana size=1>
<P align=center>This E-mail is confidential, may be legally
privileged, and is for the intended recipient only. Access,
disclosure, copying, distribution, or reliance on any of it by
anyone else is prohibited and may be a criminal offence. Please
delete if obtained in error and E-mail confirmation to the
sender.</FONT></P></TD></TR></TBODY></TABLE>
<DIV align=center>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 3px"><B><FONT face=Verdana
color=#000080>IT Helps - I.T. Help Center </FONT></B><FONT
face=Symbol color=#000080 size=2> · <FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><B><FONT face=Verdana
color=#000080> B</FONT></B><FONT face=Verdana color=#000080><B>ox
Office Belgium & Luxembourg</B></FONT></P>
<P style="MARGIN-TOP: 1px; MARGIN-BOTTOM: 1px"><FONT face=Verdana
color=#808080 size=2><A href="http://www.ithelps.be/"
eudora="autourl">www.ithelps.be</A> </FONT><FONT face=Symbol
color=#808080 size=2>·<FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT
size=2><FONT face=Verdana color=#808080> <A
href="http://www.boxoffice.be/">www.boxoffice.be</A> </FONT><FONT
face=Symbol color=#808080>·<FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT>
</FONT></FONT><FONT face=Verdana color=#808080><FONT
size=2> </FONT><A href="http://www.stadleuven.be/"><FONT
size=2>www.stadleuven.be</FONT></A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps bvba</FONT><FONT face=Symbol color=#808080
size=1> <FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> · <FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT size=1><FONT face=Verdana
color=#808080>Mercatorpad 3 </FONT><FONT face=Symbol
color=#808080> ·</FONT></FONT><FONT face=Verdana color=#808080
size=1> 3000 Leuven</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps </FONT><FONT face=Symbol color=#808080
size=1>·</FONT><FONT face=Verdana color=#808080 size=1> Phone: +32
16 296 404 </FONT><FONT face=Symbol color=#808080 size=1>·<FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT face=Verdana color=#808080
size=1> Fax: +32 16 296 405 E-mail: <A
href="mailto:Info@ithelps.be">Info@ithelps.be</A> </FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>Box Office </FONT><FONT face=Symbol color=#808080
size=1> ·<FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT
face=Verdana color=#808080 size=1> Fax: +32 16 296 406 </FONT><FONT
face=Symbol color=#808080 size=1> ·<FONT
face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT
face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </FONT><FONT face=Verdana color=#808080><FONT
size=1> Box Office E-mail: </FONT><A
href="mailto:figures@boxoffice.be"><FONT
size=1>Staff@boxoffice.be</FONT></A></FONT></P></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>