Search results for query: *

Thanks for your responses.... It does need to be intFac * i NOT intFac * 1 :o) Lol, yesterday was a long day guys.. thanks for the quick help!

I am writing a simple code using a function to return a value. When I run the code, the function always returns one, therefore giving me a logical error. Any and all help is appreciated... Thank you!! Here is the code: Private Function Factorial(ByVal intNumber As Integer) As Integer...

I am trying to develop a scheduling system that allows users to have a recurrence pattern. For example, a user may pick Jan 1 as start date, and Feb 5 as end date, and specify they only want to rent the facility on wednesdays. Therefore, I am trying to start this program by determining the...

I am trying to develop a scheduling system that allows users to have a recurrence pattern. For example, a user may pick Jan 1 as start date, and Feb 5 as end date, and specify they only want to rent the facility on wednesdays. Therefore, I am trying to start this program by determining the...

Thanks a million! I never would of figured that out... lol. Maybe I can return the favor one day!

cmdInsert.Parameters.Add(New SqlParameter("@TNames", SqlDbType.Char, 20, "TName")) 'cmdInsert.Parameters("@TNames").Value = txtTeamName.Text

Can someone please tell me how to establish a connection to an Access DB from a vb.net form. I have tried to do this from server explorer, but I don't have the option to select MS ACCESS. I get sql server, oracle, and several other options, but Access isnt one of them. Thank you in advance!

create a stored procedure. create variable in stored procedure Create Procedure procgetbooks @publication as varchar as "Select * from mytable where publication = @publication" in vb code do this dim cmd as sqlcommand = sqlconnection1.createcommand cmd.type = storedprocedure cmd.text =...

There are different ways to populate the list box, and I am not sure if yours is correct. try this sqldatadapter.fill(dataset1, "Books") 'Bind listbox with lbName .datasource = dataset1 .displaymember = "books.id" .valuemember = "Books.id" end with 'you also have to filter the sql statement...

An odd, and most likely not the best solution is to use the x/y coordinate system to disable the context menu. then set the mouse down event to mean the right mouse button and do nothing. handles mybase.mousedown if e.x = area of grid and e.y area of grid then disable context menu Sorry...

nevermind... i figured it out.. thanks btw, i used the convert function

Hello all! I am trying to pull the time- hour/minutes out of a sql server query. When I attempt this.. I keep getting errors Select datepart(hh:mm, time1) From Table1 I have put the hh and mm in "hh:mm", 'hh:mm', and all types of variatons, but it keeps giving me errors. Any help with...

That did it! Hey, thanks a lot man... your help was greatly appreciated!

Just a quick thought, you need a comma/" between your select and from statement in the sql command.

Actually, that is where my problem lies... I am new to VB and don't know how to search a dataset and check for any conflicts. If you could help with that, it would be greatly appreciated. Thank you!

I am working on a program that will be used to check out company vehicles. Users will go online and pick out their vehicle, dates, times, etc. The problem I am having is this: When the user clicks submit, how can I search the dataset to ensure that a vehicle is not going to be reserved by two...