Visual Basic

ChandraRam21-Jul-10 2:25

ChandraRam

21-Jul-10 2:25

Steven J Jowett wrote:
Chr(8) which is a audio beep

I think that is a back-space character... (7) is beep, if I remember right.

Luc Pattyn21-Jul-10 0:37

Luc Pattyn

21-Jul-10 0:37

here is a shocking thought: the manufacturer could have hidden such information in some manual. Did you check?

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.

DaveAuld21-Jul-10 1:43

21-Jul-10 1:43

wow, do manufacturers produce manual, sheesh, the next thing is they will be creating websites with forums, faq's and KB's....

Dave

Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

AnnieMacD21-Jul-10 2:52

21-Jul-10 2:52

It may very well require a series of codes to open the drawer. Have you tried this web site?
http://pages.prodigy.net/daleharris/popopen.htm[^]

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

melvintcs9-Dec-11 0:02

melvintcs

9-Dec-11 0:02

got any solution for this? i facing the same problem, i got the drawer code, but i duno how to implement it.

Cash Drawer code: 27, 112, 0, 100, 250

Communication with Panasonic PABX phone [modified]

εїзεїзεїз11-Dec-11 22:42

εїзεїзεїз

11-Dec-11 22:42

Best and fastest way to implement this contact the Manufacturer of printer and ask them to give SDK. after hectic effort i had got the SDK from the Manufacturer.

SOFTDEV

Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.

FuzMic20-Jul-10 18:55

FuzMic

20-Jul-10 18:55

Hi everybody

I have been with this forum for sometime but this is the 1st time i post a question and is not sure if this the right place to start this question.

I am tinkering to build a vb.exe wherein it will communicate with a Pansonic PABX telephone system through a USB or Com port using the MSComm object. The objective here is to pick up the data coming from the PABX such as time of call, duration, destination number and costs of call plus sending out data to tell the various extension to ring at certain predetermined time or to bar the extension.

It is said that Telephony Application Programming Interface (TAPI) is a Microsoft Windows API, which provides computer telephony integration and enables PCs running Microsoft Windows to use telephone services can do do the job.

This being the first time i tinker into communication issues i am not sure if using the msComm is the right step. I feel that TAPI is a more complex way to go.

More importantly i am not sure what protocol the PABX will work on. My attempts to talk to Panasonic company on this had not been too fruitful.

Any pointers from members of this forum will much appreciated.

modified on Wednesday, July 21, 2010 1:08 AM

Re: Communication with Panasonic PABX phone

DaveAuld22-Jul-10 9:02

Re: Communication with Panasonic PABX phone [modified]

22-Jul-10 9:02

What is the model of the PABX?

I doubt TAPI is the way to go, that will be more for actually placing calls,sending fax's etc.

I would imagine it would use a serial protocol via a usb or DB-9/RS232 port.

This site ( http://www.pbxguru.com/[^] )makes reference to programming software etc. for panasonic exchanges, so it must be possible, hence the reason for asking the model.

The may use some strange non-standard protocol i.e. the actual message send and received by the unit, and it maybe is not in the public domain. and the port is used by their own software.

Until you provide the model, it would be difficult to determine how it is done.

Dave

Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

FuzMic22-Jul-10 17:55

FuzMic

22-Jul-10 17:55

Thanks Dave

The model was Panasonic KX-TD500, but the new version is now TDA200ML.

I am comfortable with rs232 port as i have tinkered with the comm1 object properties & events namely .portOpen, .commEvent & .input via the reference mscomm32.oca.

I have no actual experience communicating with a PABX. I need to understand the string to send to & from and all the properties / parameters in the system.

I had a look at your proposed link and was reading the "help" from the programmer application for KX-TD500 and just wondering if it can handle the new TDA200ML. Are you in any way related to the info@voicecallcentral.com?

Thanks again & waiting for further advice.

modified on Friday, July 23, 2010 12:32 AM

Checkbox in datagridview

waner michaud20-Jul-10 9:45

waner michaud

20-Jul-10 9:45

Hi,

I add a checkbox in a datagridview that is an unbound column. Onload it is an unchecked state, when I click on it, I get this error message Index -1 does not have a value. I am lost..

what i want to do is to able to check and uncheck the checkbox to do insert, delete current row selected...

Can anyone guide me please..

thanks advance

Re: Checkbox in datagridview

Scubapro20-Jul-10 19:31

Scubapro

20-Jul-10 19:31

Then probably your row contains no (actual) data.

But why use a checkboxcolumn for this and not .SelectedItems ?

Replacing & during conversion of Excel to XML using VBA

priyaahh20-Jul-10 6:01

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 6:01

Hi Friends,

I am converting an excel to xml using vba. THere this excel data having &. But when converting & to xml it is giving error. So I am using the following funtion to replace &.

Function RemoveAmpersands(AnyStr As String) As String
Dim MyPos As Integer
' replace Ampersands (&) with plus symbols (+)
MyPos = InStr(1, AnyStr, "&")
Do While MyPos > 0
Mid(AnyStr, MyPos, 1) = "+"
MyPos = InStr(1, AnyStr, "&")
Loop
End

But the above function replacing with +. But I wanted to display in the browser as & only. Kindly Help.

Regards,
Priya.

riced20-Jul-10 6:53

riced

20-Jul-10 6:53

Would using & fix the problem?

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

Re: Replacing & during conversion of Excel to XML using VBA

priyaahh20-Jul-10 20:04

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 20:04

HI

Thanks. I have not tried it ..let me try and reply

Thanks,
Priya.

priyaahh21-Jul-10 1:24

Re: Replacing & during conversion of Excel to XML using VBA

21-Jul-10 1:24

Hi,

& is not working. Its going into infinitely....Any other approach to implement this?

Thanks,
Priya.

DaveAuld20-Jul-10 7:09

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 7:09

Forgot how to use code blocks already?

Did you get your previous xml problem working in the end, didn't hear any more in the thread?

Dave

Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

priyaahh20-Jul-10 20:02

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 20:02

Hi Dave,

Thanks. I think you are talking abt the function i ve written..without returning that function..with function name..

I have that line in my code..since it is big code i just copy pasted only first part and end function missed to paste last to previus line.

Here is the function:

Function RemoveAmpersands(AnyStr As String) As String
Dim MyPos As Integer
' replace Ampersands (&) with plus symbols (+)
MyPos = InStr(1, AnyStr, "&")
Do While MyPos > 0
Mid(AnyStr, MyPos, 1) = "+"
MyPos = InStr(1, AnyStr, "&")
Loop

RemoveAmpersands = AnyStr
End Function

If you are trying to say something pls reply..

Thanks
Priya

AnnieMacD20-Jul-10 13:27

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 13:27

priyaahh wrote:
I am using the following funtion to replace &.

Your code replaces all the ampersands (&) in a string with plus (+) which is what you say you want to do.

Then you say:

priyaahh wrote:
But the above function replacing with +. But I wanted to display in the browser as & only.

...so, what exactly do want to achieve?

BTW this would do the same thing in one line.

Dim newStr As String = AnyStr.Replace("&", "+")

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

priyaahh20-Jul-10 20:00

Re: Replacing & during conversion of Excel to XML using VBA

20-Jul-10 20:00

Hi
Thanks. Yes my code is replacing & with +. Because if i display as & in XML it is giving error. But i wanted to display & as & not as +. Is there any wy to display & in XML browser.

Regards,
Priya.

AnnieMacD21-Jul-10 2:42

Re: Replacing & during conversion of Excel to XML using VBA

21-Jul-10 2:42

Then riced's answer (above) is what you need. I found this with Google http://articles.techrepublic.com.com/5100-10878_11-5032714.html[^]

Here's an extract:

Ampersand—&—&
greater-than—>—>
less-than—<—<
apostrophe—'—'
quote—"—"

If I may say so, you seem to make a lot of work for yourself!

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

priyaahh21-Jul-10 23:36

Re: Replacing & during conversion of Excel to XML using VBA

21-Jul-10 23:36

Hi Annie,

Thanks for your reply.

I tried using & but when i use this, I am not getting any output and the application is processing.....and not stopping..I have to use TaskManager and End the application.

Kindly help.

Regards,
Priya.

AnnieMacD22-Jul-10 4:34

Re: IIF strange behaviour

22-Jul-10 4:34

OK, here are two code snippets that illustrate what you need.

<p>
       You can find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&amp;clcid=0x409"
           title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
   </p>

After the 152368 you see ampersand(&), letter a, letter m, letter p then semi-colon(;)? That is what is required in place of the &. This will do the replacement for you:

Dim newStr As String = oldStr.Replace("&", "&amp;")

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

IIF strange behaviour

ddecoy19-Jul-10 21:59

ddecoy

19-Jul-10 21:59

Dim o = IIf(True, "1", CType("", Decimal))

This gives you an invalid cast exception.
weak..

DaveAuld19-Jul-10 22:52