Thanks vongrunt! Did the trick. Is there a better way to add (x) minutes to a DateTime field? I'll have to check but i think the seconds are a little out of whack due to rounding? But this will work, I dont need to the second precision.
...to a DATETIME field.
Here is a extract:
DECLARE
@varTimeAdjustment DATETIME
SELECT
@varTimeAdjustment = (select LogTime from INSERTED) + 1/1440 * (Select ResponseTime from ProblemCodes where Ref = (select ProblemRef from INSERTED))
Now, the ResponseTime query comes back as 15 [minutes]...
Hi Guys,
I am trying to print a receipt from a webpage without any confirmation, so the javascript window.print() will not work. This will be only run from one machine in a kiosk arangement, so loading of an ocx etc is no problem.
I have got an OCX control into a webpage with a command button...
Hi Guys,
I am trying to print a receipt from a webpage without any confirmation, so the javascript window.print() will not work. This will be only run from one machine in a kiosk arangement, so loading of an ocx etc is no problem.
I have got an OCX control into a webpage with a command button...
Hi. I am using ASP to return some text strings from different variables to populate a <select> listbox.
I am wondering if there is a way to align multiple text strings into columns, something like a left justify within the list. Multiple spaces for example are ignored, thus eliminating the...
Hi guys,
In my program i have a sub which fills & formats a listbox exactly how I want.
This sub will be called by a timer.
Problem is when the sub is called more than once the listbox entries repeat. This is because im using listbox.add for each entry?
Because im lazy, is there an easy way...
Hi guys,
I would like to have a form (program) which requires a simple text password to be closed. Ive tried showing a dialog box on the close / terminate events but if this dialog is closed the main form also closes.
Could someone explain how this can be done or show me a sample?
Regards...
Hi,
I am trying to link a CSV text file table in access 2000. The file has an extension .log which cannot be changed. Access spits its dummy because of the extension. Is there a way around this?!
Regards,
John R.
Thats some nifty code, but not exactly what im looking for. Mainly I want to ease inserting records. I'm assuming I'll need to use some sort of insertable component maybe? basically I want someone to be able to insert as many records as possible using some kind of growing sheet, where they can...
Hello.
I want to set up an inventory table in my client database so I can keep track of stock @ client sites. there could be anything from 5 - 500 enteries for each client & i need to be able to view & edit this from a web page easilly.
Can anyone recommend an easy way? I'm using ADO & ASP...
Hi guys, trying to make a timeclock like query to show the time between first & last record per day, the table is called RTETABLE, has fields DateTime which is: "12/02/03 10:44:25" & Prim which is a numeric identifier for staff.
Here is the query I'm working on, but i'm lost.
SELECT...
This code shows #error in the elapsed field, but I believe that could be because the field in the database shows date & time as: 18/03/04 01:36:37pm, and one subtract the other wont work?
Regards
John R.
Lupins: On each record there will be a primary key, card number, staff number (unique to each staff member), name, and a few other details. This will actually be triggered by a card swipe, releasing a door strike.
Hey there.
I'm trying to do something similar to a time clock system for staff, there will be several records in a database each day for a staff member (with a unique ID), and I'd like to find the first and last record each day and calculate the time in between.
I have no idea how to go about...
Yes there is :) Its actually going to be entered from a PS/2 Magnetic card reader which is programed to insert a CR at the end of a read.
I found the problem, I was using a textbox from MSForms 2.0 because of it's sexy etched form effect, this seems to handle the CR differently, inserting a...
That does not seem to work.. the focus switches to a command button next to it..
using a msgbox to show the KeyCode works, but not for the enter key.
Is an option on the form wrong? Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.