Forum Replies Created

Viewing 15 posts - 316 through 330 (of 367 total)

  • RE: The Back Door DBA

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Sort Order - Include Null al last

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Automatically insert text from one text box on a subform to an unbound text box on a form as typing

    Manie Verster (6/17/2008)


    skyline666 (6/16/2008)


    Can anyone provide any more help on this?

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Automatically insert text from one text box on a subform to an unbound text box on a form as typing

    skyline666 (6/16/2008)


    Can anyone provide any more help on this?

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Deleting old records

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Eliminating Cursors

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Eliminating Cursors

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Deleting old records

    Suresh B. (6/12/2008)


    It is possible.

    delete from TableName where ColumnName < getdate() - 31

    Good answer but I would rather go for:

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Friday the 13th

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Automatically insert text from one text box on a subform to an unbound text box on a form as typing

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: how to select 2nd toprow from emp table

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Software Comparison - Part 4

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: ADODB.command is not executing stored procedure

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Running Stored Procedure from Access

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Identity column

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

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

Viewing 15 posts - 316 through 330 (of 367 total)