Recent content by mobbarley

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.

Hi guys, I have an SQL database with a trigger to fill in some extra data from other tables when a record is inserted. One task is to add a time (in minutes) to a DATETIME field. Here is a extract: DECLARE @varTimeAdjustment DATETIME SELECT @varTimeAdjustment = (select LogTime from INSERTED)...

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...

answered my own question, dont know how i missed it. frmMain.lstFiles.ListItems.Clear frmMain.lstFiles.ColumnHeaders.Clear I feel stupid :) thanks.

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...

Sorry guys, i know this is in the wrong forum. whoops. Does anyone have an answer?

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...

GROUP BY left(RTETABLE.DateTime,8), RTETABLE.Prim seems to do the trick.

Great stuff.. Is there an easy way to group this by day? I.E. show elapsed time for each day, instead of adding up all records?

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...