G_Waddell

Myform.BackColor = VbWhite MyForm.Backcolor = RGB(255,255,0) have a look [Here](http://msdn.microsoft.com/en-us/library/ktb99cf2.aspx)

Hi, It is easier if you try and break it down into steps: 1. Access the image from the picturebox - look up picture box class properties 2. Select where to save the image to via filedialog - lookup the save file dialog in google 3. Save / Write the …

How are you passing in the date values? Are you using the text that you have given? or DDMMYYYY or MMDDYYYY or some other format? Can you put your actual SQL query down it should only logically return data for the second query as September is before October.

I take it you have the selection mode set to Row select? You will need to use the SelectedRows property e.g. Dim startingBalanceRow As DataGridViewRow = DataGridView1.SelectedRows(0) textbox1.text = startingBalanceRow.Cells(0).value textbox2.text = startingBalanceRow.Cells(1).value

Read [this](http://msdn.microsoft.com/en-us/library/windows/desktop/ms632591(v=vs.85).aspx)

You could also try the ISNULL clause e.g. SELECT ISNULL(MyCol, '') as MyCol From MyTable Would return either the value in the MyCol column or an empty string if it was null

As Jim says, you need to Explicitly tell SQL Server which columns you are inserting your data into. For example, say I had a table with two columns A and B both these SQL statements are valid: INSERT INTO MYTable (A,B) VALUES (Value1, Value2) INSERT INTO MYTable (B,A) VALUES(Value1, Value2) …

Hi It sounds like you want to create a master / details view using two datagrids? Here is an example [MSDN Example](http://msdn.microsoft.com/en-us/library/y8c0cxey(v=vs.90).aspx) although this has each one statically displayed on a form. I think what you will have to do is create a data set with your "master" data and …

I assume txtNumRows is supposed to be a Textbox on your form to display the number of rows...

Hi, Do you mean you get a phone number and you want to display in that format? dim MyPhoneNumber as string .... Textbox1.Text = MyPhoneNumber.SubString(0,3) &"-" &MyPhoneNumber.SubString(3) Or do you want to force users to enter in that format? Or Both? In that case you need [The Masked Edit Textbox](http://msdn.microsoft.com/en-us/library/11405hcf(v=vs.71).aspx) …

Hi Yes because the data is not coming from an individual table you will need to run the DELETE / UPDATE / INSERT queries as a seperate query for each table. sub UpdateHumanResource() dim cmd as OleDbCommand dim sSQL as string .... con.open sSQL ="UPDATE Academic SET FirstLevel ='" &cmbFirstLevel.Text …

Here you go: Project Hello World Documentation: When the user clicks on the button a message "Hello World" appears Open a new project and web page add a button called Button1 and a label called label1 to the page Under the Button1 click event Code as follows: label1.text ="Hello World" …

There is no ideal system for we are not perfect beings and therefore there will always be the haves and the have nots.

Ajax would allow you to change and populate the tab each time without refreshing the whole page so it could work for you.

This thread is five years old.... Anyway you should check the reader returns something first: if (objdatareader.HasRows) objdatareader.Read();

You could always let the client do the work... <a href="mailto:me@somewhere.com?subject=Mysubject">Mail Me</a> OK it depends on them having an email client installed and you will have to monitor the account...

If you have the clientside function already written in the aspx file you don't need to register it server side. I'm also not sure what you are doing here: > Dim localScreenWidth As String = " <script type='text/javascript'>showDialogue();</script>" Basically call the javascript clientside to update the hidden field values then …

Using the example TnTinMN put above if you may get a space after the last comma and don't want the empty entry use trim on the string first. dim s as String = trim(MyString) dim parts() as string = s.split(New Char() {","c} StringSplitOptions.RemoveEmptyEntries)

Good luck.... From what your saying you can get any number of files containing an unspecified amount data in any order in any format and somehow you need to break the data down and match it up to produce a single file with all the data. If I were you, …

Why do all this extra coding? Masked textbox has it all built in...

If you are using any of these methods, you will have to refresh your datagridview to show the updated records....

Hi You could use a data reader to parse through your records and add them to the listView: Dim item As ListViewItem Dim item2 As ListViewItem While DR.Read item2= new ListviewItem(DR("kilograms")) item = new ListviewItem(DR("food")) item.subitems.add(item2) Listview1.items.add(item) End While

Ok to get the selected items subitems: Dim item As ListViewItem = listview1.Selecteditems(0) Dim Position as String = item.SubItems(2).Text 'First Item is main item and index is zero based You haven't stated where attendance is coming from but you'd do something like this: If Position ="Driver" And Attendence = "IN" …

OR dim myDate as Date = Now textbox1.text = timevalue(myDate) [MSDN TimeValue Function](http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.dateandtime.timevalue(v=vs.80).aspx)

Like Begginnerdev said check the To and From values Also? why use a textbox would you not be better with a combobox and give the users fixed values of currency?

Hi Not sure what you are looking for?

What are you searching? Records in a Database? Or do you want a search engine like Google? Or Files in a directory?

In Your Add Columns routine add **ALL** the columns you need, those from the database and the extras. Next in your RunSQL routine, loop through the result set and add new rows to the datagridview as you go: dim MyNewRow as DatagridViewRow While reader.Read myNewRow = DataGridView1.Rows.Add MyNewRow.Cells(0).Value = reader.Item("Patient …

Or you could use a bit field (True/ False) - but it would have to make sense as it would only return a true (1) or false (0) OR If you pass a bit parameter you could do something like this in a strored procedure: IF(@Male =1) BEGIN UPDATE tblStudents …

Can you post your existing HTML - it be easier to figure out what is happening

Sounds like you want us to do your homework...

~Not sure what you are looking for? try searching under Msdn site for datetimepicker control for examples. Or do you want to know in which date format the date is returned in?

Where are your Events being Stored? are they on a database? Anyway the logic for comparing the two events to see if there is a clash is something like this: Sub CompareEvents (byref Event1Start as datetime, byref Event1End as DateTime, byRef Event2Start as Datetime, ByRef Event2End as Datetime) IF (Event1Start …

[ascii Table web site](http://www.asciitable.com/) will give you the Ascii key codes for most characters - you can then use the KeyCode example given by bnitishpai above to filter out what you don't want. For example, this code will block them entering the invalid text altogether. Private sub Textbox1_OnKeyPress(byVal sender as …

HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password …

Your Sql string is wrong it looks like a mishmash of a SELECT and an INSERT Statement If you wish to DELETE Something the Syntax is as follows: DELETE FROM Table WHERE 'Conditions go here If you do not specify any conditions, you will wipe the whole table.

If you are reacting to user selection of the cell: If myDataGridView.CurrentCell.value = true then 'the cell has been checked end if If you are reacting to the user selecting a whole row (Selection mode = Row Select) You only allow one row selection or wish the first selected row …

What information? Where and when do you want to display it?

Have you tried using Session variables? They will be "Alive" for the length of the session.

It looks like you have tried to enter an invalid time format 3.00:00:00 you have a decimal point not a : you mean 3:00:00:00 Or 3:00:00 either way they are the same

Hi you will have to set your Resume field type in the Database as a binary type (Image, Binary etc.) Then you will need to open the Word Document as Stream and insert the Binary Stream into the database. There should be examples of each of these steps out there …

Hi There's loads of free SVN stuff out there, I use **CollabSVN** and a plug in tool they offer **AnkhSVN** that allows you to manage it from within Visual Studio - you can check in and out items etc. through your solution explorer and it allows for branching as well. …

I think the clause you're looking for is: If 0<= a <= 100 then i.e. 0 is less than or equal to "a" which is less than or equal to 100 VB.net **should** be able to handle this although you may have to use parenthesis: If (0<= a <=100) then …

Did you execute the command? e.g. cmd.ExecuteNonQuery()

Sounds good but you have identified the main problem you will encounter that may not make this a practical project for you. By their very nature, it will not be easy to get into the Router to do this - some have Web based interfaces that you may be able …

menuitem.visible = false

You have to add the parameter as an Output Parameter BUT an UPDATE statement will not produce one and neither would an INSERT you'd have to run a select query for it. What kind of database are you using? If you are using Micorsoft SQL Server then you do this …

this would work in SQL Server - not sure about ACCESS.... sql ="SELECT * FROM tblname WHERE (Datename(month, fldDate) LIKE '%'" & textbox1.Text & "'%')"

Hi I'm going to be trying something similar soon and was told this product was pretty good for implementing licencing including trials and was free too: [Active Lock Software](http://www.activelocksoftware.com/)

Is it possible that the site has been updated and the login form, associated controls and code behind it have been changed?