I have a database and I wanna select a field ..I usually do this with access:
dim chosen as string
chosen = textbox1.text
Dim querysql = "select * from table where field = " & chosen & ""
But with SQL it doesnt work =S I really need to make this work .
This is the only code I could find and it doesnt work:
Private Sub DataGridView1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseUp
Dim pt = New Point(e.X, e.Y)
[Code]....
I need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
well i have been looking all over the internet for hours and i just cant sseem to find a working line of code. ok i know this isnt efficent or anything but i just wana know how to use sendkeys to send control c (copy to clipboard) ive tried using this: Sendkeys.send("^C") and many varriations of that but none of them seem to work and i dont understan why. My program is highlighting some text then i want it to copy that to clipboard.
View 2 RepliesMsgBox(Session("fllog_ref"))
Dim query As String = "SELECT customer_name FROM tblFixedLine_order_summary WHERE fllog_ref=@fllog_ref"
[code]....
My.Computer.FileSystem.WriteAllText("my.resources.highscore", TextBox2.Text, True)Im trying to use the resources as the directory but it doesnt work
View 2 RepliesI'm not quite sure why, but this program doesnt work as intended. It's kind of difficult to explain but if you tried it, it doesn't work properly.
Private Sub btnApply_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnApply.Click
'clears the changes box before going through if statements
Me.txtChange.Text = ""
[CODE]...
i have a problem, from some reason i'm getting an error when "i" and "i+6" value within the str i = 1 To str.Length If i Mod 79 = 0 Then Dim c As Integer = str.Substring(i, i + 6) If c = "" Then str = str.Insert(i, "b") End If End If Next i
View 27 RepliesI tested every example I found but it doens't work in vb 2010 express... Do I need to install anything moor to make it work?
View 2 RepliesSo i made 3 forms in the first i made a simple textbox on form2_load i have this code [code] It SHOULD show in form 3 the input of form 2 but that simply doesnt work while it works with the same code on Form 2 . that when Form2 loads it actually has the Input of form1 but not in form 3..As i said there is NO error message and i dont know what i did wrong . Can anyoone help me out
View 20 RepliesOk, so I have set my form as the parent of a 3rd party application.Appactivate works when the 3rd party application is not a child of my form.It would appear that if the application is not on the taskbar (A non taskbar application) appactivate does not work.
View 10 RepliesI got this code from a c# post on how to get the location of an open process. What I want to do is beable to snap applications to running processes by finding their location using winapi user32.dll and searching window name then parse the location and set my application on a time to constantly move to what ever location that program is in. I tried the C# to vb.net converter doesnt work.
View 1 RepliesI got the code from ALLAPI but it gives me errors of declarations that have changed in this version of VB, i tried to update the code but...
Public Class Form1
Const VK_H = 72
Const VK_E = 69
[code].....
I have an MS access database that has fomrs with buttons to do certain tasks - a "console" or "toolkit". I am trying to run cmd.exe as the local administrator using this command....
Call Shell("C:WINDOWSsystem32
unas.exe /noprofile /user:administrator cmd.exe")
If my domain account is added to the local administrators this works fine (it asks for a password - is there any way round this?)
If i visit another PC in the domain on which i am not a local administrator, it doesnt work and i don't know why In both scenarios i can manually browse to cmd.exe and right click and runas a differnt user without any problems.Also, is there a more efficient way of running this command?
My debugger doesnt work correctly anymore and I want to let it work correctly cause i've done some changes in my project but when I click on debug then it just shows my old layout.
View 4 RepliesVB.NET
if InStr(string1, "text1" or "text2") then
msgbox("it has text1 or text2")
end if
How to make it work?
I am really confused! My program doesnt work if I dont have visual studio here in my pc. To test it I have uninstalled visual studio. But my program doesnt work though flash player is present there(I have used flash animation in first form). To be more sure about it I have installed Flash. But its not working! That means flash animation file(.swf) is not making problem! It needs support from visual studio to start. Doesnt it mean that some files are not attached with setup file as a result it needs visual studio to run? Let me tell you how do I create setup file of my program.[code] Application Folder> Create another shortcut & bring it to User`s Programs Menu>Folder(program`s name as folder`s name)
View 4 RepliesIn Key Press Event i have put the logic of search in textbox, when i press enter key it will take the values from textbox and brings the data in DataGrid.In another event of GotFocus there is an logic of autocompletestring collection from Table. If i type a in that textbox it will shows all the suggested string in that.
If i comment the logic of GotFocus Event for textbox for autocomplete suggestion then only then Key Press events work else its not working. I dont know why its happening.
[Code]...
hey I have a piece of code which gives fade effect to a form at load eventBut it works only with normal forms and doesnt work for the forms which gets loaded into a mdi parent form
View 13 Repliesi am doing an internship for which i had to make a code in vb. i am using vb 2010 ultimate. the code is ready n bug free. it does what it is supposed to do on my system. how should i transfer it onto my mentor's system because he needs the code for day to day activities. his system has v1.something for .net framework. mine is v4.something.i have tried sending him exe file generated. didnt work due to the difference in versions of.net framework.then i read bout package and deployment wizard. vb 2010 ultimate doesnt have that wizard. i tried publishing it. gives me an error "WindowsApplication1 has stopped working." this is on my system and not my mentor's.
View 7 RepliesI Have a Function on my frmMain Class wich will update my control to something else after an invoke. When i type "?Label1.Text" on the Immediate Window, the text property IS updated, but when i go check the Form, nothing happened. The code is just like this
[Code]...
i have learned VB 6.0 a few years back, but started out in .NET with this one..Everything went pretty good, until now! I want to write my data from the application to my Access database (Frituur1).i have tried with several methods1:this takes place in my Module1:
Dim newJournaalRow As Frituur1DataSet.JournaalRow
newJournaalRow = frmindex.Frituur1DataSet.Journaal.NewJournaalRow()
newJournaalRow.btw6 = btw6
[code].....
The following lines are supposed to display to a text box the phones numbers that match the condition in the sql statement, however it shows me all the phone numbers:[code]
View 7 RepliesI have 2 forms. I want to close Form1 without closing the entire application but it doesnt work. It closes the whole application even though i say Form2.show()[code]When it reaches the End Sub then it closes the application.
View 6 RepliesI cant get System.Threading.Thread.Sleep to work..[code]
View 2 RepliesThis is the strangest thing, I can not figure out why this is happening. When I delete a radio button from my form which is used to filter data in a database Form_Load stops working.My project consists of a database and a web browser. The database has a search filter options.[code]For some reason it didnt load my settings on start up. I made a button which displayed True/False in a text box to check if it was saved in my settings, it was, it just didnt want to load. So I deleted it and everything broke! Nothing in the code is referenced to the RadioButton or its code.
Have I done something wrong or is VB just messing with me? There is obviously a bunch of more code, I just posted what I think is relevant to the issue. If you feel something is missing, tell me and Ill post it. ied to change the RadioButton with a CheckBox, and I changed the code from "Me.ExampleTableAdapter.FilterHide..." to "Me.Example TableAdapter. Fill...", which is the same as in Form_Load. It works if it starts checked. If I remove this code or delete the CheckBox nothing works even though the same code is in Form_Load. If I start off with the CheckBox in an Unchecked state nothing loads, if I check it everything except the Browser works for some reason.
I have a trouble making this code work. When executed, it just creates a correct (with the correct name) file with the extension .txt but the the actual text inside .
Imports System.IO
Public Class Form1
Public mytext As String
[code]...
The strange thing is that while debugging, h, t string variables have the correct values, but somehow mystream.write(t) doesnt work (it doesent write anything to my h.txt text file...
This is going to be hard to explain but oh well.I have a form with a menu. When I hit option one, it opens another form (form2) inside that same form (mdiparent). When I hit X on form2, then try to open it again from the original form with a menu thru the menu, It says it cant access a disposed object. Here is the code: Form1:
[Code]...
I am working on a visual basic project to download files from the internet. Well i have a Url textbox, directory textbox, and a download button. And YES i have done some research and i know it is something like... wclient.DownloadFile(Url.Text,Directory.text) but for some reason "wclient" doesn't work it says its "not defined"..? What else should i use or how should i declare it? Should i import something?
View 1 Replieswill SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 Replies