Bill,

Thanks for your kind interest. Glad you liked it Indeed - it was a fun
project, like its companion sample named BlinkingLabels_XP (which was put
together some time back and is available at Roger's site).

BlinkingLabels_XP was inspired by your Marquee sample, and demonstrates
smooth fading In / Out of labels, apart from other special effects like sliding
/ expanding / shrinking.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Bill Mosca
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, January 12, 2009 20:49
Subject: [MS_AccessPros] Re: flash on forms, can they be clicked, and what is
the trigger


A.D.

Thanks for the very clever and amusing sample. I bet you had a lot of
fun creating it.

It is certainly much more sophisticated than the Marquee sample I
uploaded years ago.


Bill

--- In MS_Access_Professionals@yahoogroups.com, "A.D.Tejpal"
<adtp@...> wrote:
>
> Bill,
>
> Just as an exercise in exploring the possibilities in access, I
have put together a sample db demonstrating programmatically animated
waveforms and nested shapes. Form timer (normally in a disabled
state) is enabled in short bursts only for actual duration of
animation.
>
> Five styles of waveforms are covered (The user can select the
speed of animation e.g. Low / Medium / High):
>
> (1) Spiral - Simple
> (2) Spiral - Oscillating X axis
> (3) Sine wave - Three components in series
> (4) Sine wave - Three components in phase
> (5) Sine wave - Three phase (typical of electric power supply)
>
> Nested shapes cover various combinations of shapes radiating
outwards within a given box. Animation speed continues to cycle
through normal / fast / faster.
>
> In both cases, the size of display can be altered by clicking
anywhere within the outermost rectangle. Bottom right corner of
display area shifts to the clicked location while the top left corner
remains constant.
>
> The sample named Form_AnimatedWavesAndShapes is now available
at Rogers Access Library. Link -
> http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
>
> Best wishes,
> A.D. Tejpal
> ------------
>
> ----- Original Message -----
> From: Bill Mosca
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, January 09, 2009 23:29
> Subject: [MS_AccessPros] Re: flash on forms, can they be clicked,
and what is the trigger
>
>
> No offense taken, Terence. If you haven't picked up on it yet I
*do*
> have a sense of humor leaning painfully to the corny side.
>
> Experimenting with new things to do in Access is fun. I just
don't
> advise fluff for business databases. Clients tend to frown on
such
> frivality. I almost lost a contract because I used a .wav from
the
> Simpsons TV show. No one had speakers in that office so I didn't
> bother removing it for deployment. I later found out the CEO
*did*
> have speakers and I was told to remove the wav. That's where I
> learned my lesson. Keep the fun stuff for personal use.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "buffalome90210"
> <buffalome90210@> wrote:
> >
> >
> > ty for the info and the link , from what i can tell he did a
very
> > clever job.
> >
> > I do however get a little ,mmmm, how you say,....purest
attitude
> from
> > your remark about :) writing databse applications (not
entertain) :)
> >
> > please please don't take my comments the wrong way....I respect
your
> > position, and understand your position..
> >
> > I simply have a bit more "excentricity in me"..... I think stuff
> > should do both at the same time.
> >
> > I mean, I am a typical american mail, so its only natural that
my
> > attention would span would be minimal and that I am attracted to
> > shinney onjects that move.
> >
> > ")
> >
> > But in all seriousness, from amarketing perspective,
unfortunate as
> it
> > may be, often glitz, and bling sells, or at least gets one foot
in
> the
> > door.
> >
> > BUT even I agree, that I always have tp go back and tone down my
> > applications because they seem take on a comical whim.
> >
> > :)
> >
> > ALSO regarding entertainment....funny you should mention, one
of my
> > other prtojects over the past 2 years was working on
HTPC's...purley
> > entertainment drive...specifcally Meedios :)
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca"
> > <wrmosca@> wrote:
> > >
> > > Rats! I completely forgot about Stephen Lebans' sample. He
does
> it
> > > all with VBA code.
> > > http://www.lebans.com/animatedgifplayer.htm
> > >
> > > Bill
> > >
> > > --- In
MS_Access_Professionals@yahoogroups.com, "buffalome90210"
> > > <buffalome90210@> wrote:
> > > >
> > > > what effects...Hmm, ideally, i wanted to incorporate
animated
> gif,
> > > for
> > > > both XP and Vista. (i can get a .dll for xp to work but not
in
> > > Vista).
> > > > I was succesfull in converting the .gif to a flas (.swf)
and
> get
> > > that
> > > > running in bothe xp and Vistsa.
> > > >
> > > > 2. Rollover effect. I have been able to create a flash .swf
> button
> > > and
> > > > incorporate it. I am able to get an event trigger of Get
Focus,
> so
> > > > basically I am solved and good.
> > > >
> > > > BUUUT, I am concerned over the amount of info (bad press)
about
> > > > Activex components, why people think they are evil,
vulnerable,
> > > etc. I
> > > > have not read much about it, But would appreciate
the "Monarch
> > > Notes"
> > > > version.
> > > >
> > > > Also my application will be a standalone on a PC that is
network
> > > > connected, but the application itself is self contained..
Does
> that
> > > > still pose a security vulnerability ?
> > > >
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "Clive
Williams"
> > > > <zctek@> wrote:
> > > > >
> > > > > Hi Lawrence,
> > > > >
> > > > > Can you tell us what effect you are trying to achieve
> > > > > and for what purpose?
> > > > >
> > > > > That may allow us to suggest alternatives to ActiveX.
> > > > >
> > > > > Regards, Clive.
> > > > >
> > > > > --- In
> MS_Access_Professionals@yahoogroups.com, "buffalome90210"
> > > > > <buffalome90210@> wrote:
> > > > > >
> > > > > > It will take me a little bit to reaserch the
> > > > > > dangers/benefits/pros/cons" of activex, BUT for now, I
will
> > > side on
> > > > > > your advice and stay away from it.
> > > > > >
> > > > > > I am confussed. Why is there no native provision for
> rollover
> > > effect
> > > > > > in access forms? I see how i could basterdize the use
of
> > > mousemove
> > > > > in
> > > > > > a very innefficient way to approximate the effect, but
> thats
> > > crappy.
> > > > > >
> > > > > > And yes, I could alter the image property in VBA,
providing
> I
> > > could
> > > > > > tell when the mouse moves IN and OUT, I see the
mouseover,
> BUT
> > > the
> > > > > > only way I an triger a mouseOUT event is to trigger
another
> > > mouse
> > > > > over
> > > > > > of a surrounding transparent rectangle.
> > > > > >
> > > > > > A mouse IN without a mouse out ?
> > > > > >
> > > > > > I gues if i had to i could grab the mouse coordinates
and
> > > implement
> > > > > > logic to determine when a moveout occurs, BUT GOSH ALL
> MIGHTY,
> > > this
> > > > > is
> > > > > > 2009, a Mouse out event should be a natural for such a
> > > application.
> > > > > >
> > > > > > GENERALLY, when i find something hard or weird, it
usually
> > > means I
> > > > > > have an error in some fundemental of understanding.
> > > > > >
> > > > > > OH OH OH....John, me go back and experiment with what
> events i
> > > see
> > > > > > comming from NON activex like command buttons, images,
> labels
> > > and
> > > > > > such.....BUT i am pretty sure there is no MOUSEOUT type
> event ?
> > > > > >
> > > > > > Also....a comment was made earlier that I should
consider
> > > VB.net or
> > > > > C
> > > > > > as a possible solution.....
> > > > > >
> > > > > > Are you saying to abandon ACCESS and write a "from
scratch"
> VB
> > > > > > application with plain old sql ?
> > > > > >
> > > > > > :) Terence
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com, "John
> Viescas"
> > > > > > <JohnV@> wrote:
> > > > > > >
> > > > > > > Terence-
> > > > > > >
> > > > > > > Not all ActiveX controls generate the normal events.
In
> some
> > > > > cases, you
> > > > > > > simply must code the event procedure even though
there's
> not
> > > event
> > > > > > property
> > > > > > > showing up in the property list for the control. You
can
> > > > > sometimes
> > > > > > > right-click the control in Design view, choose
ActiveX
> > > Control,
> > > > > then
> > > > > > Help to
> > > > > > > get the help file for that control that should tell
you
> which
> > > > > events the
> > > > > > > control supports.
> > > > > > >
> > > > > > > John Viescas, author
> > > > > > > Microsoft Office Access 2007 Inside Out
> > > > > > > Building Microsoft Access Applications
> > > > > > > Microsoft Office Access 2003 Inside Out
> > > > > > > SQL Queries for Mere Mortals
> > > > > > > http://www.viescas.com/
> > > > > > > (Paris, France)
> > > > > > >
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > > > > [mailto:MS_Access_Professionals@yahoogroups.com] On
> Behalf Of
> > > > > > buffalome90210
> > > > > > > Sent: Thursday, January 08, 2009 11:26 PM
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > Subject: [MS_AccessPros] Re: flash on forms, can they
be
> > > clicked,
> > > > > > and what
> > > > > > > is the trigger
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Well I hate to interrupt your "Summit" :)
> > > > > > >
> > > > > > > anyhow, here goes, I want animation on a access form,
> found
> > > a .dll
> > > > > > > called gif86.dll i think thats what it was. It worked
> fine,
> > > BUT
> > > > > then I
> > > > > > > ported to Vista, I had been using XP Pro sp2, WELL
Vista
> > > didnt
> > > > > like
> > > > > > > the register REGSVR32.exe of the Dll,
> > > > > > >
> > > > > > > So I asked if anyone new how to register gif89.dll on
> vist,
> > > or
> > > > > even if
> > > > > > > it could be, and if that was not dooable, then anyone
got
> a
> > > > > different
> > > > > > > control which will allow gif animation and be
compatable
> to
> > > xp and
> > > > > > vista.
> > > > > > >
> > > > > > > Well not much responce, so I figured i had missed the
> boat
> > > > > somehow,
> > > > > > > was aware that the Shockwave/flash activex components
are
> > > readily
> > > > > > > available. So I converted the gif to a SWF..... Well
> thats ok
> > > > > (got a
> > > > > > > bit of a "transparent background thingy goin on) but
I
> can
> > > handle
> > > > > it.
> > > > > > >
> > > > > > > So then I thought about fls objects, like buttons. I
> realize
> > > > > there are
> > > > > > > some techniques to do rollover stuff by using mouse
> moves,
> > > but I
> > > > > liked
> > > > > > > flash better, So I created a flash Button.
> > > > > > >
> > > > > > > I put it on the form.
> > > > > > >
> > > > > > > BUT when I clicked on it, yes of course the flash did
its
> > > > > animation
> > > > > > > thing, BUT event was generatate. I tried syuff, like
> > > transparent
> > > > > > > rectangles on top, etc etc nothin worked. No click()
no
> > > > > nothin ??????
> > > > > > >
> > > > > > > What Am i not seeing ?
> > > > > > > --- In MS_Access_Professionals@yahoogroups.com, "Bill
> Mosca"
> > > > > > > <wrmosca@> wrote:
> > > > > > > >
> > > > > > > > Terence
> > > > > > > >
> > > > > > > > Sorry, I didn't follow that original thread and now
> you've
> > > > > started a
> > > > > > > > new one so I have no idea what you want to do.
> > > > > > > >
> > > > > > > > Can you bring us up to speed or bump your original
> thread?
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > > Bill Mosca,
> > > > > > > > http://www.thatlldoit.com
> > > > > > > > Founder - MS_Access_Professionals
> > > > > > > >
> http://tech.groups.yahoo.com/group/MS_Access_Professionals/
> > > > > > > > Microsoft Office Access MVP
> > > > > > > > http://mvp.support.microsoft.com/profile/Bill.Mosca
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --- In
> > > > > MS_Access_Professionals@yahoogroups.com, "buffalome90210"
> > > > > > > > <buffalome90210@> wrote:
> > > > > > > > >
> > > > > > > > > Well I asked for info on using gif files in
forms, I
> was
> > > > > aware of
> > > > > > > > > gif89.dl, but in vista it does not seem to
register
> > > properly.
> > > > > > The lack
> > > > > > > > > of feedback indicated to me that this is a topic
no
> one
> > > wants
> > > > > to
> > > > > > > > > touch, either because it's stupid, or They don't
> know,
> > > > > perhaps the
> > > > > > > > > question itsel is in error. None the less I
assumed
> there
> > > > > must be a
> > > > > > > > > better way. So converted the gifs to swf...I used
the
> > > ActiveX
> > > > > > > > > component, and thats fine, But what do I use to
catch
> the
> > > > > event. It
> > > > > > > > > does not seem to trigger a Click even, or move
event,
> I
> > > tried
> > > > > > placing
> > > > > > > > > a transaprent rectangle on top, but that didnt
work ??
> > > > > > > > >
> > > > > > > > > Puzzled ?
> > > > > > > > > Terence

[Non-text portions of this message have been removed]