Posts by hgus393

    Hello all,


    I am a newbie to Access and I am struggling to a concatenating two columns together in a table. I am filling in the column that I want to concatenate in the general tab under properties and in the field default value I fill in the two columns that I want to concatenate by the following expression:
    [Column1]&[Column2]
    Access says that the database engine does not recognize either the field 'Column1' in a validation expression, or the default value in the table 'Tbl_Test'


    This is perfect Greek to me, can anyone help?


    //Robert

    Hi all,


    I wrote here a few days ago about an issue retrieving a closed worksheets values and I got help from RoyUK(see code below and link), but for some reason the values are never entered into the open worksheet. Can anyone understand why, 'cause I can't.


    http://www.ozgrid.com/forum/showthread.php?t=63869


    Robert

    Re: Retrieving From A Closed Workbook


    Quote from royUK

    Something like


    That works fine if the workbook to retreive the information from is always in the same place. Can I specify the workbook by

    Code
    Application.GetOpenFilename


    and hard code the name of the sheet?


    //Robert

    Re: Retrieving From A Closed Workbook


    Quote from StephenR

    What do you mean by "retrieve"? Do you want to extract data from a closed workbook?


    Yes! I need to retreive data from a worksheet into a master workbook.



    //Robert

    Hi all,


    I have tried to find how to retrieve a worksheet from a closed workbook and I am almost sure that there was an answer how to do this in FAQ but I cannot seem to find it, does anyone know where this thread is?


    //Robert

    Hi all,
    I have a spreadsheet that I am trying to automate, one of the tasks is to sum some columns namely columns O to T. Column B contains the exact number of entries in the columns O to T, therefore I thought that this would be a good counter. The Spreadsheet varies in number of entries every time. In this instance the rows are in total 200 inclusive a header row.
    ie r below is = to 200. I have tried to record a macro and from that I have tried to replace the pertinent values. Does any wise person know why the below code would fail?




    //Robert

    Re: Vlookup Autofill Fails


    Ok,


    I admit it i had a brain freeze should have been as follows (Issued solved):



    //Robert

    Hi all,


    I have tried to get a vlookup formula to work, it works fine until i need to autofill it accross some columns, can anyone see where I am going wrong?



    //Robert

    Re: Pivot Table Source Information


    Quote from thomach

    Try using a Dynamic Named Range for your source data. If need be, you could create the Named Range with your code. Then your code can simply refer to this range name (which you could record) and the dyname named range will self adjuct to yoru data source size.


    [nr]*[/nr]


    Thank you, will give it a whirl.


    //Robert

    Re: Applying Mask For Date Entries


    Quote from dejayajay

    I'd like to enter dates without having to use the forward slash symbol between the day, month and year values. I've read a post by Dave Hawley explaing how to do it, but I can't get it to work for me. There must be some step that I am not aware of. Help please.



    Pls explain what you do, Have you put this in the worksheet?

    Hi all,


    I have searched the forum for this but I have not found any compatible information. I am trying to automate a tedious task and have found that using a Pivot table is the best way to go. That is all fine, but since I want to automate this, I have tried recording the whole procedure, that works fine too. But, when I tried the macro on some fresh data I saw that some rows were excluded. I have tracked down the culprit and it seems that I have, when I recorded the macro,set a fixed range as the source information. Does anyone know how to get by this? I am sitting on a computer with no Excel (oh my god!!!!) :(, so I cannot post any code. Hope someone understands what I mean.


    //Robert

    Hi all,
    I am trying to get an [if]*[/if] to work but the function does not work, does anyone know why?


    If(NrOfDays<=92;"<=3month";IF(NrOfDays>92<=365;">3month<=1Years";IF(NrOfDays>365<=1826;">1Years<=5Years";IF(NrOfDays>1826<=3652;">5Years<=10Years";IF(NrOfDays>3652;">10Years")))))


    Robert

    Re: Adding Comments In Spreadsheet


    Quote from Andy Pope

    Simply comment out the code that deals with an existing comment
    [vba] If objComment Is Nothing Then
    Set objComment = r.AddComment(r.Formula)
    Else
    '''' objComment.Text r.Formula
    End If [/vba]


    Thank you Andy!!
    Much obliged!!


    Cheers


    Robert

    Re: Adding Comments In Spreadsheet




    Magic!! :)


    What if I would like to skip a cell in the selection if the cell already has a comment?


    //Robert