Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Mar 3 10:50:55 CST 2005
Thanks all. I'm beginning to get the idea. Confirming clicking is not a
desirable feature. Makes this whole problem of running an embedded wav file
moot as well. :)
Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334
----- Original Message -----
From: "Jim Hewson" <JHewson at karta.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, March 03, 2005 8:16 AM
Subject: RE: [AccessD] Embedding a WAV file
>I have the sound turned down or mute on most of the machines I use.
> I don't hear the clicks, etc. I do hear music and the like when I need to
> but that is seldom.
> The constant sounds of the mouse and keyboard are all the confirmation I
> need.
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Thursday, March 03, 2005 9:54 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Embedding a WAV file
>
>
> A.D.:
>
> Thanks again. We got feedback from one beta tester who wanted to know how
> to turn off that annoying click. So the question may be moot.
>
> So here's a user interface question for anyone - we put the click sound
> behind all of the command buttons as an audible confirmation to the user.
> This product is end-item consumer oriented - not to pros or techies. So
> some of the interface problems are a bit different than I've previously
> encountered. Do you think you'd like or dislike a click or beep sound
> every
> time you click the Next button?
>
> Regards,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
>
>
>
> ----- Original Message -----
> From: "A.D.Tejpal" <adtp at touchtelindia.net>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, March 02, 2005 8:48 PM
> Subject: Re: [AccessD] Embedding a WAV file
>
>
> Rocky,
>
> Playing a wave sound through OLE control does not cause any intrusion
> by
> way of invoking a music player (like Real or Windows Media Player). Just
> try
> it. Absolutely normal except for the focus going to OLE control.
>
> If you are keen to try the API alternative, a way will have to be found
> to extract the sound clip from OLE object and place it in a suitable
> folder.
> This takes us back to square one, i.e. the wav files could as well have
> been
> stored in a special folder - to start with.
>
> Practical demonstration of playing a wav file using API call, after
> searching for it (if available in the target folder), is covered in my
> sample db named AppointmentsAlert, available at Rogers Access Library
> (other
> developers library). Link -
> http://www.rogersaccesslibrary.com
>
> Best wishes,
> A.D.Tejpal
> --------------
>
> ----- Original Message -----
> From: Rocky Smolin - Beach Access Software
> To: Access Developers discussion and problem solving
> Sent: Thursday, March 03, 2005 01:02
> Subject: Re: [AccessD] Embedding a WAV file
>
>
> A.D:
>
> Well that does work, but instead of playing it straight through the
> speakers like the function:
>
> Declare Function sndPlaySound Lib "winmm.dll" Alias "PlaySoundA" _
> (ByVal IpszName As String, ByVal hModule As Long, _
> ByVal dwFLags As Long) As Long
>
> does, it invokes a player - in my case RealPlayer. Do you know of a way
> to use the function with an embedded wav file?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
>
> ----- Original Message -----
> From: "A.D.Tejpal" <adtp at touchtelindia.net>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, March 02, 2005 10:48 AM
> Subject: Re: [AccessD] Embedding a WAV file
>
>
> Rocky,
>
> Sample code given below, pertains to bound OLE control named Drg.
> Record
> source for the form is a table having wav sounds stored in this field.
> CmdSound is the name of command button used for playing the sound
> pertaining
> to current record.
>
> It may please be noted that when the sound clip is played, the focus
> gets captured by the OLE control.
>
> Best wishes,
> A.D.Tejpal
> --------------
>
> ==============================
> Private Sub CmdSound_Click()
> On Error Resume Next
> If Drg.OLEType = acOLENone Then
> MsgBox "No Recording"
> Else
> Drg.Action = acOLEActivate
> End If 'Drg
> On Error GoTo 0
> End Sub
> ==============================
>
> ----- Original Message -----
> From: Rocky Smolin - Beach Access Software
> To: Access Developers discussion and problem solving
> Sent: Wednesday, March 02, 2005 22:55
> Subject: Re: [AccessD] Embedding a WAV file
>
>
> Darren:
>
> When I do the installable run-time I think I can include my WAV file
> and
> it
> will be transparent to the user. For beta testing I need to send them
> just
> one file. So I'm still looking for a way to do this.
>
> I did insert-->Object-->from file and inserted the wav file in an
> Unbound
> Object Frame. But getting it to play in the On Click events of other
> controls, like command buttons, is the next problem. And then, I would
> probably have to insert this UOF in every form.
>
> Is there maybe a way of putting it into a field in a table and running
> it
> from there so it could be run from any form?
>
> TIA
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
>
> ----- Original Message -----
> From: "Darren DICK" <d.dick at uws.edu.au>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, March 01, 2005 5:18 PM
> Subject: RE: [AccessD] Embedding a WAV file
>
>
> > Hi Rocky
> > I have a folder in the App home folder for sounds. Also one for
> Images
> and
> > Skins etc
> > EG
> > C:\Program Files\My app will be the 'home' folder
> > And in it will be
> > C:\Program Files\My app\Sounds (About 5 or 6 files in here)
> > C:\Program Files\My app\Images (3 more folders and about 20 files in
> here)
> > C:\Program Files\My app\Skins (1 folder (but it can grow) and many
> files
> > in
> > here)
> >
> > I install them when I install the app.
> > They are my 'standard' folders and files and go with every app.
> > And I refer to them now by heart with lines like
> > (I actually use globals for the length of the session But can be done
> at
> a
> > form Sub level just as easy)
> > EG
> > Dim strSkinToUse as String
> > Dim strSkinFolder as String
> > Dim strImagesFolder as String
> >
> > strSkinToUse = Dlookup("[SkinName]","tblOptions")
> > strSkinFolder = Left(CurrentDb.Name, Len(CurrentDb.Name) -
> > Len(Dir(CurrentDb.Name)) - 1) & "\Skins\" & strSkinToUse
> > strImagesFolder= Left(CurrentDb.Name, Len(CurrentDb.Name) -
> > Len(Dir(CurrentDb.Name)) - 1) & "\Images"
> > strSoundsFolder= Left(CurrentDb.Name, Len(CurrentDb.Name) -
> > Len(Dir(CurrentDb.Name)) - 1) & "\Sounds"
> >
> > Then I refer to each skin component like.....('Cause I know 'em off
> by
> > heart)
> >
> > Me.picture = strSkinFolder & "\Background.jpg"
> > Me.imgMyLogo = strImagesFolder & "\OurLogo.jpg"
> >
> > I use the API code "PlaySound" for Playing Sounds
> > Eg
> > Private Sub Form_Load()
> > PlaySound (strSoundsFolder & "\Logon.wav")
> > End sub
> >
> > It works and is pretty simple.
> >
> > HTH
> >
> > See ya
> >
> > Darren
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>