i am new in vb.net programming,need your help.I hv a table named fec which have columns Amt and Date.Now i want to Sum up amount by selecting particular month from date and to display that summed up amount in a textbox.Pls suggest me the whole code using commandbuilder ,i am using access 2007 as back end.
View 2 RepliesHere is my problem. I'm not sure I am doing this correctly but I have two arrays [ strMonths(0) = "January"] etc. for each month and another one that receives input from the user concerning the amount of rainfall for a month. [decRainfall(0) = CDec(strMonths(0))] etc. for each subscript
The app. returns total rainfall for the year, average rainfall, maximum rainfall and minimum rainfall.The max. and min. should return the number that was input by the user and the month associated with that max. and min.I have everything working except for the month string being displayed (returned) after the max., min. number in the labels.
I changed the date of datetimepicker format to yyyy-mm-dd in custom format...but it displays 2009-00-22...the month part is not showing the month of the exact month..how to change the format of the date?
View 3 Repliesi have a datagridview binded with the datatable via its datasource property....now i want to add the Amount column of the dgv and display the total amount in the textbox,if the amount is greater than a certain value then i want the cell to coloured red so i did this code and it worked great:
Dim i, j As Integer
For i = 0 To DataGridView1.RowCount - 1
j += Me.DataGridView1.Rows(i).Cells("Amount").Value
Next
[code]....
but my problem is that i want the red colour of the cell to blinkafter every 2 seconds....how to do this?i need to handle the timer tick event for this but i am not able to do this.....
im trying to make a simple program that calculates the time it takes to cover x amount off nautical miles at x amount off knots, the code i have so far is this :
Code:Public Class Form1 Private Sub Label2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label2.Click
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
[Code]...
so if i say want to cruise 29 miles at 12 knts it gives me an awnser of 2 hours 24.6 mins instead of 2 hours 25. Although i do realise that 2 hrs 24.6 is technicaly right i was wondering if anyone here could help me with getting it into the correct format?
im trying to make a fast food program on which the user will input the amount that he has, then he will check on what he wants, by using check boxes. There are 7 different check boxes with 7 different amounts of money. I have the program somewhat finished (thanks for the people that helped me before) but theres still a couple of things that I still need to get finished but I dont know how to.I need to be able to get how much money the user has (this will be entered threw a text box, I think I accidentally messed this part up, because I cant get it to work right, (theres alreasy a permit amount of money in there and it needs to be what the user enters instead of the permit, 5.59, one) and this will be the maximum amount he can spend, then the user will check on the food he wants (and the program will add the sales tax also) then it will produce an answer saying if you have enough money or if you dont. But what im confused on is how do I get the users amount of money and make it the maximum mount he can spend and make sure it doesnt go over the amount that he has checked.[code]
View 1 RepliesCurrently i have a ReturnSystemDate in a module, so that whenever i need the current date and time i call this method, however my data is saving as in 1 format and displaying in another. I have my variables set up as dateTime to store the current date and time, when calling System.dateTime.now.toString() i get 11/08/2010 Time, however when casting to Date as in CDATE() i get 08/11/2010 time. How can i stop this?
View 13 RepliesI am working in a point of sale system in Vb express 2008. I want to convert the Amount in Figures to Words like: How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.
View 2 RepliesI am working in a point of sale system in Vb express 2008.I want to convert the Amount in Figures to Words like:How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.Please advise how to code for that in Vb express.
View 5 RepliesI want my game to tick over month by month at a set interval. I would use the timer control to get the interval. But how can I pause it? Say if one "month" is 5 minutes in my game and user hits pause. I would disable the timer but then when they unpause the game the timer would start from 0 again. This would make a "month" 9 minutes if a user paused the game in the 4th minute.
[Code]...
how to calculate the amount needed to save up to a certain amount.
Private Sub btnCalc_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCalc.Click
Dim dblSavings As Double
Dim dblFuture As Double
[code]....
I have a problem in trying to get a list of a date including days in a table start from first day of the month to the last day of the month. This date should not include the satuday and sunday. and I should be able to pick up those date for query match.
[Code]....
I'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
how to do select statement range from month to month using access database.. previously i use this code below when i'm using to selection those between day's or a week activities.. now, how to do range from month to month... the month format is numeric or 1,2,3,4,5,6,7,8,9,10,11,12 (jan.-dec.) representing month the ttmmonth and ttmyear fields are numeric format also in the database... how to do? look here my code for displaying week activities...
[Code]...
how to i set 2 number Amount for ... next ? [code]
View 1 Repliesi have this problem on how to calculate the amount due in our system in VISUAL BASIC.NET .in returning module, (this is for penalty purposes), if the borrower didn't return the book on time, the system must automatically generate the amount due .one daY is equivalent to 10(ten) pesos.so if the borrower didn't return the book with 2 days. the amount due must be 20.00 pesos.
View 6 RepliesI am using VB (VS 2010) and Wamp Server (Mysql - phpmyadmin). I have a Database Called "TEST" with a Table Called Test1 and 2 columns.
1 = Date
2 = Amount
Like this:
2012-04-04 1,50
2012-04-04 2,33
2012-04-04 5,60
Now what I need is this, I need to get the Sum of the Amount by the Date
2012-04-04 = 9,43
I have this code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
objconn.ConnectionString = "server=localhost;" _
& "user id=root;" _
& "password=root;" _
& "database=test"
Try
[Code] .....
I need to tab over a certain amount of times in a text fileI am using chr(9) for the tab, but I don't want to have to put in a bunch of those.
View 3 RepliesI am trying to run a program with most and least amount of snowcones.I just cannot get the least amount of snowcones to work.[code].......
View 2 RepliesI am looking to create a function in which I can pass in an integer (count) and create an amount of picturebox's based on the count.For example if I pass in an integer count, it should do this, only I don't know the correct syntax for it.[code]I am making a huge list of pictureboxes that will scroll on a form, 5 showing at a time.Also, if there are a huge amount of pictureboxes, will I be better off keeping like 7 pictureboxes on the form and keep rotating images throughout? Images are coming from a folderlist in a listbox (so I can easily pull the path of the image from an index).
View 6 RepliesI've looked everywhere, but I can't find how to do this in VB
View 1 Repliesi have this formula to get the time used and amount conversion. My problem is that when I a hour dt_total_used.Hour.ToString()) * 60 give wrong result.
'GET TOTAL USED TIME
dt_total_used = dt_end.Subtract(dt_start).ToString
'COMPUTE AMOUNT OF TIME USED
[Code].....
Does anyone know of a way to script falsifying the amount of RAM installed on a PC for an install. I have a program that needs to be installed on many systems that all have little RAM. The program requires during the setup that at least 384 MB of RAM be installed. Some of these systems only have 256 so the install fails. I know the easy answer is install more RAM. Ain't going to happen. Company has no budget. The install should be fine I think, but would like to test more. in order to do the testing to see if this would even work though I need to figure out how to have the OS tell the app it has more RAM than it does. I don't know this app but my first guess is the app queries WMI for amount of RAM?? If that's the case is there a way to set that WMI entry to something different until after the app is done? Or if someone knows another way that would be good too?
View 17 RepliesI need to induce a variable amount of lag in vb.net. System should be noticeably slower. I can raise the CPU usage of the program with infinite loops and some variable creation/assignments, but how can I actually cause lag? I'd like to have an "InvokeLag" sub which will perform an action to slow down the computer, the faster the function is called the faster it lags. The function should be as mundane as possible, not modifying anything or doing anything to cause damage other than simple lag.
View 3 RepliesOkay so maybe i'm looking at this problem the wrong way and if I am please tell me but here goes.
View 3 Replieshow can i breakdown the amount of money into available denominations. for example, i will input 7,542, the program will output how many thousands, hundreds and 1 coins are in the amount. im thinking the trimming functions of VB but no idea how to start.
View 9 Repliesi need to reduce an amount of time by x% this is what i have so far [code] as u can see ive taken the hours minutes seconds from the time and stored each in a seperate variable so from 02:30:00 i then divided the hours by 60 and then 60 again to give me the total seconds in the hours and then divided the minutes by 60. i then added all 3 to give the total amount of seconds so now the buildtimetotal variable now holds the total in seconds i now need to reducce this by x% all vars are dimentioned as integers except for buildtimehoursback which is a double the problem seems to be when i try to convert the total seconds back to hours minutes seconds.
View 3 RepliesI'm working on a project for my VB class at school. I am creating a form with several inputs and it calculates the total amount owed for a car sale. I have a text box for input of the TRADE IN VALUE of a car. the program is looking for a numeric input. If there is no trade in, how can i get this box to default to 0.00 so it doesnt error the program?
View 8 RepliesI have a date like 27-12-2010 ( day-month-year ) .I need the following value back.
31-12-2010 ( Last day of that month )
30-12-2010 ( For last day of that month )
how to accumulate the total amount in sql table. I have created a table below but it does not calculate accurately. By mean it just total up current top up amount with the 1st value of grand total. How do i total up to get the accurate figure.
ID Amount GrandTotal
99 1000 1000
99 500 1500
99 300 1300
99 200 1200