473,321 Members | 1,877 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Time Problem

What I thought would be pretty easy has turned out not to be.

I have three variables. Actiontime is formatted as 08/11/2004 11:03PM

Actiontime
JobStreamStart (11:00:00PM)
JobStreamEnd (2:00:00AM)

If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend Then

Do these actions

End If

Does not work. I am having a problem after midnight when it seems 4AM is
still not available for running. Does anyone have a suggestion?

Nov 21 '05 #1
10 1887

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
What I thought would be pretty easy has turned out not to be.

I have three variables. Actiontime is formatted as 08/11/2004 11:03PM

Actiontime
JobStreamStart (11:00:00PM)
JobStreamEnd (2:00:00AM)

If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend Then

Do these actions

End If

Does not work. I am having a problem after midnight when it seems 4AM is
still not available for running. Does anyone have a suggestion?


That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.
Nov 21 '05 #2
In that case, only comparing time values wont work since its going to
compare the time values for a given date; so, 1AM for say today is not
between 11PM and 4AM of today. You'll need to use the date values -
8/12/2004 1AM is between 8/11/2004 11PM and 8/12/2004 4AM.You should use the
DateTime.Compare function to correctly compare such values.

hope that helps..
Imran.

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:Oa**************@TK2MSFTNGP11.phx.gbl...
My Bad I meant to say 1AM....

If it says 1:00:00AM it still runs.

"Imran Koradia" <no****@microsoft.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl:
"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
> What I thought would be pretty easy has turned out not to be.
>
> I have three variables. Actiontime is formatted as 08/11/2004 11:03PM
>
> Actiontime
> JobStreamStart (11:00:00PM)
> JobStreamEnd (2:00:00AM)
>
> If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
> (Format(CDate(ActionTime), "t") < jobstreamend Then
>
> Do these actions
>
> End If
>
> Does not work. I am having a problem after midnight when it seems 4AM
> is
> still not available for running. Does anyone have a suggestion?


That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.

Nov 21 '05 #3
You could compare the just the time values but you would need to test to see
if your start time (JobStreamStart) is less than your end time for one
comparison

dim fDoActions as boolean
If JobStreamStart<=JobStreamEnd
fDoActions=(Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend
else
fDoActions= not (Format(CDate(ActionTime), "t") < JobStreamStart OR
not (Format(CDate(ActionTime), "t") >= jobStreamEnd Do these actions
endif
If fDoActions Then
Do these actions
Endif

"Imran Koradia" <no****@microsoft.com> wrote in message
news:uV**************@TK2MSFTNGP12.phx.gbl...
In that case, only comparing time values wont work since its going to
compare the time values for a given date; so, 1AM for say today is not
between 11PM and 4AM of today. You'll need to use the date values -
8/12/2004 1AM is between 8/11/2004 11PM and 8/12/2004 4AM.You should use the DateTime.Compare function to correctly compare such values.

hope that helps..
Imran.

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:Oa**************@TK2MSFTNGP11.phx.gbl...
My Bad I meant to say 1AM....

If it says 1:00:00AM it still runs.

"Imran Koradia" <no****@microsoft.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl:
"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
> What I thought would be pretty easy has turned out not to be.
>
> I have three variables. Actiontime is formatted as 08/11/2004 11:03PM
>
> Actiontime
> JobStreamStart (11:00:00PM)
> JobStreamEnd (2:00:00AM)
>
> If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
> (Format(CDate(ActionTime), "t") < jobstreamend Then
>
> Do these actions
>
> End If
>
> Does not work. I am having a problem after midnight when it seems 4AM
> is
> still not available for running. Does anyone have a suggestion?

That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.


Nov 21 '05 #4
My Bad I meant to say 1AM....

If it says 1:00:00AM it still runs.

"Imran Koradia" <no****@microsoft.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl:
"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
What I thought would be pretty easy has turned out not to be.

I have three variables. Actiontime is formatted as 08/11/2004 11:03PM

Actiontime
JobStreamStart (11:00:00PM)
JobStreamEnd (2:00:00AM)

If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend Then

Do these actions

End If

Does not work. I am having a problem after midnight when it seems 4AM
is
still not available for running. Does anyone have a suggestion?


That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.


Nov 21 '05 #5
Scorpion,
I would use a TimeRange object.

http://www.martinfowler.com/ap2/range.html

Something like:

Public Structure TimeRange

' Store the range as TimeSpans as the comparisons are "easier"
Private ReadOnly m_start As TimeSpan
Private ReadOnly m_finish As TimeSpan

' used to handle special case of the range spanning midnight
Private ReadOnly m_midnight As Boolean

Public Sub New(ByVal start As DateTime, ByVal finish As DateTime)
m_start = start.TimeOfDay
m_finish = finish.TimeOfDay
m_midnight = (TimeSpan.Compare(m_start, m_finish) > 0)
End Sub

Public ReadOnly Property Start() As DateTime
Get
Return DateTime.MinValue.Add(m_start)
End Get
End Property

Public ReadOnly Property Finish() As DateTime
Get
Return DateTime.MinValue.Add(m_finish)
End Get
End Property

Public Function Contains(ByVal value As DateTime) As Boolean
Dim timeOfDay As TimeSpan = value.TimeOfDay
If m_midnight Then
Return TimeSpan.Compare(m_start, timeOfDay) <= 0 OrElse
TimeSpan.Compare(timeOfDay, m_finish) <= 0
Else
Return TimeSpan.Compare(m_start, timeOfDay) <= 0 AndAlso
TimeSpan.Compare(timeOfDay, m_finish) <= 0
End If
End Function

End Structure

Public Shared Sub Main()

Dim jobStreamRange As New TimeRange(#11:00:00 PM#, #2:00:00 AM#)

Dim actionTime As DateTime = #8/11/2004 11:03:00 PM#

If jobStreamRange.Contains(actionTime) Then
' Do these actions
End If

End If

Hope this helps
Jay

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
What I thought would be pretty easy has turned out not to be.

I have three variables. Actiontime is formatted as 08/11/2004 11:03PM

Actiontime
JobStreamStart (11:00:00PM)
JobStreamEnd (2:00:00AM)

If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend Then

Do these actions

End If

Does not work. I am having a problem after midnight when it seems 4AM is
still not available for running. Does anyone have a suggestion?

Nov 21 '05 #6
Kelly,

Strangly enough Jay, does not shows it in is sample while we are normally
writting the same about this.

Because you are probably only working for US and English speaking Canada,
you can use the notation in those countries to create dates, however in my
opinion it is nicer to use the New Date to create dates.

You see it in the Fowler sample that is in Jays message. When you start
typing it, it shows directly as intelisence. New Date(year,month,etc)

All was it only for people in this newsgroup who are not from those
countries, who probably as me have to check that US&EnglishCanada system
twice.

:-)

Cor

Nov 21 '05 #7
In that case, only comparing time values wont work since its going to
compare the time values for a given date; so, 1AM for say today is not
between 11PM and 4AM of today. You'll need to use the date values -
8/12/2004 1AM is between 8/11/2004 11PM and 8/12/2004 4AM.You should use the
DateTime.Compare function to correctly compare such values.

hope that helps..
Imran.

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:Oa**************@TK2MSFTNGP11.phx.gbl...
My Bad I meant to say 1AM....

If it says 1:00:00AM it still runs.

"Imran Koradia" <no****@microsoft.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl:
"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
> What I thought would be pretty easy has turned out not to be.
>
> I have three variables. Actiontime is formatted as 08/11/2004 11:03PM
>
> Actiontime
> JobStreamStart (11:00:00PM)
> JobStreamEnd (2:00:00AM)
>
> If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
> (Format(CDate(ActionTime), "t") < jobstreamend Then
>
> Do these actions
>
> End If
>
> Does not work. I am having a problem after midnight when it seems 4AM
> is
> still not available for running. Does anyone have a suggestion?


That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.

Nov 21 '05 #8
You could compare the just the time values but you would need to test to see
if your start time (JobStreamStart) is less than your end time for one
comparison

dim fDoActions as boolean
If JobStreamStart<=JobStreamEnd
fDoActions=(Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend
else
fDoActions= not (Format(CDate(ActionTime), "t") < JobStreamStart OR
not (Format(CDate(ActionTime), "t") >= jobStreamEnd Do these actions
endif
If fDoActions Then
Do these actions
Endif

"Imran Koradia" <no****@microsoft.com> wrote in message
news:uV**************@TK2MSFTNGP12.phx.gbl...
In that case, only comparing time values wont work since its going to
compare the time values for a given date; so, 1AM for say today is not
between 11PM and 4AM of today. You'll need to use the date values -
8/12/2004 1AM is between 8/11/2004 11PM and 8/12/2004 4AM.You should use the DateTime.Compare function to correctly compare such values.

hope that helps..
Imran.

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:Oa**************@TK2MSFTNGP11.phx.gbl...
My Bad I meant to say 1AM....

If it says 1:00:00AM it still runs.

"Imran Koradia" <no****@microsoft.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl:
"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
> What I thought would be pretty easy has turned out not to be.
>
> I have three variables. Actiontime is formatted as 08/11/2004 11:03PM
>
> Actiontime
> JobStreamStart (11:00:00PM)
> JobStreamEnd (2:00:00AM)
>
> If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
> (Format(CDate(ActionTime), "t") < jobstreamend Then
>
> Do these actions
>
> End If
>
> Does not work. I am having a problem after midnight when it seems 4AM
> is
> still not available for running. Does anyone have a suggestion?

That's because 4 AM is not between 11PM and 2AM. Here's the way to go:

Private Sub testsub()
Dim ActionTime As DateTime = _
DateTime.Parse("08/11/2004 11:03PM")
testtime(ActionTime)
ActionTime = DateTime.Parse("08/12/04 04:00AM")
testtime(ActionTime)
End Sub

Private Sub testtime(ByVal ActionTime As DateTime)
Dim StartTime As DateTime = DateTime.Parse("08/11/04 11:00PM")
Dim EndTime As DateTime = DateTime.Parse("08/12/04 02:00AM")
If (DateTime.Compare(ActionTime, StartTime) >= 0 AndAlso _
DateTime.Compare(ActionTime, EndTime) < 0) OrElse _
(DateTime.Compare(ActionTime, StartTime) < 0 OrElse _
DateTime.Compare(ActionTime, EndTime) >= 0) Then
MessageBox.Show("Do These Actions..")
End If
End Sub

or modifying your code:

If ((Format(CDate(ActionTime), "t") >= JobStreamStart AndAlso _
(Format(CDate(ActionTime), "t") < jobstreamend)) OrElse _
((Format(CDate(ActionTime), "t") < JobStreamStart OrElse _
(Format(CDate(ActionTime), "t") >= jobstreamend)) Then
MessageBox.Show("Do These Actions..")
End If

hope that helps..
Imran.


Nov 21 '05 #9
Scorpion,
I would use a TimeRange object.

http://www.martinfowler.com/ap2/range.html

Something like:

Public Structure TimeRange

' Store the range as TimeSpans as the comparisons are "easier"
Private ReadOnly m_start As TimeSpan
Private ReadOnly m_finish As TimeSpan

' used to handle special case of the range spanning midnight
Private ReadOnly m_midnight As Boolean

Public Sub New(ByVal start As DateTime, ByVal finish As DateTime)
m_start = start.TimeOfDay
m_finish = finish.TimeOfDay
m_midnight = (TimeSpan.Compare(m_start, m_finish) > 0)
End Sub

Public ReadOnly Property Start() As DateTime
Get
Return DateTime.MinValue.Add(m_start)
End Get
End Property

Public ReadOnly Property Finish() As DateTime
Get
Return DateTime.MinValue.Add(m_finish)
End Get
End Property

Public Function Contains(ByVal value As DateTime) As Boolean
Dim timeOfDay As TimeSpan = value.TimeOfDay
If m_midnight Then
Return TimeSpan.Compare(m_start, timeOfDay) <= 0 OrElse
TimeSpan.Compare(timeOfDay, m_finish) <= 0
Else
Return TimeSpan.Compare(m_start, timeOfDay) <= 0 AndAlso
TimeSpan.Compare(timeOfDay, m_finish) <= 0
End If
End Function

End Structure

Public Shared Sub Main()

Dim jobStreamRange As New TimeRange(#11:00:00 PM#, #2:00:00 AM#)

Dim actionTime As DateTime = #8/11/2004 11:03:00 PM#

If jobStreamRange.Contains(actionTime) Then
' Do these actions
End If

End If

Hope this helps
Jay

"scorpion53061" <ad***@nospamherekjmsolutions.com> wrote in message
news:ON**************@TK2MSFTNGP14.phx.gbl...
What I thought would be pretty easy has turned out not to be.

I have three variables. Actiontime is formatted as 08/11/2004 11:03PM

Actiontime
JobStreamStart (11:00:00PM)
JobStreamEnd (2:00:00AM)

If (Format(CDate(ActionTime), "t") >= JobStreamStart AND
(Format(CDate(ActionTime), "t") < jobstreamend Then

Do these actions

End If

Does not work. I am having a problem after midnight when it seems 4AM is
still not available for running. Does anyone have a suggestion?

Nov 21 '05 #10
Kelly,

Strangly enough Jay, does not shows it in is sample while we are normally
writting the same about this.

Because you are probably only working for US and English speaking Canada,
you can use the notation in those countries to create dates, however in my
opinion it is nicer to use the New Date to create dates.

You see it in the Fowler sample that is in Jays message. When you start
typing it, it shows directly as intelisence. New Date(year,month,etc)

All was it only for people in this newsgroup who are not from those
countries, who probably as me have to check that US&EnglishCanada system
twice.

:-)

Cor

Nov 21 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: David Graham | last post by:
Hi I have asked this question in alt.php as the time() function as used in setcookie belongs to php - or does it belong equally in the javascript camp - bit confused about that. Anyway, can anyone...
10
by: Bart Goeman | last post by:
Hi, I have a question about how to put redundant information in data structures, initialized at compile time. This is often necessary for performance reasons and can't be done at run time (data...
38
by: vashwath | last post by:
Might be off topic but I don't know where to post this question.Hope some body clears my doubt. The coding standard of the project which I am working on say's not to use malloc.When I asked my...
3
by: Servé Lau | last post by:
I encountered a situation today where time(NULL) returned -1. This was because at the point of the call the function could not read from the bus because it was locked by another process. I got the...
9
by: HL | last post by:
I am using VS 2005 Beta - C# Problem: The Timer fires a few milliseconds before the actual Due-Time Let's say a timer is created in the following manner: System.Threading.Timer m_timer = null;...
7
by: Shimon Sim | last post by:
I have a custom composite control I have following property
80
by: Charles Law | last post by:
Hi guys I have a time critical process, running on a worker thread. By "time critical", I mean that certain parts of the process must be completed in a specific time frame. The time when the...
3
by: Satish Itty | last post by:
Hi all, I have a big problem in my hands and not sure how I can fix this. Any suggestions would be greatly appreciated. I have a .NET 3 tier app developed in VS2003 and .NET 1.1. the client is a...
5
by: Omer | last post by:
hi Everyone, I am using ASP.Net 2.0. When user logins, I check the credential and then made the cookie. My hoster's server is in Arizona region and I am in Pakistan. I set cookie's expiration time...
4
by: Ken Fine | last post by:
I've been living with a frustrating issue with VS.NET for some months now and I need to figure out what the problem is. Hopefully someone has run into the same issue and can suggest a fix. I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.