Visual Basic Discussion Boards

John Kuhn16-Feb-04 18:40

16-Feb-04 18:40

OleDbException is generic for lots of things. Depends on what you were trying to do and what your code looks like.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

Re: unhandled exception

LokmanHakim16-Feb-04 18:44

LokmanHakim

16-Feb-04 18:44

one more thing....what exactly insertcommand.executenonquery do? Confused | :confused:

Re: unhandled exception

John Kuhn16-Feb-04 19:30

John Kuhn

16-Feb-04 19:30

Assuming that "insertcommand" refers to an instance that has been initialized as an OleDbCommand object that has its command text set to an "INSERT INTO ..." statement, then insertcommand.ExecuteNonQuery() should execute the command without returning the affected records.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

Re: unhandled exception

LokmanHakim16-Feb-04 19:35

LokmanHakim

16-Feb-04 19:35

John Kuhn wrote:
without returning the affected records.

what does it mean?

Re: unhandled exception

John Kuhn16-Feb-04 20:06

John Kuhn

16-Feb-04 20:06

MSDN: Executes a SQL statement against the Connection and returns the number of rows affected.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

Re: unhandled exception

LokmanHakim16-Feb-04 20:08

LokmanHakim

16-Feb-04 20:08

owh....ok...thanx man...sorry for taking your time

Get the application icon

ltt1916-Feb-04 14:39

ltt19

16-Feb-04 14:39

Hi,

Does someone knows how to get the default icon from other applications without using Windows APIs?

Any ideas could be very helpfull,

Thanks in advance

Make vbKeyReturn equivalent to vbKeyTab

nvmoss16-Feb-04 4:12

nvmoss

16-Feb-04 4:12

I have developed a data entry form and set the tab order, but in entering data, it seems more intuitive to use the Enter Key than the Tab to change the focus to the next text box. Is there a way to make these two keys work the same way in this application?

Thanks!

nvmoss

Re: Make vbKeyReturn equivalent to vbKeyTab

jimpar16-Feb-04 6:10

jimpar

16-Feb-04 6:10

you could trap for keycode of 13

Re: Make vbKeyReturn equivalent to vbKeyTab

nvmoss16-Feb-04 10:01

nvmoss

16-Feb-04 10:01

Thanks!

I'm new at this.

I assume that key code 13 is the Enter key, but how do I "trap" it?

Thanks Again!

nvmoss

Re: Make vbKeyReturn equivalent to vbKeyTab

Nick Seng16-Feb-04 15:22

Nick Seng

16-Feb-04 15:22

You "trap" it by adding this code in the KeyDown event

If e.KeyCode = Keys.Enter Then

End If

HTH

"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.

Support Bone

It's a weird Life

Re: Make vbKeyReturn equivalent to vbKeyTab

Charlie Williams16-Feb-04 15:53

Charlie Williams

16-Feb-04 15:53

I don't know why, but KeyPress tends to work better for this (for me, at least) than KeyDown.

' include whatever controls you want to have this functionality
Private Sub KeyPressed(ByVal sender As Object, ByVal e As KeyPressEventArgs) Handles _
    TextBox1.KeyPress, TextBox2.KeyPress, TextBox3.KeyPress, TextBox4.KeyPress 
    If e.KeyChar = ChrW(13) Then
        ProcessTabKey(True)
        e.Handled = True
    End If
End Sub

This isn't the only way to do what you want, but it works.

Charlie

if(!curlies){ return; }

Create Windows Local Users

msrinivasrao16-Feb-04 1:50

msrinivasrao

16-Feb-04 1:50

Hi,

Help me, how we can create windows local user by program.

srinivasraom

ERROR IN SETUP(CANT VIEW CRYSTAL REPORT IN CLIENTS SYSTEM)

Tasnim16-Feb-04 0:59

Tasnim

16-Feb-04 0:59

Hi ,,,
I have made an application which uses CrystalReport 8.5 Viewer(that comes with .net setup). I made a setup so that the client can view the reports. I read in the help file that to include all the files for CrstalDecisions we need to include 3 Msm files i.e. merge modules in the setup. They are MANAGED_ENU.MSM, DATABASE_ACCESS_ENU.MSM, REGWIZ.MSM. I couldnt find MANAGED_ENU.MSM, instead of it I included MANAGED.MSM. I also couldnt find DATABASE_ACCESS_ENU.MSM, instead of it I included DATABASE_ACCESS.MSM. They contain the files needed for CrystalDecisions. But when I included REGWIZ.MSM , it doesnt show me any files in the list(When we see the file list in Mergemodule by including it in the setup). It shows empty list. As per the help file, REGWIZ.MSM contains a file called KEYCODEV2.DLL. But its missing in the MSM FILE. And the error I am getting when I try to open the report at clients place is "INVALID KEY CODE". So where should I find these three files so that I can include it in the project. I searched it on the net but could nt get any of these files.
What are the other options for this error???

Sleepy | :zzz:

Thanks Tasnim

Re: ERROR IN SETUP(CANT VIEW CRYSTAL REPORT IN CLIENTS SYSTEM)

Pugman81216-Feb-04 8:40

Pugman812

16-Feb-04 8:40

I got this error once when i registered .net. What i did to correct the problem if this helps at all i uninstalled the crystal reports portion of the .NET installation and reinstalled.This seemed to correct my problem hope this helps.

Interesting Problem in Deployment

Het210916-Feb-04 0:35

Het2109

16-Feb-04 0:35

Hi
I have prepared an application in VB.Net, i have used Crystal Report 9 to make Reports. Component on VB.Net Form i am using is the one which comes together with the VS.Net, i.e of Crystal Report 8.5. So when i make setup (i include all the necessary files like Crystal Descision files) setup installs the product successfully but when i run the project it gives error of KeycodeV2.dll not found, but it is there in the desired path.
Can anyone help me for the problem, it would be really nice as only this report portion is left.

Thanks for going through

Smile | :)

Be Humble in Victory and Strong in Defeat. Smile | :)

-Het

Re: Interesting Problem in Deployment

Ian Darling16-Feb-04 0:48

Ian Darling

16-Feb-04 0:48

Het2109 wrote:
gives error of KeycodeV2.dll not found, but it is there in the desired path

Did you get a licence key for Crystal Reports? I had this problem, and if I remember correctly, to fix it you get a (free) licence key from Crystal Decisions, and stuff that into the Serial Key (?) property for the Crystal merge module in your setup.

It's something like that anyway, I mentally purge myself of Crystal related things as far as possible Smile | :)

Ian Darling
"One of the few systems...which has had “no deaths” in the reliability requirements." - Michael Platt

Free VB.Net and C# Training

Tony M John15-Feb-04 15:11

Tony M John

15-Feb-04 15:11

http://www.dotnetspider.com/technology/ Rose | [Rose]

open a document

aguest15-Feb-04 9:28

aguest

15-Feb-04 9:28

i want make an application who open one document word or excel.and i want to know how to do that .

Re: open a document

-Dr_X-15-Feb-04 16:15

-Dr_X-

15-Feb-04 16:15

Look at my post from earlier this week. It should get you started.

http://www.codeproject.com/script/comments/forums.asp?msg=738597&forumid=1646#xx738597xx

Michael

I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)

Re: open a document

Anonymous17-Feb-04 14:59

Anonymous

17-Feb-04 14:59

sorry,but the link don't work, can you give me an other link.
thank you

Re: open a document

Het210916-Feb-04 19:55

Het2109

16-Feb-04 19:55

ProCess.STarT("filename") will open a doCumenT in word exCel or any doCumenT u desire To open.

Smile | :)

Be Humble in Victory and Strong in Defeat. Smile | :)

-Het

HowTo: Read Sound Volume in RealTime

ahecker15-Feb-04 2:25

ahecker

15-Feb-04 2:25

Hello,
when i play a sound file like mp3 or wav with MediaPlayer or anything like
this, i would like to get the volume level of the sound card in real time.
The data is then sent to the serial port. How do i get this data. I tried to
find some samples in msdn or internet but i couldn t find any useful code.
There is the winmm.dll which supports calls to waveIn and waveOut but all
the samples use them to set or get the master volume. That is not what i
need. I thought i found a sample in msdn, but this doesnt work. Is directX a
way to solve this problem?
Can anybody
help me??

Re: HowTo: Read Sound Volume in RealTime

Dave Kreskowiak15-Feb-04 16:37

Dave Kreskowiak

15-Feb-04 16:37

Do you want the "volume level" or the sampled peaks of the output going to the speakers?

Volume is simple, you've already found the code for it.

Sampling the output is a whole other story. Now you have to consider getting the output of 1 to 8 speakers. This sampling can occur very fast, but can your serial port implementation keep up with the rate of data you want to transmit? How fast are you looking at sending data out the serial port?

You might want to look at this[^] link for a sample on MSDN.

RageInTheMachine9532

How to Insert Table in Rich Text Control

Sumit Kapoor15-Feb-04 0:15

Sumit Kapoor

15-Feb-04 0:15

Can anybody tell me..How to insert table in richtextbox control as in MS word..I'll be helpful to u...PLease help me sir..
I'll be very thankful to u.
OK! Good Bye...Have a Nice Life..Bye. Sumit Kapoor

---Sumit Kapoor---

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