20,284 Topics

Member Avatar for
Member Avatar for VIPER5646

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 …

Member Avatar for TnTinMN
0
135
Member Avatar for IsaacMessi10

I want to make a combobox that will grow or shrink according to the screen size any help?

Member Avatar for IsaacMessi10
0
123
Member Avatar for IsaacMessi10
Member Avatar for IsaacMessi10
0
87
Member Avatar for IsaacMessi10

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 …

Member Avatar for AleMonteiro
0
123
Member Avatar for Rahul47

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

Member Avatar for Begginnerdev
0
108
Member Avatar for sanket044

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 …

Member Avatar for sanket044
0
2K
Member Avatar for tashee2007

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 …

Member Avatar for tashee2007
0
250
Member Avatar for gbhs

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 …

Member Avatar for gbhs
0
139
Member Avatar for kenomote

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) …

Member Avatar for TnTinMN
0
255
Member Avatar for Resentful

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 …

Member Avatar for Resentful
0
155
Member Avatar for yvrej17

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 …

Member Avatar for yvrej17
0
216
Member Avatar for rgilmore

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 …

Member Avatar for adam_k
0
252
Member Avatar for moodylv

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: …

Member Avatar for TnTinMN
0
342
Member Avatar for Minko

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) …

Member Avatar for Minko
0
1K
Member Avatar for Melaeusebio.24

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 :) …

Member Avatar for tinstaafl
0
144
Member Avatar for yvrej17

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 …

Member Avatar for yvrej17
0
188
Member Avatar for Resentful

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 …

Member Avatar for Resentful
0
256
Member Avatar for andrewnewspotify

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. …

Member Avatar for Reverend Jim
0
1K
Member Avatar for A.Muqeetkhan

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 …

Member Avatar for Ancient Dragon
0
239
Member Avatar for Rahul47

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 …

Member Avatar for Reverend Jim
0
166
Member Avatar for developer707

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 …

Member Avatar for TnTinMN
0
332
Member Avatar for Dili1234

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 …

Member Avatar for Dili1234
0
257
Member Avatar for dan.ni.aiza

*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 …

Member Avatar for Reverend Jim
0
248
Member Avatar for Resentful

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. …

Member Avatar for Resentful
0
125
Member Avatar for IsaacMessi10

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 …

Member Avatar for IsaacMessi10
0
103
Member Avatar for smitty68503

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() …

Member Avatar for smitty68503
0
173
Member Avatar for thewilf

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 …

Member Avatar for thewilf
0
233
Member Avatar for artemix22

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 …

Member Avatar for TnTinMN
0
403
Member Avatar for Rahul47

Hey fellas, Is there any method by which I can declare a Variable that can be used in multiple forms in VB.NET ?

Member Avatar for Rahul47
0
129
Member Avatar for yvrej17

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, …

Member Avatar for yvrej17
0
378

The End.