-
Stopped Watching create tags for folder in windows.
Please preview image: I want to create something like this. Red fonts is just typed using paint. (it's not software or else) I know how can I know the Size, … -
Replied To a Post in dropdownlist for excel file created in vb.net doesnt ignore blanks
Drat! I was sure you could carry out a trim on a range... -
Stopped Watching Separate a number input and show a corresponding output
I’m trying to create a textbox, where the user enters a number, and the output shows a word representing each digit, each word is in an individual label created by … -
Replied To a Post in Changing a Cell alignment of a specific cell of a datagridview
Remember to mark as solved.... -
Replied To a Post in deleting added sheet in excel
Ah yes, thats caught me out a few times too! -
Replied To a Post in ArgumentOutOfRangeException
Hi You could put a in the function to ensure there are items in the listbox: if lv2T1.Items.Count > 0 then currrentRow = lv2T1.Items.Count()-1 else exit sub end if But … -
Replied To a Post in dropdownlist for excel file created in vb.net doesnt ignore blanks
hmmm, I think it is picking up space characters as values... I may have the formula wrong it could be : `Formula1: ="=APOIO!$A$":$A$100.TEXT.TRIM"` -
Stopped Watching Sad, sad news - Nelson Mandela passed away today
Today is a sad day for South Africa, Africa, and the world; with the passing of Mandela there is an emptiness in the world that will be hard to fill. -
Began Watching ArgumentOutOfRangeException
hello, ahm, can somebody help me, i'm always getting this error InvalidArgument=Value of '25' is not valid for 'index'. Parameter name: index this is my code: Dim currrentRow As Integer … -
Replied To a Post in ArgumentOutOfRangeException
Hi, It is this line here: `currrentRow = lv2T1.Items.Count()` As Scudzilla said in VB you have zero based indexes but count will give you the count of items i.e. In … -
Began Watching deleting added sheet in excel
Hello! anyone... i cant delete the sheet i have added in my excel file. i already tried below codes to delete it but it doesnt work... and i'm not getting … -
Replied To a Post in deleting added sheet in excel
Hi [This is an example from Microsoft](http://msdn.microsoft.com/en-us/library/s9kdkks3.aspx) -
Replied To a Post in dropdownlist for excel file created in vb.net doesnt ignore blanks
Hi Try changing the formula part of your code to: `Formula1:="=Trim(APOIO!$A$2:$A$100)"` -
Began Watching Separate a number input and show a corresponding output
I’m trying to create a textbox, where the user enters a number, and the output shows a word representing each digit, each word is in an individual label created by … -
Replied To a Post in Separate a number input and show a corresponding output
Hi Create an array like so: dim NumberToText as String = new String() {"zero", "one", "two", & _ "three", "four", "five", "six","seven", "eight", "nine"} Then parse through your input one … -
Replied To a Post in dropdownlist for excel file created in vb.net doesnt ignore blanks
Hi could you post the code you use to populate the lists? -
Began Watching insert combo box into the column using vb6
hi there, can someone teach me how to insert combo box inside the column.. -
Replied To a Post in insert combo box into the column using vb6
Column of what? Datagrid? -
Began Watching Making a timer increment more time
hello I want a timer in my Access database form using Visual Basic I have the code dim i as integer=0 timer1= i label1.Text = "Remaining time:" + CStr(2500 - … -
Replied To a Post in Making a timer increment more time
Hi, You need a variable to hold the current value and a second one to hold the "target" value... The timer control fires depending on the interval you set for … -
Began Watching dropdownlist for excel file created in vb.net doesnt ignore blanks
Hello to all I have a problem When i create an excel file with some dropdownlists in my vb.net page the dropdownlist in the excel file doesnt ignore balnks even … -
Replied To a Post in dropdownlist for excel file created in vb.net doesnt ignore blanks
Hi, Are you using a datasource to provide the dropdown values? Could the values be either NULL values or spaces? -
Stopped Watching New to visual basic
Hi all , Im starting to learn visual basic and I have a question if all dont mind to answer me , I need to know and identify each individual … -
Replied To a Post in hi im a newbie here
I did, but as they were a newbie I though they may have accidently left it out when they copied it over, it must be there in the actual code … -
Stopped Watching What are you eating/drinking right now?
Well I just started eating dinner and thought this would be a neat topic. Everyone knows we love to eat while on the computer; two birds, one chair. I'll start … -
Replied To a Post in create tags for folder in windows.
Sorry, you'll need to perform some sort of shell extension work to get into the windows shell. Yes, the main example with the link I sent was on the Context … -
Began Watching hi im a newbie here
'i got a problem here. i want to add a new record to my database but when i click the add button an error occurs saying syntax error on INSERT … -
Replied To a Post in hi im a newbie here
Hi, did you specify an INSERT command for your [DataAdapter](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.insertcommand(v=vs.110).aspx) (can't see it in your code sample) -
Began Watching how to use key press?
i would like to search in my datagridview by using only a textbox and will automatically search the following data in my server how could i do that? please anyone … -
Replied To a Post in how to use key press?
Hi I think you are looking to use [textbox autocomplete](http://msdn.microsoft.com/en-us/library/system.windows.forms.textbox.autocompletemode(v=vs.110).aspx) which will be using your gird as it datasource and then you could select the matching row... -
Stopped Watching How to detect the enter key and make it null
Private Sub txtPassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPassword.KeyPress Dim NotAllowed As String = "~`@%^&+={[}]()!:,;'><?/|\-.#+()_$*" If e.KeyChar = ChrW(Keys.Enter) Then e.Handled = True End If If e.KeyChar … -
Replied To a Post in Collection items will not update
Ok the collection is in the settings.. What scope have you given the setting? Application or user? -
Began Watching How to detect the enter key and make it null
Private Sub txtPassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPassword.KeyPress Dim NotAllowed As String = "~`@%^&+={[}]()!:,;'><?/|\-.#+()_$*" If e.KeyChar = ChrW(Keys.Enter) Then e.Handled = True End If If e.KeyChar … -
Replied To a Post in How to detect the enter key and make it null
Hi, Yes `e.handled = true` will stop the character. -
Stopped Watching Christmas is coming
Christmas is my favorite time of year. I love to go christmas caroling and my favorite eating a big christmas dinner. -
Stopped Watching inserting images to ms access database
Private Sub btnsave_Click(sender As Object, e As EventArgs) Handles btnsave.Click 'to check if the records already exists... Dim sqlQRY As String = "SELECT COUNT(namee) AS namecount from staff WHERE namee='" … -
Stopped Watching Clearing of Datagrid View
hi everyone my question is how to clear a datagrid view in vb.net 2010 i have tried DatGridView1.Clear() but it only works once and i would like to clear my … -
Stopped Watching Memorable Quotations
Once harm has been done, even a fool understands it. -- Homer -
Stopped Watching Interesting Question / Challenge
I have an interesting challenge and was hoping one of the gurus can assist. I have a program running on a client machine that I need to "trigger". The program … -
Began Watching Changing a Cell alignment of a specific cell of a datagridview
Hi all I have a DataGridView with 2 Columns an Order column (text) and a price Column (decimal) The Datagrid contains all the orders and price for a certain customer. … -
Replied To a Post in Changing a Cell alignment of a specific cell of a datagridview
Hi, You would need to catch the cell using the [DataGridViewCell Class](http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell(v=vs.110).aspx) and then the [DataGridViewCell.Style Property](http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell.style(v=vs.110).aspx) to alter the style for that cell. -
Began Watching Collection items will not update
I have a radio button and a listbox. After clicking on the radiobutton, a collection of items will be added into the listbox. I'm trying to go back to the … -
Replied To a Post in Collection items will not update
Hi, I don't see where you are removing items from your collection. I only see you adding and removing from your listbox. -
Began Watching increment or loop, How? help me Good Sirs.
 i have 2 database listview1(from tbl_storage) listview2(fromsales) so i want my listview items and subitems to be increment or be loop correct me if im wrong with that. … -
Replied To a Post in increment or loop, How? help me Good Sirs.
Wow! Thats a lot of Code to go through! So I'll just go back to your question... You have a list of items and for each item you want to … -
Began Watching New to visual basic
Hi all , Im starting to learn visual basic and I have a question if all dont mind to answer me , I need to know and identify each individual … -
Replied To a Post in New to visual basic
Hi Reading your example, `this = that.theother(something)` I would take that to mean `variable = <Class or Namespace>.<Function>(Parameters)` where `variable` is some sort of variable of a type e.g. Integer, … -
Began Watching xlsx file format or file extension is not valid
Hi guys I'm having a problem in opening excel files using the workbook.open for me to save all the changes made by oledbcommands. Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" … -
Replied To a Post in xlsx file format or file extension is not valid
Hi, Do you have Excel installed on the machine? and if so, is it a version later than 2003? i.e. 2007 onwards to handle xlsx files? Or could something have … -
Began Watching Select item in listbox by pressing the Enter button
I'm trying to select items from the listbox when pressing Enter on the selected item. Here is what I have tried so far: Private Sub ListBox1_KeyDown(ByVal sender As Object, ByVal …
The End.