20,284 Topics
| |
Hi I have a column (ColumnC) in an access query which extracts the notes from column A and ColumnB and seperates them with a comma. This is the expressoin I use in access (Note: [RecheckNote] & IIf(Not IsNull([RecheckNote]) And Not IsNull([CTNote]),",","") & [CTNote] ) What I would like is to … | |
I want to make a combobox that will grow or shrink according to the screen size any help? | |
Problem : If ComboBox contains "x" display DialogBox1. Whats the code after it? | |
Private Sub RefreshGoSearchCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RefreshGoSearchCancel.Click If (AddressBar.Text = "") Then WebBrowser.Refresh() ElseIf (AddressBar.Text <> "" And "." And "") Then WebBrowser.Navigate("www.google.com/search?q=" & AddressBar.Text) Else WebBrowser.Navigate(AddressBar.Text) End If End Sub This is the code for The AddressBar to refresh when text hasn't changed, search … | |
| Hello guys, I am using connected architecture to develop an application. For every form am designing there requires to put the connection string to connect to databse. Is there any way that If I change connection string at one point it is automatically changed at other. Thanks |
hey, i am creating one project where i am using MDI system, so when i am opoening MDICHild in MDI Parent it adds new title bar for MDI child. I tried formborderstyle, have hide controlbox, max - min button but it dident worked ? so can anyone have any solution … | |
Hello, I would like to seek help from all experts in VB.NET (VB Language) regarding copying file from source folder to destination folder. I have a files named YYYYMMDDHHMMSS.txt. Now i want to build a small project to copy those file to destination folder. The project should work in following … | |
Hi Folks As a newbie, my datagrid (dgvExamScores)has column4 and column5 (and othercolumns) column4 values depend on column5 values. Code works fine. PROBLEM: when I delete a column5 value, I expect the corresponding column4 to be deleted but this is not the case. Just where have I erred in my … | |
hey guys i need to know some of the techniques on how to shorten a very long query for example Dim SqlStatement As String = "INSERT INTO tblcenterlane(DESCRIPTION, UNIT, BEG, OT_KITCHEN, OT_F&B, OT_F.O., OT_S&M, OT_H.K., ADMIN, DEL, PULLOUT, SPOILAGE, ENDING, UNIT_COST, AMOUNT, VARIANCE, REMARKS, DEPARTMENT, DATE, DATE_DURATION_FROM, DATE_DURATION_TO, SUPPLIER_ID, CATEGORY) … | |
Hello, In my multithreaded applications, on occassion the error Que Is Empty occurs when trying to clear the que. Is there any way to prevent this from happening or catch it without causing the program to lock up? Below is the code that throws the exception. ` Private Sub Callback(ByVal … | |
Hi, I just wanna ask what's the problem with my code in retrieving image from database into a picturebox. Private Sub ShowDetails() Try Dim cn As New OleDb.OleDbConnection Dim cmd As OleDb.OleDbCommand Dim dr As OleDb.OleDbDataReader cn.ConnectionString = mstrConnection cn.Open() cmd = cn.CreateCommand() cmd.CommandText = "SELECT myimage FROM employees WHERE … | |
First posting here, but I've gotten a lot of help from this site. Here is my problem. I'm trying to automate some procedures for my production line. I have a word document that I have created a string from. What I'd like to is search the document for somestring after … | |
Right guys, I'm really new to this but I'm getting along ok, but I've hit a block. I need to be able to know how to search a text file in VB for a particular line and then display it. the files I'm trying to use are set up as: … | |
Hello, I am creating a toolstrip and then adding a toolstripcombobox to it. My code so far is as follows: Dim tsMenu As New ToolStrip tsMenu.Name = "tsMenu" tsMenu.Dock = DockStyle.Top tsMenu.Visible = True Dim tsComboBox As New ToolStripComboBox tsComboBox.Name = "tsComboBox" tsComboBox.Visible = True tsComboBox.Items.Add("Item 1") tsComboBox.Items.Add("Item 2") tsMenu.Items.Add(tsComboBox) … | |
I got an error with my codes? Is anybody can help me ? The Error list said Identifier Expected? the error pertains on the last Underscore in my code but i dont know how to solve the error, Hope can someone will give an Idea to make it right :) … | |
Hello! I need a help from my code in filtering the male/female regular/contractual employees. Scenario: I have 4 checkboxes the 'cbox' for contractual, 'rbox' for regular, 'mbox' for male and 'fbox' for female. What I wanted to happen is when I check 'mbox' it will display male employees in as … | |
Hello everyone, I'm attempting to log into Hotmail using Web Requests, but I'm having a little trouble. It seems I can log in fine, but when I try to access Hotmail, it takes back to a login page with puts me in a constant loop. The important code can be … | |
how do i detect the current position in vlc video-playback in vb.net? Basically as the clip is playing, I want in a label for it to say "02:58/21:35" relating to the current clip being played. So I'll need to somehow figure out how to detect current position and end position. … | |
guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is … | |
| Hello people, here is a question related to sharing of databse between two applications. I am developing an application which has two parts: 1) Client Side. (Student) 2) Server Side. (Faculty, teacher) What I want to accomplish is that if a teacher creates question paper the student should be able … |
Hello to everyone I am a begginer in VB6. My project consist just on a form and a web object, the problem is that I want to dissable the sound that make the application when I click on links. Can someone help me?! Plese write the code here because I … | |
I want to get the data between today this the coding i used CrystalReportViewer1.SelectionFormula = "{sell.Date}= '" & DateTimePicker2.Value & "' BETWEEN {sell.Date}= '" & DateTimePicker1.Value & "'" I saved the data into data Dim date1 As Date = DateTimePicker1.Value.Date THE ERROR I got have attached as a picture I … | |
*It's my first time here but the way I see things around here is good * I'm a newbie in VB2010 so please don't judge me too much... HERE is my codes for INSERTING DATA but the problem is I don't know how to use it for SEARCHING Imports System.Data.SqlClient … | |
Hello, I'm having a little issue issue with my picturebox controls. Normally my program works fine, but when I try to load a picture into any of my pictureboxes, the image won't load until I make sure the form is extended to show the picturebox and the form is ontop. … | |
Private Sub Open_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Open.Click If (BookmarksList.SelectedIndex >= 0) Then WebBrowser.WebBrowser1.Navigate(BookmarksList.SelectedItems) End If End Sub This is the code I made for opening a Bookmark from List yet an error keeps on showing. Any help? WebBrowser is the main form's name. BookmarksList is … | |
No mapping exists from object type System.Windows.Forms.DataGridViewRow to a known managed provider native type. Using conn As New SqlConnection(My.Settings.Smitty) Using cmd As New SqlCommand() With cmd .Connection = conn .CommandText = "Update Repairs set status = @status WHERE RepairNumber = @repairNumber" .Parameters.AddWithValue("@status", "Awaiting Part Installation") .Parameters.AddWithValue("@repairNumber", RepairInventoryDataGridView.Rows(4)) End With conn.Open() … | |
Hi All, Quick one. I have a webservice which uses numbers in american format which need to be passed as datetime data types when webmethod is called. The issue is the times passed depend on when a button is pressed. Please ignore variables as this is from testbed project I … | |
i have a datagridview with 2 columns on it. i add column 1 manually from Datagridview task (add columns), it should numeric value and came from user input. for column 2 (it's numeric value), on load event from database with this : Using conn As New MySqlConnection("connection string") conn.Open() Dim … | |
| Hey fellas, Is there any method by which I can declare a Variable that can be used in multiple forms in VB.NET ? |
I just wanna ask what's wrong with my code it says syntax error on INSERT STATEMENT but I can't find the error @.@ Try Using conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.Environment.CurrentDirectory & "\employeedb.mdb;") conn.Open() Dim command As New OleDbCommand("INSERT INTO employees (first_name, last_name, MI, address, age, contact, status, department, … |
The End.