Atove

It is better to not use numeric column names but if you must then I think you can reference them by enclosing you column name in apostrophes, like so: '10'

If you comment out your Catch statement within your Try block of Save_Record() Sub and try executing the code again; is there a particular element that is highlighted as an 'object reference not set to an instance of object' and what is it?

Seems to work fine; are you setting the Handle to the right control? Private Sub txtPassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles [Your_Control_Name].KeyPress

If you want to update a single record you need to add a where clause to your sql statement. sqlcmd = New SqlCommand("UPDATE table1 SET [Processor]=@Processor WHERE id=@id", sqlconn) You just need to get the unique identifier for the row you wish to update in your database table. Hope this …

How about a version of tic-tac-toe; playable either against the computer or against another player over a network? Hope this helps!

Try it like this: [CODE] tmp = IIf(IsDBNull(rdr(0)), 0, FormatNumber(rdr(0))) [/CODE] It appears that you cannot use .GetInt32 in an IsDBNull function. Additionally because IIf statements run both sides of the true/false statement if you want to use rdr.GetInt32(0) when it is true you will have to use a standard …

You need to parse in the value you want as a string, apply the formatting, then return the value as a string so that it shows the decimal places. [CODE] Private Function calc(ByVal valueIn As Double) As String Dim newValue As String newValue = Format(valueIn / 100, "0.00") Return newValue …

This will create a message box that appears with a message of your choice. [CODE] msgbox("Example Message") [/CODE] Hope this helps!

Is your datasource copied to the exact same location on the other computer? As stated in your code. That may be your problem; however without knowing abit more about the error/s its throwing i cannot really think of anything else to suggest. Hope this helps.

Try writing it out like this, should work. [CODE] Poplist2 = "SELECT Machine_ID, Make, Model, Problem, Rating, MacStatus WHERE Rating =" & NewTime & ";" [/CODE]

Hi all! I'm trying to create search criteria for searching my sql server database. It selects the correct data when you select an option to search by; however i'm trying to make it so that if nothing is selected in an option it selects all data. the code i'm using …

I've had a quick look at this; seems to work fine when you call the checkinput() sub. I ran it calling checkinput() on form load and it changed the button to lime. [code] Public Class Form1 Public Event Done() Private Sub checkinput() 'Port = ReceivedString.Split("&") 'For i = 0 To …

Hi all; I'd be really grateful if someone could assist me with this problem. What i am trying to do is create a query that pulls information from two different tables: tblBooking and tblConcessions. tblBooking holds the ID number of tblConcessions as a ForeignKey. What i need within my statement …

Ok heres my problem which i'm starting to find very annoying :S I am trying to load a date stored on my sql server database into a date time picker. [code] Dim MyDate As Date = (DetailLookup("PLIExpiry", "tblConcessions", "ConcessionID", varCompanyKey)) frmConcessions.dtpPPLIExiryDate.Value = MyDate [/code] DetailLookup is a public function that …

Hi all! Okay i've been attempting to create this segment of code which is supposed to read from the database; based on search criteria entered, then load them into a form for viewing/editing. I am able to read the concessionID from the database; however i am then unable to select …

Hi all; i'm trying to connect my program to an SQL Server Express database... however i am just getting an error that simply states: "Login failed for user 'sa'." Within my code this appears on: objConnection.Open() my code so far is: [code] Imports System.Data.SqlClient Imports System.Data Private Sub Form1_Load(ByVal sender …

Hi all! I'm developing some software for my current employer and i'm looking to incorporate an option that changes the font size across all forms for accessibility purposes. Now I have managed to make it work; however the code appears long and inefficient. My question to you guys is: Is …

Hi dhavalcoholic, One of my friends has a similar problem; i stumbled across this forum that potentially has a solution. I have not gotten around to trying it yet; but it may well be worth a look. Hope this helps. [url]http://forums.techguy.org/hardware/580944-toshiba-satellite-d-drive-not.html[/url]