I'm using this to set the default values of the DTP controls on Form_Load:
Dim dtNow As Date = Now()
dtpStart.Value = dtNow.AddDays(-7)
dtpEnd.Value = dtNow
The problem is, when those values are grabbed from the DTP controls, Access is treating them as wrong datatypes.However, if I manually rechoose the same dates, the SQL statement will work.So, what seems is happening is that it isn't recognizing the initialized values as valid date/time values until I physically choose them.Anyone know a workaround for this or what is really going on and how to resolve this?
What I need to do is to have my program look at 2 different values then return a value.
Here's an example:
If my tube material = SA-214 and the tube gauge = 20 then my tube wall thickness = .032. The thing is I have 5 different types of tube material and 12 different tube gauges so based on which tube material is selected and which tube gauge is selected the tube wall thickness will vary. So if I select a TM of SA214 and a TG of 14 then my tube wall will be .076.
The application contains 14 DateTimePickers, 2 on each tabpage of the form.he user most commonly ould open the application, input values on tabpage 1 and calculate the results. Some months later input values on tabpage 2 and calculate the results and so on.
I have two datetimepicker controls one as a start date the other as end date, How do I go about subtracting the values to ge the number of hours? I tried...
I have a database that has null date values in it. When I call the columns from the database with the null datetime values and display it in the datetimepicker text box using a dataset, theres always values in the datetimepicker text box. It sets everything that was in the database with null values to the current date. This is what i have..
I have two datetimepicker controls on my form: dtpPickup and dtpReturn I need a way to ensure that the dtpReturn date selected is after the dtpPickup, and not before. How do I do that? And also, how do I get the values of the datetimepicker selected controls? Also, how can I set the values of the datetimepickers to these two private variables? Private mdatStart As DateTime Private mdatEnd As DateTime It will not let me save them with the Sub for the date time pickers.
Can someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
I have to Create a Bowling Scores application that allows the user to enter 5 scores and then displays the high score and the low score and then clicking on the Statistics button there would be a label showing which is higher and lower. We HAVE TO USE FOR AND NEXT STATEMENTS.
is there any way to use 2 for every.... statements?
i want to load up my.settings and 1 list will make new toolstripdropdownitem and the other lists is for the tooltiptexts
or I could do it another way, but how can I check the index of items in a my.setting string collection? like if I want to get the text of index number 3 how do I do that?
I am using Microsoft Visual Studio 2008 with VB.NET, and in class we were assigned this project: A procedure should calculate a 2% price increase on all red shirts, but a 1% price increase on all other items. In addition to calculating the price increase, the procedure also should calculate the new price. You can use the variables strItemColr, strItem, decOrigPrice, decIncrease, and decNewPrice. Format the original price, price increase, and new price in the lblOriginal, lblIncrease, and lblNewPrice controls, respectively.
I need to know if this particular block of code will work, and if not, what i need to do to make it work. I'm doing touchy business and i'd prefer to have it right the first time.
I just wanted to know if it's possible to get an if statement to accept two strings into the same text box. An example of my code so far is below: (although please note that the program does not accept the strings after the "Or" boolean)
Private Sub btnpreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnpreview.Click If cbox2.Checked Then
Okay I need two blocks of code for each of these:[code]Now both of these are under the if statements checking if the startsWith or equalsIgnoreCase check boxes are checked. (Only one is under the corresponding code not both.) At runtime when I check off the boxes neither of these two code blocks execute.
I'm having some problems getting a query to run based off another query. Here's the database diagram to give a little background. The primary keys for all the tables are automatically generated by identites. The first 2 insert statements (Donation and Food_Donation) work but I can't get the last insert into Donation_Details to work. Here's the code so far:
I cant really find any good sources for connecting to a database via connection string and executing prepared statements. Could someone show me an example or point me to a resource that might be useful?
I have two if statements and my project sees one and not the other. Here is the code: If (IsPostBack) Then HandleUploadedFile() End If Dim savePath As String = "Images " If (fileUpload.HasFile) Then [Code] ..... When I trace my code I find it goes to the second if and then go to end if without running the code inside the conditional.
I am trying to use if statements to add the prices of a cruises special packages together. I am using check boxes for the packages, so any, from none to all 3 are able to be checked. The packages available are VIP, excursion and restaurant. The price will also depend on the cruise length (7 or 10 day). I am wondering on which format to use, and if I even need to use if statements, how to make this statement true,
I am very new VB .NET and just starting If statements. My problem is: Write an If statement that determines whether the variable CurrentBalance is greater then 1000.01. If it is, multiply the variable CurrentBalance by 1.005. Otherwise, multiply CurrentBalance by 1.007.So far I have
Sub Main() Dim currentBalance As Boolean System.Console.WriteLine("Enter Current Balance: " & currentBalance) If CDbl(currentBalance) > 1000.01 Then
[code].....
I really don't even know if thats how I should be starting. Not sure what to put after the first Then on how to make it multiply currentBalance by 100.5.
I have a general query that I need clarifying by some intelligent boffins such as yourselves. I have the following code in a function:[code]Obviously the Dispose method will never be called on the site object or the helper object. This may be a stupid question but can I get an explanation as to how these objects actually get disposed of in memory? Is it just by the fact that the enclosing method they were created in has been disposed of?![code]