I don't have a back or side door toenter my work place, only the front door but I am normally very early at the office so no-one to bother me....

As far as I know, if you use isnull then the field, when null will take the value presented in the isnull, that means that question 2 must be right....

Manie Verster (6/17/2008)

---

😛 In that case the keypress event should be on the textbox where you are typing. It is now 20:03...

😛 In that case the keypress event should be on the textbox where you are typing. It is now 20:03 in South...

Good one, I never thought of a maintenance plan. Be careful though to just delete data older than a month.

Leea, the link you gave goes to the very article that are being discussed here.

I am trying to make some sense from all the squabbeling and cannot really make up my mind whether it is better to have a cursor or not. The point...

Good answer but I would rather go for:

delete from TableName where datediff(d,ColumName,getdate()) > 31. You might also...

Today I shal ignite all my actions, both at work and play with constant sparks of enthusiasm so that my zeal and exitement in whatever I am doing will subdue...

I am not sure I've got this right but your current keypress looks like it is on the subform. It is better to do the keypress on the textbox you...

Mark Beringer (6/10/2008)

---

The code below will also work, change the ORDER BY according to the column that you want the second row from, I assumed it was the Sal column.

WITH...

Lux (6/6/2008)

---

I am reminded of somethign I first saw on greenbar from the 1970's.

If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy...

sat.offers (5/30/2008)

---

Is anything wrong with the below code. Stored procedure is returning -1 rows when executed from command. Please help...

Function Main()

dim myConn

dim Rs1

dim Cmd1

' instantiate the ADO objects

set...

I am not quite sure what the problem is. Are you connected to the SQL database in MSAccess? Then this VBA script will work for you. I program continuously in...

If you made up your mind that's good because you are the one that will have to live with it. There are times when an identity column works and times...