Re: Need code to detect sound in speaker - Visual Basic Discussion Boards

Gary997-Nov-10 17:45

7-Nov-10 17:45

I need an application that waits for a sound (beep or chime) to be detected in a speaker (maybe via Direct X and sound card). When sound is detected, I want code to be run , say for now, a Msgbox pops up and says "sound dete3cted"

Thanks,

Gary

Re: Need code to detect sound in speaker

Eddy Vluggen8-Nov-10 6:49

Eddy Vluggen

8-Nov-10 6:49

Gary99 wrote:
I want code

You sound like you're ordering a pizza Smile | :)

AFAIK, Windows doesn't raise any events when sound is played. If you only need to "detect" sound, then you might want to google for a VU meter. That would still only react to a sound-card, not the internal speaker.

Or switch the microphone on, actively listening for sounds. That's probably not a practical solution, since it would also give you background-noise.

I are Troll Suspicious | :suss:

Re: Need code to detect sound in speaker

Gary998-Nov-10 9:42

Gary99

8-Nov-10 9:42

Hi - No, it's not for pizza. I googled and was not able to find a simple way to detect sound. Would DirectX be a possibility ? I don;t know where to look for sample code.

Thanks,

Gary

Re: Need code to detect sound in speaker

Eddy Vluggen8-Nov-10 10:47

Eddy Vluggen

8-Nov-10 10:47

Gary99 wrote:
I don;t know where to look for sample code.

There's always the CodeProject articles[^] that provide sample code.

Do you want to detect a sound that you're making yourself, or from a third party?

I are Troll Suspicious | :suss:

Re: Need code to detect sound in speaker

Gary998-Nov-10 10:56

Gary99

8-Nov-10 10:56

Hi, thanks for your interest. I believe it's a third party. I get a pop up and bell or chime rings in external speaker. I want to know it happened if I am away from my PC. I think I can write a routine to text me on my cell phone via MS Outlook when a sound is detected. So i need a routine that I can add a call to my routine to send a text message.

Thanks,

Gary

Re: Need code to detect sound in speaker

Eddy Vluggen8-Nov-10 20:31

Eddy Vluggen

8-Nov-10 20:31

Gary99 wrote:
I get a pop up

It'd be easier to watch for the popup than to detect a sound; there's multiple ways of looking whats "on screen" from code, but I haven't seen a way to listen to what's currently playing.

I are Troll Suspicious | :suss:

Re: Need code to detect sound in speaker

Gary999-Nov-10 0:28

Gary99

9-Nov-10 0:28

Hi - I can't stay glued to PC. I want to be able to move around. I have working VB code that will send me an email when triggered. The problem is I don;t have the trigger (yet). Thanks,

Gary

Re: Need code to detect sound in speaker

Eddy Vluggen9-Nov-10 6:59

Eddy Vluggen

9-Nov-10 6:59

Gary99 wrote:
I can't stay glued to PC. I want to be able to move around.

That does not change my previous statements, as they are based on technical limitations.

Gary99 wrote:
The problem is I don;t have the trigger (yet).

Windows doesn't pull a trigger when it's playing a sound, there's no notification-mechanism that could be described as "easy". Working your way through a VUmeter-example amd adapting that would be the easy route. The DirectX example only showed how to check if a sound is finished that you started yourself - that's not the same as intercepting a playsound-command from a third-party application.

So, now that we know that you can't stay glued to your PC, and that catching sound is hard - would it be an option to look for alternatives? Might become a bit frustrating, but that makes it more fun and rewarding when one finds a relevant solution.

You said it was a sound and a popup. What application raises the notification? The popup could perhaps be identified by enumerating all windows.

I are Troll Suspicious | :suss:

Re: Need code to detect sound in speaker

Gary9910-Nov-10 0:23

Gary99

10-Nov-10 0:23

The pop up flashes for a few seconds and disappears on its own. I tried w/o success to use Enumwindows and look for window title. It was never detected. Any sample code to look for a particular window title from an application I can not control ? could the pop-up be a child window of the other application and i need different API to find it ? Thanks, Gary

VB.Net - Printer queue propeties

directred4-Nov-10 6:53

directred

4-Nov-10 6:53

Hi,

I am doing a project and wonder if anyone can point me in the right direction. I want to within VB.Net control a printer's print queue. I want to be able to view, pause or cancel a print job e.g. sent a document to the printer at a pause state, then able to print it. Don't know if you can just view a certain user's documents as well e.g.

User Document
A Let1.doc
B Rent.doc
A Cash.xls

Able just to display
A Let1.doc
A Cash.xls

Any ideas would be gratefully appriciated.

Re: VB.Net - Printer queue propeties

DaveAuld4-Nov-10 7:50

DaveAuld

4-Nov-10 7:50

I think that this sits very much in the WMI arena.

Have a search on google for WMI Printer Queue scripts, and then start to research this subject.

If you also search for WMI VB.NET you will get examples of how to integrate the scripts into the vb.net code.

Dave
Find Me On: Web|Facebook|Twitter|LinkedIn

CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.

search between two dates

waner michaud4-Nov-10 5:29

waner michaud

4-Nov-10 5:29

Hi,

I have form that has a date_from and date_to..
One table (id, reg_no, reg_date, desc)

I want to search between those two dates from the form against reg_date on the table..
Using vb.net and sql express..

Thanks in advance

Re: search between two dates

Thomas Krojer4-Nov-10 5:35

Thomas Krojer

4-Nov-10 5:35

this can be done in sql with the 'between' construct in the 'where' clause.

Re: search between two dates

Dr.Walt Fair, PE4-Nov-10 5:47

Dr.Walt Fair, PE

4-Nov-10 5:47

What he said.

If you want more flexibility you can also use something like
"SELECT * FROM table WHERE (reg_date > " & MyDate1 & ") and (reg_date < " & MyDate2 & ")"

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: search between two dates

waner michaud4-Nov-10 6:26

waner michaud

4-Nov-10 6:26

Thanks,

I tried this: Select * from FireArmsTD_View
Where (FrireArms_date > " & DateFrom & ") And (FrireArms_date < " & DateFrom & ")

I got invalid column name for both ' & DateFrom & ' and ' & DateTo & '

thanks

Re: search between two dates

Dr.Walt Fair, PE4-Nov-10 6:34

Dr.Walt Fair, PE

4-Nov-10 6:34

As written, your "s are not correct and DateFrom is shown twice, but I'll assume those are just typo's.

Make sure that DateFrom and DateTo are showing up as strings. I guess I forgot to mention that, and that they need to be enclosed in quotes. I usually create a string variable to check while debugging.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: search between two dates

Scubapro9-Nov-10 19:34

Scubapro

9-Nov-10 19:34

Try this:

select * from FireArmsTD_View 
where FrireArms_date between to_date('&DateFrom','mm-dd-yyyy') and to_date('&DateTo','mm-dd-yyyy')

Btw, is better to use the 'Database Board' for these kind of questions.

Re: search between two dates

Luc Pattyn4-Nov-10 6:37

Luc Pattyn

4-Nov-10 6:37

Two warnings:

1.
IIRC the SQL BETWEEN keyword is a bit dangerous as different implementations use different definitions; the issue is inclusive versus exclusive, i.e. does an exact match with a border get included or not. Read the doc, or use explicit comparisons.

2.
Use SQLParameter to avoid all datetime formatting and regional settings issues; it's much better/cleaner/safer than string concatenation anyway.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

modified on Thursday, November 4, 2010 12:58 PM

Re: search between two dates

waner michaud4-Nov-10 7:37

waner michaud

4-Nov-10 7:37

Hi,
I am a novice, just don't know how. will you guide me?

thanks

Re: search between two dates

Luc Pattyn4-Nov-10 8:04

Luc Pattyn

4-Nov-10 8:04

The documentation and examples on SQLParameter are plenty, maybe you want to read Beginners guide to accessing SQL Server through C#[^] which uses C# but the same types and ideas are valid in VB.NET

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

A stranger question about Selectsinglenode method

sanyexian2-Nov-10 23:42

sanyexian

2-Nov-10 23:42

Hello,everyone! Now I use the method "selectsinglenode" with xpath to search in my XML, I find a stranger question.In my project, when I used this method at first, it didn't get the node that I wanted, so I created a new project to try the xpath, it could got the node now.(The same xpath and same XML file) Then I deleted some controls in my project which was about the method(not the new one), create new, then the method could find the node!
I can't understand it, same xpath, same function,same value,why it happens? Confused | :confused:

Hope some one could tell me the reason and give me some suggestion!Thank you!
The function that I used to search a node was like below:

Dim val As String = ""
        Dim xmldoc As New XmlDocument()
        Dim xpath As String
        Try
            xmldoc.Load(Application.StartupPath + "\Flange\Nozzle-Flange-Height.xml")
            Dim xmlnode As XmlNode
            If Not (Standard = "") Then
                xpath = "/Nozzle-Flange-Height/Standard[@value='" + Standard + "']/Flange-type[@type='" + Type + "']/PN[@PN='" + PN + "']/Height[@DN='" + DN + "']"
                xmlnode = xmldoc.SelectSingleNode(xpath)
                If Not xmlnode Is Nothing Then
                    val = xmlnode.InnerText
                Else
                    MsgBox("Could not find!")
                End If
            Else
                val = ""
                MsgBox("Input by yourself!")
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        Return val

Zipping files

crain19812-Nov-10 6:11

crain1981

2-Nov-10 6:11

Does anyone know of any third party (i know this is where I have to go) vb library that can search the contents of a zip file without unzipping the file? This will also have to happen when I have to add a file as well.

Re: Zipping files

Dr.Walt Fair, PE2-Nov-10 7:24

Dr.Walt Fair, PE

2-Nov-10 7:24

Uhhh, to find out what is inside a compressed file, you will have to uncompress at least part of it. Whether you save the uncompressed files or quit before it's finished is another matter.

In the meantime, here are some options[^]

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: Zipping files

Eddy Vluggen2-Nov-10 9:26

Eddy Vluggen

2-Nov-10 9:26

You could have Google Desktop[^] index the zip-files and query that. It supports .zip, but I'm not sure whether it also indexes the contents of those archives. If it doesn't, then there's probably some plug-in available that does Smile | :)

I are Troll Suspicious | :suss:

Re: Zipping files

AspDotNetDev2-Nov-10 15:11

AspDotNetDev

2-Nov-10 15:11

crain1981 wrote:
search the contents of a zip file without unzipping the file

What do you mean by that? Do you mean without unzipping the file to the file system? Because you are going to have to have access to the uncompressed data at some point to search it. You might try searching for something that allows you to uncompress zip files to a stream rather than a file... that would at least keep it in memory, then you could perform a search on that data.

This might provide some guidance. Not sure about that though, as I've not tried zipping/unzipping from .Net before.

[Forum Guidelines]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.