Results 1 to 8 of 8
  1. #1
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368

    sound notifications

    Hi all,



    Is there a global setting to have a sound play when an action is done? Many times I am running a query and have the web open on top of Access and would like to know when the query is done. Sometimes the taskbar will flash but sometimes it wont. I know this can be done on a per-query basis but is there a setting or something I can change for this to happen every time, regardless of query?

    Thanks

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I 'think' you can just issue a Beep command.

    I populate a caption box on a form when a query is done and then issue a Forms!MyFormName.repaint command so the text refreshes on the form.

    Not sure about other sound but I'd like to know also. I wonder if an activeX control would need to be used.

  3. #3
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    thats the thing. the queries arent done via form or macro. they are all adhoc stuff i create on the fly.

  4. #4
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    FYI: I just found an example that plays different kinds of sounds (seems to be easy-to-follow coding.)

    I posted the example here: https://www.accessforums.net/code-re...html#post29741

  5. #5
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694

  6. #6
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    ajetrumpet - that would make a great example for the code repository. Any chance you could post your example coding there?

    https://www.accessforums.net/code-repository/

    I also added a link to your post in the code repository link I had posted.

  7. #7
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    none of these are what im looking for. thx for the ideas though =/

  8. #8
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    How about a progress bar?

    https://www.accessforums.net/code-re...-bar-7700.html

    This is what I like to do. I set a variable (ie. X) and increment it after certain code runs.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. inserting .wav sound?
    By dada in forum Programming
    Replies: 2
    Last Post: 08-20-2010, 11:25 PM
  2. How to stop sound playing
    By trirat in forum Programming
    Replies: 0
    Last Post: 03-12-2006, 06:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums