Search results for query: *

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

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.

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

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

Hey, Trying to disable users right-clicking on a preview control (the blue one from the windows XP my pictures folder). The control does not have a mousedown event, and using the form mousedown event only detects a right click on a blank part of the form. I've also tried making a blank &...

Hey. I'm trying to detect a carrage return when somone is typing in a textbox and have it automatically call a procedure. Here is what I have so far: Private Sub txtSwipeCard_KeyPress(KeyAscii As MSForms.ReturnInteger) If KeyAscii = "13" Then call whatever() Me.Hide End If End Sub Does not...