VBForums

VBForums http://www.vbforums.com/ Visual Basic Discussions plus .NET, C#, game programming, and more (http://www.VBForums.com) en Sun, 19 May 2013 00:35:17 GMT vBulletin 60 http://www.vbforums.com/images/misc/rss.png VBForums http://www.vbforums.com/ VS 2008 rdp auto connect with username and password ? http://www.vbforums.com/showthread.php?722131-rdp-auto-connect-with-username-and-password&goto=newpost Sat, 18 May 2013 21:46:47 GMT Hi, i have been searching all night and looked at loads of examples ect but can not find what i need.

Basically I have several RDP connections that i work from. I need to test the connections every now and again.

I can use tcp client to connect to ip:port and if if its online but that just wont do.

What i need to do is connect to each rdp, pass the username and password and it will connect then login auto. Once loged in, it will tell me logged in.

It then needs to logout and go to the next rdp ip and repeat the above.

It also need to tell me if it failed to login, then i can manually check that rdp.

This is because a couple of the rdp's have several user on them that i set, i need to make sure that none have changed the password as some have root access as we all work on the safe files there ect. We use the rdp to WFH(work from home).

How would i go about doing this ?

Thanks ]]> Visual Basic .NET SystemX http://www.vbforums.com/showthread.php?722131-rdp-auto-connect-with-username-and-password VS 2010 Help!!!??? File corrupt??? http://www.vbforums.com/showthread.php?722129-Help!!!-File-corrupt&goto=newpost Sat, 18 May 2013 21:04:27 GMT Hi all, Bugger, when I open up my form code I get a bunch of garble as per the attached. Not sure what has happened. Any ideas how to fix this? Not sure whether to laugh or cry.... Cheers, J Hi all,

Bugger, when I open up my form code I get a bunch of garble as per the attached. Not sure what has happened. Any ideas how to fix this? Not sure whether to laugh or cry....

Cheers,
J

Attached Images

]]> Visual Basic .NET jonesin http://www.vbforums.com/showthread.php?722129-Help!!!-File-corrupt peraph Dsum..???? in query http://www.vbforums.com/showthread.php?722127-peraph-Dsum-in-query&goto=newpost Sat, 18 May 2013 18:54:10 GMT Account and Cod>Cod and update table_total amount from the realted summ of Amount from table table_single. Googoling i have see Dsum, is correct? if yes how to via query? Tks.]]> Have 2 table:
table_total and table_single.

all tables have field Account, Amount and Cod

i need to summ all value in Amount in table_single, based the match/join Account>Account and Cod>Cod and update table_total amount from the realted summ of Amount from table table_single.

Googoling i have see Dsum, is correct? if yes how to via query?

Tks. ]]> Database Development luca90 http://www.vbforums.com/showthread.php?722127-peraph-Dsum-in-query Noob: checkbox, function, module assistance http://www.vbforums.com/showthread.php?722125-Noob-checkbox-function-module-assistance&goto=newpost Sat, 18 May 2013 18:20:07 GMT I'm in the chapter in my Visual Basic book on creating multiple forms, modules, and menus.

The first problem, is to create a problem that calculates a total for going to conference.

it gives MainForm and OptionsForm design. Below is what I recreated
Name: MainForm..jpg
Views: 66
Size: 33.9 KB

Name: MainForm..jpg
Views: 66
Size: 33.9 KB

Name: OptionsForm.jpg
Views: 41
Size: 38.2 KB

The assignment

Quote:

The Conference Options form allows the user to select the regular conference registration, the optional opening night dinner, and an optional preconference workshop; user cannot select optional events without selecting registration. When the Close button is clicked, this form should be removed from the screen and the total registration fee should appear on the main form

It also gives a tip about using a global variable to hold the total cost, so both form will have access to the variable

I haven't finished the program and most I can do. I have module setup in addition to the two forms.

this is button on the MainForm to get conference info and total

Code:

 Private Sub btnConferenceOptions_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnConferenceOptions.Click

        '==================================

        'declare variables

        '=================================

        Dim frmOptionsForm As New frmOptionsForm



        frmOptionsForm.ShowDialog()



        '==================================

        'display total

        '=================================



        lblTotal.Text = g_decTotalCost.ToString("c")

    End Sub

this is the module

Code:

Module CalucateModule

    '==================================

    'declare global constants and variables

    '==================================

    Public Const g_decRegistration As Decimal = 895

    Public Const g_decDinner As Decimal = 30

    Public Const g_decECommerce As Decimal = 295

    Public Const g_decWeb As Decimal = 295

    Public Const g_decVisualBasic As Decimal = 395

    Public Const g_decNetworkSecurity As Decimal = 395

    Public g_decTotalCost As Decimal



    Public Function ConferenceTotal1() As Decimal



        If frmOptionsForm.chkRegistration.Checked = True Then

            g_decTotalCost += g_decRegistration

            MessageBox.Show("test if IfThen statement")

        End If

        MessageBox.Show("test outside IfThen statement")



        Return g_decTotalCost

    End Function

End Module

this is the OptionsForm code

Code:

Public Class frmOptionsForm



    Private Sub btnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClose.Click

        Call ConferenceTotal()



        Me.Close()

    End Sub



    Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReset.Click

        chkDinner.Checked = False

        chkRegistration.Checked = False

        lstOptions.SelectedIndex = -1

    End Sub



    Public Function ConferenceTotal() As Decimal



        If chkRegistration.Checked = True Then

            g_decTotalCost += g_decRegistration

        End If



        Return g_decTotalCost

    End Function 

End Class

What I can't figure out, ConferenceTotal function works on the OptionsForm, but not on the CalculateModule. The I added the 1 to ConferenceTotal so I didn't get some error, and didn't want to delete and retype later. Somehow I have something off when referencing the chkRegistration on the OptionsForm. The outside IfThen statement messagebox pops up when I call CalcuateTotal1 function.

It's possible I'm not fully understand module and what can be used in it. The books says they're meant to contain general purpose procedures, functions, and declarations that are available to all forms in a project. So, maybe I'm not allowed to use radio buttons, checkboxes, lists and so forth in specific forms.

Once I understand this, I can do the rest.

Attached Images

]]> Visual Basic .NET lovekeiiiy http://www.vbforums.com/showthread.php?722125-Noob-checkbox-function-module-assistance VS 2010 how to get information from website http://www.vbforums.com/showthread.php?722123-how-to-get-information-from-website&goto=newpost Sat, 18 May 2013 18:18:55 GMT hi guys this web site http://www.cma-cgm.com/eBusiness/Tracking/ is Container Tracking company and i must go into their web site to search for my container i want program make this search !! not else and see if my container arrived or not !! and thx !! hi guys
this web site http://www.cma-cgm.com/eBusiness/Tracking/
is Container Tracking company and i must go into their web site to search for my container
i want program make this search !! not else and see if my container arrived or not !!

and thx !! ]]> Visual Basic .NET ahmmkh http://www.vbforums.com/showthread.php?722123-how-to-get-information-from-website Dilemma with Using a Form and textbox with Access http://www.vbforums.com/showthread.php?722119-Dilemma-with-Using-a-Form-and-textbox-with-Access&goto=newpost Sat, 18 May 2013 17:35:05 GMT I think this is the right forum since the question is db related really.
I had to build this app in Access, because that is the only thing I'm allowed to code in at the office.

I created a form and put some labels and textboxes on it. One box is txtNotes, where I put notes on particular records (yes they are coming from the db, but the question is more about the object). Initially, I wanted to have a vertical scrollbar on this large text box, so that when the note was too large, the user could scroll down. I found that on the Access Form, the textbox has to have focus to show the scrollbar. That was fine. I set focus to it as the last step each time.

Then I encountered a new issue. I was using txtNotes.Text = RS("notes") and eventually, one of my notes was too long and I got an error telling me so. To fix this, I switched from txtNotes.Text to txtNotes.Value. That solved the "too long" problem, but created a new problem. Now when .SetFocus kicks in, the entire contents of the box is highlighted.

So the problem is, if I don't Set Focus, then I don't get scrollbars. If I do set focus, then my text gets highlighted. I could set .Value back to .text, but then some of my notes will be too long. (BTW, what is the limit, I haven't found it anywhere).

So that's it. Suggestions?
I should mention that the text in the box is a mix of English and Chinese, so any ideas that involve counting characters and acting accordingly will be hard to implement with any accuracy.

Thanks. ]]> Office Development wengang http://www.vbforums.com/showthread.php?722119-Dilemma-with-Using-a-Form-and-textbox-with-Access <![CDATA[[RESOLVED] "Attempt to write a read-only database"]]> http://www.vbforums.com/showthread.php?722117-RESOLVED-quot-Attempt-to-write-a-read-only-database-quot&goto=newpost Sat, 18 May 2013 17:10:33 GMT Hi, I have developed a program that connects to a .db database. When I debug it, it works fine as the database on my computer is not set to read only (when I check by right clicking the file and going to properties). However when I build the project and install it on another machine, the database somehow gets set to read only and I get the error that is in my title. Does anybody know how I would go about solving this? Thanks Hi,

I have developed a program that connects to a .db database.
When I debug it, it works fine as the database on my computer is not set to read only (when I check by right clicking the file and going to properties).
However when I build the project and install it on another machine, the database somehow gets set to read only and I get the error that is in my title.

Does anybody know how I would go about solving this?
Thanks ]]> Database Development Karl.Green http://www.vbforums.com/showthread.php?722117-RESOLVED-quot-Attempt-to-write-a-read-only-database-quot how do display the last customers entry http://www.vbforums.com/showthread.php?722115-how-do-display-the-last-customers-entry&goto=newpost Sat, 18 May 2013 16:59:07 GMT hello everyone i have a database with customers that i add each day im trying to figure out how to see the new entries that i add in the same day how many customers i added in the same day like a report or something like that i need a idea where to start this regards salsa hello everyone
i have a database with customers that i add each day
im trying to figure out how to see the new entries that i add in the same day
how many customers i added in the same day
like a report or something like that
i need a idea where to start this
regards salsa ]]> Visual Basic 6 and Earlier salsa31 http://www.vbforums.com/showthread.php?722115-how-do-display-the-last-customers-entry <![CDATA[[RESOLVED] pictureboxes and right click menu]]> http://www.vbforums.com/showthread.php?722111-RESOLVED-pictureboxes-and-right-click-menu&goto=newpost Sat, 18 May 2013 14:37:28 GMT We have a situation like this:

1. 4 picturebox controls
2. I want to add or remove picture from picturebux using context meny
3. Contextmenu have to be done with code (no control)

Code:

  Dim ctxmnu As New ContextMenu



        Dim item1 As New MenuItem("Add Picture")

        Dim item2 As New MenuItem("Remove")



        AddHandler item1.Click, AddressOf ContextMenuHandler

        AddHandler item2.Click, AddressOf ContextMenuHandler



        ctxmnu.MenuItems.Add(i1)

        ctxmnu.MenuItems.Add(i2)

What we have to do that our program konws which picturebox we want to fill opening fileopen dalog?

Code:

        

   Private Sub InputPicture()

        If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then

            PictureBox1.Image = Image.FromFile(OpenFileDialog1.FileName)

            PictureBox1.Tag = OpenFileDialog1.FileName

        Else

            OpenFileDialog1.Tag = ""

        End If

    End Sub

I've tried many things to send an argument via InputPicture() which should point to the picturebox we need but without success. ]]> Visual Basic .NET Goshx http://www.vbforums.com/showthread.php?722111-RESOLVED-pictureboxes-and-right-click-menu VS 2010 Tabbed web browser error http://www.vbforums.com/showthread.php?722109-Tabbed-web-browser-error&goto=newpost Sat, 18 May 2013 14:32:15 GMT Hello all! I'm currently in the process of re-writing a web browser I had.

Everything has been going well until now. The tab control is being a pain. The video I uploaded below will show you what I mean.

Is there any way I could fix this? It is really annoying, and I haven't found any way to resolve this myself.

Any help would really be nice!

Thank you for taking your time to read my post. ]]> Visual Basic .NET ryanguy426 http://www.vbforums.com/showthread.php?722109-Tabbed-web-browser-error <![CDATA[MSHFlexGrid edit problem: textbox won't show]]> http://www.vbforums.com/showthread.php?722107-MSHFlexGrid-edit-problem-textbox-won-t-show&goto=newpost Sat, 18 May 2013 14:23:25 GMT I'm working on a program, which included an "editable" grid (MSHFlexGrid). I borrowed code from a VB book, which told me to superimpose a textbox whenever I click a cell.

With MSHFlexgrid1
' Cancel range selection, if any.
.RowSel = .Row
.ColSel = .Col
' Move the cell editor into place by making it one pixel smaller
' than the current cell.
txtCellEditor.Move .Left + .CellLeft, .Top + .CellTop, _
.CellWidth - ScaleX(1, vbPixels, vbTwips), _
.CellHeight - ScaleY(1, vbPixels, vbTwips)
' Transfer the contents of the current cell into the TextBox.
txtCellEditor.Text = .Text
' Move the TextBox in front of the grid.
txtCellEditor.Visible = True
txtCellEditor.ZOrder
txtCellEditor.SetFocus
' Remember current coordinates for later.
cellRow = .Row
cellCol = .Col
End With

I really don't see any problem with the code. I just don't know why the textbox (txtCellEditor) won't show whenever I invoke the click button on the grid. More surprisingly, the data I enter in the textbox is entered into the grid after the textbox loses focus. Just wondering how to make that textbox appear and let the user see what he is editing.

Hope anyone can help. Thanks in advance!!! ]]> Visual Basic 6 and Earlier jlynoel25 http://www.vbforums.com/showthread.php?722107-MSHFlexGrid-edit-problem-textbox-won-t-show VS 2010 Browser app to bypass work security http://www.vbforums.com/showthread.php?722105-Browser-app-to-bypass-work-security&goto=newpost Sat, 18 May 2013 14:09:40 GMT I run a discussion forum and I have just been told that one of my visitors cannot login to my vbulletin forum due to security restrictions at his workplace. With this in mind, I was wondering if its possible to create some mini app where you enter username/pw and it can login but bypass the security that somehow stops him logging in. He can still view the forum but can't post due to the login issue. I want to get around that.

Any ideas?

Thanks,

Jon ]]> Visual Basic .NET Jon12345 http://www.vbforums.com/showthread.php?722105-Browser-app-to-bypass-work-security Connection string data source name http://www.vbforums.com/showthread.php?722103-Connection-string-data-source-name&goto=newpost Sat, 18 May 2013 13:08:50 GMT I have written my first app using a database. One of my connection string is as follows,

m_cn1.ConnectionString = "Data Source=.\SQLEXPRESS; AttachDbFilename = " & _
m_cn1mdfPath & ";Integrated Security=True; Connect Timeout=30;" & _
"User Instance=True"

I have installed this app on a few computers and all works well, but one.

My data source name on that PC is "SDCO".

My question is, is there a way to determine what the datasource name is and assign it to a string?

something like

public condatasourcename as string = my data source name on this PC

m_cn1.ConnectionString = "Data Source=.\" & condatasourcename & ; AttachDbFilename = " & _
m_cn1mdfPath & ";Integrated Security=True; Connect Timeout=30;" & _
"User Instance=True" ]]> Database Development jkatshor http://www.vbforums.com/showthread.php?722103-Connection-string-data-source-name VS 2008 Error while using recordsets to delete records http://www.vbforums.com/showthread.php?722101-Error-while-using-recordsets-to-delete-records&goto=newpost Sat, 18 May 2013 13:05:46 GMT I am using the following code to delete a record in vb:

"If rspmps2("pmpidno").Value = gvr1.Cells("pmpidno").Value Then
rspmps2.Delete()
rspmps2.UpdateBatch()"

where rspmps2 is a ADODB record set and gvr1 is a grid view row. but I keep getting the following error message:

"Row handle referred to a deleted row or a row marked for deletion."

Please can somebody assist me in this. ]]> Visual Basic .NET enigma1810 http://www.vbforums.com/showthread.php?722101-Error-while-using-recordsets-to-delete-records auto run code based on time http://www.vbforums.com/showthread.php?722099-auto-run-code-based-on-time&goto=newpost Sat, 18 May 2013 12:44:10 GMT i have done some research but found nothing on how to run an event based on pc time. I.e Say for example a user selects 10pm every day for a file copy to take place how would you set that up in .net i have done some research but found nothing on how to run an event based on pc time.

I.e
Say for example a user selects 10pm every day for a file copy to take place how would you set that up in .net ]]> Visual Basic .NET mason84 http://www.vbforums.com/showthread.php?722099-auto-run-code-based-on-time