finding a time inside a time range -
i use a timer to tell the server when to start sending me time. 'theoretically' it is supposed to start on-time and look like this
11:22:54 - 11:22:49
11:22:59 - 11:22:54
11:23:04 - 11:22:59
11:23:09 - 11:23:04
etc
where i compare the current time on the left (what just came in) with the time on the right (the time stamp just prior)
but sometimes the server 'hiccups' and i might see this instead
11:22:57 - 11:22:49
11:23:02 - 11:22:57
11:23:08 - 11:22:02
11:23:12 - 11:23:08
or something like that
the server is geared to send out a time stamp every 5 seconds (its minimum) but i need to make a change at :59
basically i need to evaluate the current time stamp and the one just prior and see if my :59 is somewhere either in between or at either end (where it 'usually' but not always is)
something like
"if somewhere in between the current time and the last time a time with :59 seconds can be found
dostuff
end if"
[02/03] Finding out current time from which range -
Hi ,
i have 3 range of time how do i find out the current time belongs to which range?
range No1. 0806 to 1605
range No2. 1606 to 2305
range No3. 2306 to 0805
thanks expert
finding a time inside a time range -
i use a timer to tell the server when to start sending me time. 'theoretically' it is supposed to start on-time and look like this
11:22:54 - 11:22:49
11:22:59 - 11:22:54
11:23:04 - 11:22:59
11:23:09 - 11:23:04
etc
where i compare the current time on the left (what just ca
Can I simplify this redundant code -
This is a portion of the code, which seeks, row-by-row, specific projects, and inputs the hours associated with it into a new timesheet. The redundancy will be plainly obvious. Like I said, the code works, but I've only been writing code in VBA for a week, so I'm not knowledgeable on
time range help -
hi,
does anyone know how to specify a time range and then compare it against the current time?
Like:
range = 8:00 am to 9:00 am
is the current time between the above range?
thanks in advance,
aaron
[EXCEL] Changing the Modulus Range Using CONCATENATE() -
Hey Everybody!!
Its been awhile since I've posted and I have come across an interesting question...
I want to save the user some time AFTER the macro has finished running. The modulus range (the range selected in the SeriesCollection) of the graph is determined by the user once
[Excel-VB] Postscript/Range Question -
Hi,
I am trying to create productivity report of each of our managers using Excel/VB/Adobe Acrobat. The report must be in PDF form so I'm using Distiller for this.
Basically my VB so far places all the manager ID numbers (one at a time) in a pivot table and grabs the resulting d
Excel VBA: finding the first row in a Range -
I want to determine the rownumber of the first cell in a Range. What would be the best way to do that?
Range.row seems to yield the correct number but I'm not sure if that is reliable.
Another way would be to use a combination of Range.rows.count and Range.Cells.SpecialCells(xlCel
MS Access: Dates - finding free time. -
I am trying to come up with a design for a database in access which stores student bookings on driving lessons. One of the requirements is that a query can be ran which will show an instructors free time for a given date range.
I am not too sure whether this is possible though. The
help with comparison of range of time -
good day to all!
my problem is how to compare the below samples:
time1(01:00 PM - 03:00 PM)
time2(02:00 PM - 03:00 PM)
im confused on how to compare those..
i mean if time 2 is in time 1's range then that is an error..
can someone help me with these?
thanks a l
Calendar Explorer time range selections -
Bear with me, this is hard to describe.
I'm a fairly knowledgeable VB(A) developer. I understand basic concepts. I
say this because what I need to do sounds simple, but I can't find
documentation on it *anywhere*.
What I'm trying to do is implement a custom app using the Outl
What is the best control for value range -
Hi
I have that do program that the user typed the value min and value max, but the range type can not have in the table example
my table has clumns: val_min,val_max,perc..etc
inside has
0 - 900
901 - 1800
1801 - 9999
It are value min and max respctive,
Crystal XI and ASP.NET -
Hey all,
I thought I saw this type of topic posted before but havin a hard time finding anything on it. Basically I have a crystal report that is getting it's data through a OLE DB source (SQL server 2000) inside the report. I have included it into my asp.net and when I load the page
Time Related Problem - Help Needed!!! -
hi guyz,
i'm having this time related problem.
there is this school project i'm working on where the school wants to give the students an access to a computer in the following time range;
60 mins/1 hour
30mins
10mins
and so on...
now i have it all working fine, where i h
range.Select hangs -
This is an interesting one as the first time round it gets called, its fine, but the next time, with different values, its totally fine.
im using C# to automate excel.
Basically, if we select a range in an active sheet (just 1 cell), and we do a range.Select(), it will hang and w
Converting UTC to Correct Time Zone -
Is there any way to convert a UTC time into the time zone that the user has selected for their computer?
09/16/00 3:36:59 AM UTC
This would require somehow finding what the current time zone settings are and then adding or subtracting so many hours. Any ideas?
finding X Y pixel coordinates from a range -
Can anybody give me some tips on finding a screen coordinate given a range in MS word? I found some info on how to do it in excel at:
http://www.excelforum.com/showthread.php?t=380495
But I can't do the same thing in word because the Word.Range object doesn't have a Top or Left
Twurp. -
Do you want to become a full-time mom with a part-time business, which will give you financial independance? Acorn International can offer you this opportunity. We market the world's most Exciting Children's Bath Products, which turns bathtime into a Magical and Educational Extravaganz
Alternatives to SQL Server DATETIME type -
I'm studying ADO and database access, and I noticed that SQL server 2000 combines date and time in a single type called DATETIME. This seems like it would be clumsy. First, the date and the time are two pieces of information and should not be concatenated. When doing Selects for a rang
Finding Creation Time -
Okay, I need to add a feature to my program so when I select a file from the FileListBox, it will show the Creation Time of the file in MsgBox. I was hoping I could get it to show the time the file was created by a standard EST clock, not by the persons time on their computer, because
Time Comparison -
i have a time logging system, i m using SQL server 2000 at back end
i have a table named TIME contain a field TimeIN of DATETIME datatype.
login process simple moves the current time in the TimeIN field. now i want to select records within time range. but i failed to write a query f
XL Graph - Data range changes -
I have defined 12 ranges in Excel
Jan = A1
Feb = A1:A2
Mar = A1:A3
etc etc so on Jan I have just a single value to graph. In June, I'll have 6 values to graph.
When setting up the graph I need to specify the data range/series but this will be variable depending on which mon
OCX: how to know when in IDE design time -
hi all,
I'm writing an OCX and I want to know (inside Usercontrol_Initialize, Usercontrol_Resize, etc sub) if it is a design time inside the IDE or if it is the application that is running.
Someone can help me?
Thanks very much
Carlo
Finding the available ports in the computer and at the same time ignoring the port th -
Gentlemen:
Does anyone knows where can I find a piece of code for finding the available ports in the computer and at the same time ignoring the port that the internal modem is connected to?
Thanks
Andy
Finding range in VB -
How do i find the range of three numbers in VB.
On the face of it, it sounds pretty easy.
How to copy/paste cells without picture -
I am having a weird problem and cant find out how to fix it. I have a function that will copy a range of cells and paste them but it pastes them like as if I took a snapshot and then used it as a picture. I need the cells to be pasted by cell, not one picture. this is from one workshee
time estimate -
about how much time would it take to save the first million or so prime numbers to a file using VB?(Finding them as well)
VB - PDF Forms Help Needed -
inside visual basic, I need to display a PDF template file that has Form elements inside it.. The user will fill out this template and hit submit. This Template will then save itself with a new name and then re-display the new pdf file to the user.
Has anyone done anywork like thi
Obtaining DLL files -
I know that we aren't supposed to use dll files from the system32 folder, but what if I do a fresh install on a computer then copy the dlls on to a disk for use. Would it be safe to use those files?
The reason I ask is because I used ********** and it said I have 32 files not found
[2005] how could i get the process time using tickcount() mehtod. -
helo,
i am using tickcount method to get the total count of time when system was started till now. in the meantime if i want to get the time of some specific running process or function inside my code of c#. how i will do that.
i simplify it in other way that, how to calcult
Simple VB/Excel HELP! Cell Reference. -
I am trying to do something relatively simple, but can not find out how to do it.
I essentially want to access a cell in a column while using a variable for the Row. Here is a snippit of code for the sub that I have. (that obviously does not work)
Dim i As Integer
Need help fixing control to show AM, PM time, not 24 hour time -
I've have the c++ source code for a dayview control that displays the time on the control in 24 hour time; 01, 02, 13, 14, (like military hours). I would like to change the display time to show 12 hour AM and PM time.
Can anyone help with finding where the code is that sets up the
sql server Sp problem -
hi there
How much time will it takes to execute and finish the sp.
Because i am using while loop inside the Stored procedure so Suppose if i give 120 time , each time i am fetching records from on table and inserting into an another table.
So In this case it is inserting only
Time discrepnecies -
Has anyone ever seen this before.
I have a process and when the process is completed the date and time is stamped inside of a document, 8:00.01 07/31/2002. Another process is executed and the resultant files date and time is set to the earlier mentioned date and time stamp.
Th
extra run-time error in exe -
Greetings,
OK, here's where the issue stands now:
I found the line of code with the error
CCfg(NumCfg).AutoUser(i) = sWord(2)
The subscript i, for AutoUser is out of range, and that error is successfully trapped when compiling the vbp.
The exe,
Infinite Loop on a timer -
I am having trouble creating a program that constantly updates these two cells, cell1 and cell2, every X amount of seconds. It just seems to update once I start the function, but then never again. It actually crashes excel some of the time
Sub UpdateEMA()
Do While Worksheets("S
How to get an incremental sum of values over time -
Hi
I'm using Sql Server 2000 Sp3a (that can't be changed). All my T-Sql code are stored inside stored procedures.
I have a simple query that return a value each time a changed occur over a period of time. However, the value returned is the value at that point. What I would like t
[HELP]Display local time ingame -
How would i go about displaying my local time inside a game such as SWAT4 ? I play games for hours and lose track of time lol
Get path to desktop -
Hey all,
Every time a new user is created, I would like to make a folder on the user's deshtop. I am having the hardest time finding how to do this. Any help would be appreciated.
Thanks,
bebandit
Inside Jihad -
http://www.time.com/time/asia/magazi...shmir_sb1.html
Date range question -
I have a table which has records like below
IDNO From To
---- ----- ----
1 1 oct 2002 3 Oct 2002
2 8 oct 2002 11 Oct 2002
where fields IDNO = numeric, From=date/time, To = Date/time.
I am accepting a date range from the user for exa