?
Solved

Does anyone know how to sound a chime using MS-ACCESS?

Posted on 2011-09-22
10
Medium Priority
?
275 Views
Last Modified: 2013-11-28
Hello,

I would like to sound a chime and also turn a strobe light on and off programatically using MS Access.
I will execute the code as part of an OnClick routine for a command button.

Upon clicking the button, it is my objective for a doorbell-like sounding device in another building to chime.  In addition, I would like a strobe light to turn on.

Does anyone have any ideas?

PC
0
Comment
Question by:pcalabria
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 668 total points
ID: 36582273
Note that strobe lights can cause seizures in many people:

http://www.wired.com/wiredscience/2007/06/mias-new-websit/
http://serendip.brynmawr.edu/exchange/node/1718
...et al


To do what you are asking you would have to create a system to interface with AC outlets, via some output from the computer
(Com Port, Usb Port)
In other words, this cannot be done by "Access" alone.

Let's see if any other Experts have done this already and can provide more input...

JeffCoachman
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36582427
I agree with Jeff.  You need some kind of device that sounds the chime and engages the lights on demand.  I would suggest a network-attached, remotely controllabe switch, for example:

http://www.ambery.com/reposw.html

or

http://dataprobe.com/iboot_dc8_remote_power_control.html

Getting Access to control such a switch is technically feasible, however, the details are totally dependent on the interface that the device exposes.   In any case, I would start with finding a device that is capable of switching the lights/chime, then work backwards to Access from there.


0
 
LVL 44

Expert Comment

by:GRayL
ID: 36582446
Here's how to do the sound.

http://support.microsoft.com/kb/95647
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:pcalabria
ID: 36584409
Okay, Jeff, maybe I'll go with a rotating beacon! :-)

These are all links to some cool stuff, but I"m not sure how I would write code to replace the browser interface.

Has anyone ever heard of or done anything with x10?  I'm thinking about using a USB-CM15A from http://ActiveHomePro.com

They make a device that plugs into a USB port that has the ability to turn on and off appliances, however, I would need VBA code to control the USB device.

I don't know how I would make my software talk to the software that comes with the USB controller.

0
 
LVL 42

Assisted Solution

by:dqmq
dqmq earned 664 total points
ID: 36584964
>They make a device that plugs into a USB port that has the ability to turn on and off appliances

As long as they are on the same electrical secondary.   If the switched devices are in a separate building from the Access workstation, that's unlikely.


>I don't know how I would make my software talk to the software that comes with the USB controller.

ActiveHomePro comes with a software development kit that, according to the website, should work from Access VBA.  But check with the vendor to be sure.



0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36585109
<Okay, Jeff, maybe I'll go with a rotating beacon! :-)>
Yeah, where I work, we deal with developmentally disabled individuals, so anything that "strobes" is forbidden...
;-)
0
 
LVL 61

Expert Comment

by:mbizup
ID: 36586053
Did you try the method at the link posted by GrayL?

I personally could not get that to work - got an error claiming that the file could not be found, despite the path being accurate.

There is also this:

application.FollowHyperlink "C:\chimes.wav"


Of course, that's for the user's computer - not a seperate building!
0
 

Author Comment

by:pcalabria
ID: 36593536
GrayL and mbiz... thanks for the help.
I've made note of the code and I'm sure I'll use it somewhere... I like it much better than the BEEP that I've used before...

but it won't work for this application.   The people in that back are too far from the computers...

Also, thanks again about warnings with strobes... had not considered the consequences at all..

I ordered the x10 USB device and will give the code a try... if it strays much from Access VBA I'll be lost!  The manufacturer isn't able to offer any more support than what's in the develpment kit.  I have no idea how complete it will be.
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 668 total points
ID: 36710802
Years ago, I created a database that interfaced with (literal) black boxes that had red, yellow and green lights that lit up when a choice was made in a form.  They were connected to the computer by a serial cable, and there was an ActiveX control (created by another programmer) to interface with them.  That is the sort of thing you need here.
0
 

Author Closing Comment

by:pcalabria
ID: 36960507
I decided to use the ActiveHome SDK with a rotating beacon.  Thanks.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question