Re: Send a Text Message to a Cell Phone from a VB.NET Application - Visual Basic Discussion Boards

Re: Library not registered in excel 2013 vba

Samoeurn13-Feb-14 22:27

13-Feb-14 22:27

I have One VBAProject that is excel add in. If I use window 8 x86, it works perfectly but now our company upgrade using window x64.it has one problem,one control is not support "Listview" and shows error message below:
1.Library not registered
2.Compile error in hidden module: frmChart
this error commonly occurs when code is incompatible with the version,platform, or architecure
of this application. Click "help" for information on how to correct this error.

please kindly help appreciate

Thanks

Re: Library not registered in excel 2013 vba

Richard MacCutchan13-Feb-14 22:59

Richard MacCutchan

13-Feb-14 22:59

Samoeurn wrote:
code is incompatible with the version,platform, or architecure

Rebuild your addin on the new platform.

Veni, vidi, abiit domum

Re: Library not registered in excel 2013 vba

Eddy Vluggen13-Feb-14 22:33

Eddy Vluggen

13-Feb-14 22:33

Samoeurn wrote:
anybody has idea?

You've referenced a COM-library in your sheet that's 32-bit. It does not get loaded in the 64-bit version of Excel. Then it crashes.

Solution; get a 64 bit version of the library, or switch back to 32-bit Office.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Library not registered in excel 2013 vba

MyOwnBoss7-Mar-14 13:10

MyOwnBoss

7-Mar-14 13:10

Top of each form, modules and classes that have references. Fill in the blanks.

#If Win64 Then
    ' Win64=true, Win32=true, Win16= false
put your 64 bit library references here
#ElseIf Win32 Then
    ' Win32=true, Win16=false
put your 32 bit library references here
#Else
    ' Win16=true
Msgbox "You are either trying to run this from a computer " _
       "you found at a yard sale or you bought an Apple"
#End If

Send a Text Message to a Cell Phone from a VB.NET Application

SURAJIT UPADHYAY13-Feb-14 18:56

SURAJIT UPADHYAY

13-Feb-14 18:56

Send a Text Message to a Cell Phone from a VB.NET Application

Re: Send a Text Message to a Cell Phone from a VB.NET Application

Richard MacCutchan13-Feb-14 21:54

Richard MacCutchan

13-Feb-14 21:54

Why not make an effort to do your own search for examples of code for this. Paste your question into Google for a start.

Veni, vidi, abiit domum

Re: Send a Text Message to a Cell Phone from a VB.NET Application

Simon_Whale13-Feb-14 22:21

Simon_Whale

13-Feb-14 22:21

google gave me this

Send a Text Message to a Cell Phone from a VB.NET Application[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: Send a Text Message to a Cell Phone from a VB.NET Application

MyOwnBoss7-Mar-14 13:52

MyOwnBoss

7-Mar-14 13:52

I hope its not for spamming and spoofing! I am getting tired of Sarah from Consumer Services calling me on a spoofed voip line. I would be more upset if they were wasting my message limit

Creating MySql views

SPSandy12-Feb-14 17:40

SPSandy

12-Feb-14 17:40

Is it possible to create a MySql view using vb2008 If yes can anybody provide with some tips on how to do that.

Thanking in advance.

Re: Creating MySql views

Eddy Vluggen12-Feb-14 22:30

Eddy Vluggen

12-Feb-14 22:30

SPSandy wrote:
Is it possible to create a MySql view using vb2008

Yes.

SPSandy wrote:
If yes can anybody provide with some tips on how to do that.

Using the ExecuteNonQuery method of the IDbCommand class; you'd execute a SQL-query (Google for examples) containing a "CREATE VIEW" statement (again, Google has the syntax).

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Creating MySql views

Eddy Vluggen13-Feb-14 10:11

Eddy Vluggen

13-Feb-14 10:11

My apologies for the above answer; it may be correct, but it is hardly helpfull. Let me see if I can improve on the answer above. There's an abstract example of what you want to achieve below; (abstract as in it contains a bit pseudocode, not as "an abstract class")

VB.NET

    Public Sub CreateView()
        Using con As New MySqlConnection("your connection string here")
            Using cmd As MySqlCommand = con.CreateCommand()

                con.Open()
                cmd.CommandText = _
" CREATE VIEW view_name AS      " +
"      SELECT column_name(s)    " +
"        FROM table_name        " +
"       WHERE condition         "

                cmd.ExecuteNonQuery()
                con.Close() ' I don't close mine; the dispose handles that.

            End Using
        End Using
    End Sub

There are a few resources you might need;

http://www.connectionstrings.com/mysql/[^], for building your connection-string.
http://www.w3schools.com/sql/sql_view.asp[^]; this is from where the "create view" command was copy/pasted.
http://dev.mysql.com/doc/refman/5.0/en/create-view.html[^] - if you work with MySQL, then the manual *needs* a place in your favorites.
Information on the required VB.NET code[^]

I'd also recommend downloading at least VS2010; it comes with .NET 4, which performs a bit better than the 2.0 runtime. Also gives you some nice extra's, like mini-dumps in .NET - very powerfull when debugging with one o' those. There were also some nice language-enhancements in the IDE. An upgrade would well be worth the effort.

Since you'd be going to create views, I'd also like to point out that there are various options for naming those views. It'd be redundant to add the word "view" to it, but looking at other databases, it also looks like a tradition. MySQL does not allow some characters in the view-name. The W3Schools shows such an example with spaces.

Please don't do that. Just do it without spaces. It's not just MySQL that could blow up; furtherdown the line, there's probably an ORM or something generated from that view (like a report) and than that will blow up. Then the problem probably gets posted here, and I blow up.

Going offtrack a little further; for those wondering why I have a macro autofill the quotes to a single level - it makes it easy to cut & past the query into SQL Managment Studio (using block-select, ALT-SHIFT while you select text) and to paste it back into VS.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Creating MySql views

SPSandy16-Mar-14 5:45

SPSandy

16-Mar-14 5:45

Thanks a lot. This was really very useful.

Make An Exe Inside My Panel Become Unmoveable

EYESTRA1N11-Feb-14 4:12

EYESTRA1N

11-Feb-14 4:12

I am just wondering if it's posible to make that?

I have my MyApplication.exe inside my form and I want it to be just fix on its location?

System.Diagnostics.Process.Start("MyApplication")'My Application.exe
           Dim P As System.Diagnostics.Process = System.Diagnostics.Process.GetProcessesByName("MyApplication")(0)
           P.WaitForInputIdle()
           SetParent(P.MainWindowHandle, Me.Panel1.Handle)

We can resize the panel by adding

MoveWindow(P.MainWindowHandle, 0, 0, 500, 300, True)

but its posible to make it fix on that location?

modified 11-Feb-14 10:52am.

Re: Make An Exe Inside My Panel Become Unmoveable

Chris Quinn11-Feb-14 4:41

Chris Quinn

11-Feb-14 4:41

Your question is not clear at all. Please try to explain it better

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: Make An Exe Inside My Panel Become Unmoveable

EYESTRA1N11-Feb-14 5:13

EYESTRA1N

11-Feb-14 5:13

I think this link help me a lot

http://www.codeproject.com/Articles/101367/Code-to-Host-a-Third-Party-Application-in-our-Proc

Thank you

Re: Make An Exe Inside My Panel Become Unmoveable

Dave Kreskowiak11-Feb-14 7:33

Dave Kreskowiak

11-Feb-14 7:33

No, you can't. You don't have direct control over the window of a seperate process.

The thing is that the external process does not know it's window is inside your window. It thinks and works exactly like it was running on the desktop. The desktop is itself a window, just like your Panel control.

If the user grabs the title bar of the external process, they can move the window around and your code will not know anything about it. There are no events that tell you if the external process window is being moved.

The users can also hit the minimize and maximized buttons on the external process window and they will work, just as if the window was on the desktop. You can't 100% stop that from happening.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Make An Exe Inside My Panel Become Unmoveable

Eddy Vluggen11-Feb-14 8:29

Eddy Vluggen

11-Feb-14 8:29

EYESTRA1N wrote:
I have my MyApplication.exe inside my form and I want it to be just fix on its location?

Let me rephrase that; you want to remove the title-bar on a Window.

Go here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Make An Exe Inside My Panel Become Unmoveable

EYESTRA1N11-Feb-14 18:11

EYESTRA1N

11-Feb-14 18:11

Thank you so much for the answers

It really help me a lot.

View Word Document in Vb.Net Form Visual Studio 2012

Danish198711-Feb-14 1:02

Danish1987

11-Feb-14 1:02

Hi,
I want to preview word (.docx) document on user form control in vb.net 2012. Please provide any solution!!! Urgent.

Re: View Word Document in Vb.Net Form Visual Studio 2012

Richard Deeming11-Feb-14 1:13

Richard Deeming

11-Feb-14 1:13

Google[^] not working for you?

The second result leads to an answer on CodeProject[^], which leads to this Microsoft knowledgebase article[^] which looks like it'll do the job.

And no, it's not urgent. Not for us, anyway.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: View Word Document in Vb.Net Form Visual Studio 2012

Danish198711-Feb-14 1:24

Danish1987

11-Feb-14 1:24

Hi Richard,
Already tried this but when followed the suggested code and steps, it is not previewing the document file in control, rather throwing dialogue box to either open / save file in respective software. but not in form.

And here in my scenario I want to view the document on form itself, in web browser control.

Any help will be highly grateful. Please...!!!

Re: View Word Document in Vb.Net Form Visual Studio 2012

Eddy Vluggen11-Feb-14 3:02

Eddy Vluggen

11-Feb-14 3:02

Danish1987 wrote:
Already tried this

Anything else you tried that I need not mention?

Danish1987 wrote:
And here in my scenario I want to view the document on form itself, in web browser control.

Why was this not in the original question?

If you want to show a docx in a webbrowser, you'll need Word to be installed on the client.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

PrintPreviewControl at Zoom In Page Right and Bottom Margin Spaces Not Appear??

Nicomendox10-Feb-14 10:33

Nicomendox

10-Feb-14 10:33

Hi to all Friends. first of all Excuse me for my bad english. I created an Address Label Print Program. I use PrintPreviewControl for Preview. When I click my Zoom Button about %100 in zoom is ok. Right Left Right And Bottom Margin Spaces are appear. But when 200% Zoom in PrintDocument is bigger size then PrintPreviewControl window. in this point Left and Top Margin Spaces are appear but Right and Bottom Margin Spaces not display.. can not appear. It seems like endless Paper.. I want to see right and bottom margin spaces also. in this page I found an program source codes.

http://www.codeproject.com/Articles/38758/An-Enhanced-PrintPreviewDialog

In this Program is codes are Locked can not change. I am not professional in VB.Net. thats why I just only want to know is there any simple way to see this right and bottom margin spaces at Zoom In (200%) mode. advanced thank you very much. God Bless all.

modified 10-Feb-14 17:51pm.

Sms in Vb.net

sadish69-Feb-14 19:59

sadish6

9-Feb-14 19:59

I need to send sms in vb.net windows application i tried many dll and gateway i ended in vain pls help me

Re: Sms in Vb.net

Chris Quinn9-Feb-14 21:14

Chris Quinn

9-Feb-14 21:14

Do not post the same question in multiple forums

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

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