Finding Available Times From Two Datetimes
Jul 9, 2012
I'm struggling to think of the best route to go down.
Basically, it's a booking system and in the database I have two datetime fields.
CODE:
As you'll see, these particular records represent seperate bookings, each taking an hour each. My question is what would be the best way of viewing what times I have available (taking into consideration the data in the database)? After 11:00, the room is free, so I'd like to return 11:00-17:00 is available.
View 8 Replies
ADVERTISEMENT
Oct 21, 2010
Bit stuck on this one, have seen alot about how to do it just cant seem to get it right. I want to have 2 text boxes with times in them.. at the moment i have them on click events then it just runs a Now for the time and fills the boxes from the system time. But then i want the 3rd box to find the elapsed time from the 2 times in the previous boxes but i just cant seem to figure it out
[Code]...
View 10 Replies
Feb 19, 2010
Bit stuck on this one, have seen alot about how to do it just cant seem to get it right.I want to have 2 text boxes with times in them.. at the moment i have them on click events then it just runs a Now for the time and fills the boxes from the system time.But then i want the 3rd box to find the elapsed time from the 2 times in the previous boxes but i just cant seem to figure it out
View 1 Replies
Apr 10, 2009
String comes back from the database with a format: '00/00/0000' I need to then compare it to a date that the user has entered in the same format. How do I make the conversion and compare the two dates?
View 5 Replies
Aug 6, 2011
DateTime: what do you use when you need to record Datetimes back in the time before 0001 A.D. (C.E.)
View 11 Replies
Dec 12, 2011
I want to enlarge an image, possibly up to 32 times or 64 times bigger than original dimensions (so that the user can see each pixel) if possible. The following is a simple function that I have to enlarge an image.
Private Function xEnlarge(ByVal Source As Image, ByVal Rate As Double, Optional ByVal Quality As Drawing2D.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic) As Image
[Code].....
View 6 Replies
May 13, 2009
I have just started using vb.net and I have a checked list box with times throughout the day shown as
00:00 - 00:14
00:15 - 00:29
00:30 - 00:44
00:45 - 00:59
What I am trying to find is a way to get the current time and find which list item it fits into. What I think I need to do is to first of all get the current time and then go through the list splitting each item into 2 times and seeing if the current time fits. For example: Split the item 00:00 - 00:14 to 00:00 and 00:14 and then check if the current time is more than 00:00:00 but less than 00:14:59 and if so do certain task.how to go about taking each list item and splitting it into 2 separate times so I can check between them?
View 2 Replies
Nov 21, 2010
i am trying to make a coin toss program where you toss a coin a certain number of times then repeat it a certain number of times.
the problem i have is "heads(counter2)" the word "heads" has a blue error line under it how do i sort the error out and also is all the code right
Public Class Form1
Dim tosses, repeat, heads As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
View 1 Replies
Mar 8, 2010
im currently working with a payroll system as a project i wonder how can i use
TimeDiff(,,,)
in crystal report(FOrmula Fields)what are the proper things to put on it?to find the difference of 2 time or any other way of finding the difference of times?
View 1 Replies
Jan 28, 2010
i want to calculate sum of two times example:
[Code]...
View 7 Replies
Apr 25, 2012
i want to subtract 18 years from a vb date object here's the code example:
Dim someVar
DirectCast(pcontrol, DateTimePicker).Value = Date.Now.Subtract(someVar)
someVar value is ?
View 1 Replies
Mar 31, 2011
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 Replies
Feb 6, 2010
How would you make the Interval of a timer to be between two times.
E.g if you wanted an event to occur between every 7 and 20 seconds?
View 9 Replies
Feb 1, 2012
Imports System.Web
Imports System.Net
Imports System.Net.ServicePointManager
Public Class GetSource
Function GetHtml(ByVal strPage As String) As String
tryAgain:
[Code]...
What I got here is a vb.net code where I parse the website for its html This function works fine. The question is this...
1.If I run 100 threads with this function at the same time, Will it work?
2.Won't it affect my internet connection as well?
I don't want to waste time creating threads and codes a hundred times so if you know the answer please advice me on what should I do instead
View 1 Replies
Jul 15, 2011
I am creating a Time Sheet Calculator Application and just need to find out how to add numbers that are in hourly form. For example 2:39 (two hours and thirty nine minutes). I know how to create code for simple addition of decimal numbers, but does VB 2010 have some kind of way of adding hours and returning a number in hourly form.
View 1 Replies
Jul 29, 2009
i have a tab control thing and i want to make it transparent. When i set each tab to that is just turns gray, even when i run it. Can someone help me. I dont want to have to apply the same image to each tab several times.
View 14 Replies
Feb 9, 2009
I want to calculate the difference between 2 different times. have the following code:
Code:
tNow = Now.TimeOfDay.Hours & ":" & Now.TimeOfDay.Minutes & ":" & Now.TimeOfDay.Seconds
tEnd = iNum1 & ":" & iNum2 & ":" & iNum3
tTimeRemaining = tEnd - tNow
This works all well until, the variables are the following:
Time Now: 7:36:34 PM
Time End: 12:46:00 AM
Because it passes over from PM to AM it gives me like 18 hours difference.Im lookiing for it to return me 5 hours
View 11 Replies
Aug 22, 2009
I call a sub about 10 times under a button, is there any trick to know in the sub code, if it is the first called sub running or the 2nd...?
getResults(0, 10)
MsgBox("pause")
getResults(10, 10)
MsgBox("pause")
[CODE]...
View 6 Replies
Aug 22, 2011
[code]I am not sure why but I have to click 2 times on the save button to save changes in my application. I may have missed something.
View 3 Replies
Nov 17, 2010
I am reading data from a provider and they have a column where ONLY the time is provided. The thrid party provider cannot change the format and that is what i have to work with. An example
[11:56PM][516]
[11:57PM][510]
[11:58PM] [510]
[code]....
I can read the data no problem. The problem that i do have is to calculate the time elapsed between records. Here I can safely assume that at most the time will cross over into the next day. I don't particularly care what date I assign to my DateTime variable so i just pick DateTime.Now and then I go through and use the TimeSpan object to calculate time elapsed. Works great except when the records cross midnight.way to do just a pure time comparison? otherwise i am left currently with converting the time into a military time and then using a simple integer comparison to determine of the date has crossed over into the next day. i then use DateTime.Now.AddDays(1) to assign the full date.
View 8 Replies
Apr 8, 2010
i want to compare two times in vb.net i.e i have 1:42:21 PM and i want it to compare with TimeOfDay in vb.net how can i do that....
View 4 Replies
Mar 21, 2011
im confuseing when should i use new to create an instance and when not for example in some program programmer declare a instance with new some times without new
dim o as process
or
dim o as new process
what is deifernces?
View 4 Replies
Apr 2, 2010
I am trying to get clock in and out times to go in one worksheet. When I coded the two buttons they created two different worksheets. What can I do to place the times together?
Public Class Form1
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Label1.Text = TimeOfDay
End Sub
[code].....
View 7 Replies
May 6, 2009
i = 5, j = 15
do while (i<j)
i=i+1
j=j-1
end while
how many times is the loop executed? is this 4?
final value of i? 9?
final value of j? 10?
when would you do a do while versus a for next loop?if the upperbound of a one dimensional array is 10, what is the size of the array? 11?CAN I GET HELP WITH THIS
dim x(20,2), y(20,2) as integer
dim i as integer
for i = 4 to 12 step 4
[code]....
how many times is the loop executed? 3?what is the value of i after the code is executed?if x and y are dimensioned as dim x(10),y(10,2) as integer, what would happen in the code?
View 9 Replies
Feb 2, 2010
how can i limit the use of a character? Specifically "." period.
View 3 Replies
Apr 11, 2011
I have a database and I have a form that you can add questions to the database. Once the question has been added, I go to the quiz which uses the database and it goes through all the questions twice. I was wondering why this is happening [Code] Also I was wondering how do I set up the form to be the first form shown on the program?
View 11 Replies
Oct 31, 2009
I have a database and I have a form that you can add questions to the database. Once the question has been added, I go to the quiz which uses the database and it goes through all the questions twice. I was wondering why this is happening Adding Questions to the Database
Public Class frmAddQuestion
Private Sub lblAnswerToAdd1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conOpen()
sql = "Select * from questions"
[code]....
how do I set up the form to be the first form shown on the program?
View 2 Replies
Jun 17, 2010
I am trying to create a small application which does mathematical calculations using dates and times. Specifically, to determine the period of time between two specific dates and times.
View 2 Replies
May 28, 2011
im comparing some datas from 2 arraylists and i need to use something like mid because the last 2 chars of the arraylists().tostring are going to be different and i want to exclude them from the check, basically im using something like this
if mid(arraylist1(i).tostring,1,arraylist1(i).tostring.length - 2) = mid(arraylist2(i).tostring,1,arraylist2(i).tostring.length - 2) then
end if how slow is this into a loop that has to do it up to 7320 times? i checked it on my pc and it semms to work just fine, under 0.3 seconds, but the problem is my pc has 3.6ghz dual core 4gb ram on a windows xp.im more worried about other slower pcs, do you think using that comparison is a bad idea to performance?
View 6 Replies
Mar 11, 2010
I have VB2008 Express.I have a main form. From the main form you are eventually lead to form 2.
Main Form - Form 1 - Form 2 - Form 3 I want to monitor how many times someone gets to Form 2. How many times Form 2 is opened but then closed without proceeding to Form 3. I do have an "exit" button on form 2, that will go back to Form 1.
View 2 Replies
