I would like to know how to coding in VB 2010 as this problem:The sequence numbers I want as the following:
Date 08 October 2010 --> 10-10-08
The first number is --> 10-10-08-01
The second number is --> 10-10-08-02 and so on
Date 12 October 2010 --> 10-10-12
The fourth number is --> 10-10-12-04
The ninth number is --> 10-10-12-09 and so on
How can I do it?
I am working on an assignment that will display the forst 10 fibonacci numbers in sequence. However when my results are displayed, the numbers are all stacked on top of each other like this: 011235813213455. I have tried to play with it but i can't seem to get my numbeers to space out or even maybe have a comma "," betweeen each number.[code]
View 2 RepliesI want to extract numbers from a sequence. Example: if the number is 1890928 i want to extract "1" or "89" or "909". I think it's something with left or center but i don't know how.
View 2 RepliesThen you have to take that same range and find the product of all odd numbers between said sequence. I figured out how to find the product but only if the lowest number is also an odd number. For example, if I put in the values 1 and 7 the product is 105 which is correct. But if I put in 2 and 5 the product somehow becomes 10, when it should be 15.I have to use the MOD function to distinguish between even and odd numbers, which I know how to do however it's still not working out correctly for some reason and I'm completely stuck. This is the part I'm having trouble with. Go down for full source)
For counter = intX To intB
intX = intProduct
If intY Mod 2 = 0 Then
[code].....
Write a function that will take one integer input parameter, create a sequence of numbers stored in an array from 0 to that number, and the numbers are a summation. For example, given 7
View 17 RepliesIn a project I'm working on, I've assigned each user a unique ID with the following code. [code] However, I want to replace the number at the end (RecordCount) with a randomly generated sequence of 4 numbers (no 2 can be the same).
View 3 Repliesim trying to decypher their structures and substructures and right now im wondering if anybody knows what exactly sequence and acnowledgment numbers in TCP packet headers are made of?
View 1 RepliesHow do you sort strings with numbers when you want numbers sorted based on their dimension?
View 19 RepliesI'm trying to create a program which will calculate the Fibonacci Sequence which calculates the numbers correctly however, there are a few problems.
1. When using a Do While...Loop the program becomes non responsive.
2. Kind of dealing with the program becoming non responsive; I am unable to stop the process by forcing the sub to Exit.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Operation.Text = "Calculating...."
EStop = False
[CODE]...
I Am working on a sequence checker that will check a list of numbers to make sure they are sequencial? however we now have a new job for a 5 in 1 layout so the serial number i split up over 5 collums and mixed with other data. i can import the data into a data table split by ","'s ?
[Code]....
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 RepliesI am using VB.NET. Is there a date function that calculates the date based on the number of months I have given?
for example, if i say July 2009 and looking for 10 months back, it should return Sept 2008.
I have two tables: a schedule table that contains information about how an employee is scheduled and a numbers table in which each number corresponds to a date.
[Code]...
I can do this on the SQL side or the code side. I have Linq at my disposal if I need it. The table doesn't need to be compiled by SQL. This will happen dynamically on a website and should be as efficient as possible.I don't want to have to iterate through each and look for breaks in contiguous days if I don't have to.
The class Random is out right defective. It always produces the same random numbers in the same sequence. Things I have tried so far is every kind of seed you can think of as well as Randomize. The result is that I always get the same random numbers in exactly the same sequence.
View 4 RepliesIn my below forms, the user select a name from the combo box list and enters an amount for the name selected. The user can enter as many entries. Every time the total button is clicked, I would like the total for each person to be display on the labels.
View 1 Repliesi want to set the system date of my a client pc based on the system date where the sql server reside.In short i want to sysncronize the date between the client and server.I have a working code in vb6 but i dont know how to do it in vb 2008.
dim RstDate As ADODB.Recordset
Set RstDate = New ADODB.Recordset
RstDate.Open "SELECT GETDATE() as ServerDate ", CnAP
[code]....
I have code which has been working awesomely but for some reason wil not take dates from this year. the date starts in a date picker datepick is a variable string log is the table, dater is the coloum
datepick = format(datetimepicker1.value, "dd/MM/yyyy")
dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbsource = "Data Source = C:datadatafile.mdb"
[Code]....
now the code has worked fine (and still does) for dates pre 2012. now and dates like 02/01/2012 it hates. the dates in the database are set to custom format of "dd/mm/yyyy" and i CAN NOT figure out why this is not pulling the data ..
I would like to get a 'due' or predicted inspection date based on alternating with another date? How would I go about this? [Code] The due inspection either can be 24 months (second yearly) but it has to alternate with the last safety inspection.
View 1 RepliesGiven a week number, I need to get the date of the Monday of that week.For example, I have several strings that are stored in a file, such as
"WK 28 2010"
"WK 30 2010"
They could be any any valid week number.
The Monday on Week 28 of the year is 12 July 2010
The Monday on Week 30 of the year is 26 July 2010
Its these dates that I need.
I guess I could create a lookup table, but would prefer a more smarter approach so my software will be future compatible?
I have an application where a payment needs to be made on the same day of each month.
So if the day of the month is the 7th. Then I need to take today's date and if it's before the 7th display the 7th of the current month. if the date is after the 7th then i need to display the 7th of the next month.
Ok, here is my problem. I got a wonderful dataset/database going on. In my program I have a datagrid (TicketGrid). I need it to highlight the Ticket Created DateTime if the ticket is older than 45 mins, based off system time
For i As Integer = 0 To Me.TicketGrid.Rows.Count - 1
If Me.TicketGrid.Rows(i).Cells(0).Value <= Date.Now Then
Me.TicketGrid.Rows(i).Cells(0).Style.BackColor = Color.Yellow
[code]......
Im trying to move all files from "C:SSISTest1" that are new than 2 days old to the C:SSISTest" but for some reason it keeps skipping over the if statement marked in red.
Sub Text()
Dim sDay As DateTime
sDay = DateAdd(DateInterval.Day, -2, Date.Now)
[Code].....
Have a column of dates which i need to compare to a specific time of the year, which establishes what calculation needs to be applyed then depending on the outcome apply conditional formating to highlight an adjcent cell, but need to remove the YY element as the contents spans multiple years.
if the date in A1 is between 1st Jan & 14th Mar use -8
if the date in A1 is between 15th Mar & 15th Oct use -17
if the date in A1 is between 16th Oct & 31st Dec use -8
Then deduct the above value from B1 to give a target for each row (from 3 onwards)if the target is < the value in n then change background orange in f
I have most of this working, but there are some issues yet. Basically, it's a "History" form for patients There's a date field for each entry, and if that date doesn't match the date you're accessing the form I want it to disable all controls so you can't edit the form.So it would have to check the current date with the date that is on the form.The issues I'm having are this. It seems to work because when I click today's date nothing gets locked like it used to, but when I do click another date everything in that form gets locked, including the override button and the scrollbar. I don't want the scrollbar locked, and I want to have an override button so the user can edit the form if they truly wish. It also locks the DateTimePicker so I can't pick another date, I don't want that locked either.I tried enabling the DTP in the sub below but it must get ignored
[Code]...
I have a ticketing application and I want to create a date based, sequential, ticket number.I'm leaning toward something based on Posix time as this generates a sufficiently large number and the likelihood of any two ticket numbers overlapping is slim to none (two people would have to just happen to hit the button at exactly the same time on two perfectly synchronized systems).Has anyone done anything like this or have any code snippets/ suggestions? At the moment, I'm just using a UNIX time converter someone posted elsewhere: [code] This works fine (although it's not POSIX time), but I wanted to see if anyone else had any feedback as well.
View 11 RepliesI have an MS Access database that has a field called DeletedDate. I want to use a Delete statement that will delete the record(s) when DeleteDate is 30 days old or older. I have tried several different Delete statements but none seem to work properly. They will always delete some of the records, but will leave some records where either DeleteDate is older than 30 days or will delete recored where DeleteDate is not yet 30 days old. I have tried these using DeleteDate as a Text field and as a Date/Time field. Which should I use? These are the Delete Statements that I have used:
'sComm = "DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < " & System.DateTime.Now.Date.AddDays(-30) & "
sComm =
[Code]....
I have to display the available times in a dropdownlist called "DDL_avalTime" based on the date selected in a ASP calendar.
How the program works is that when a User clicks a date form the caldendar, it checks the SQL database. In this case the table that I'm retrieving it from is "trainerbookings" from the column "trainingDateTime". The data type for this column is datetime.[code]...
I have a datagridview with several columns, but what I�m trying to do is sum km2 column based on date. I�m using the following
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CadastroSeqTableAdapter.Fill(Me.Db01DataSet.CadastroSeq)
[Code]....
The query is grouping by DATE (data), this OK, but the km2_FF values not, is not showing anything. To be more clearer, this datagridview has different values of km2_FF for the same date, I want to display the total of km2_FF for each day.
I am creating my Excel great, except that a field that contains numbers ie 1-10 or 2-5 keep getting changed to the equivilant in date. I don't want dates. If I format to text, then it cuts off part of the original data.
View 1 Repliesi have the following setup What i am trying to do is, when the user clicks on the 'calculate age ' button it must calculate the age and display the result based upon the selection in the combobox i.e if 'Days' are selected then it must display in days, if weeks are selected then it must display in weeks..etc
Similarly when the user clicks on the 'convert to date' button , it must subtract the given days(or weeks or months or years) from Todays date and set it to the maskedbox