Search results

  1. I

    Start of year

    Can anyone advise how I could, by giving a date find the start date of the year. For example: Date Result 30/06/2010 01/01/2010 14/12/2008 01/01/2008 Probaly simple!!!! Thanks in advance.
  2. I

    SQL Update

    Hi I am using the SQL statement below with a variable which changes via a loop, can anyone advise where the SQL is incorrect as I get an error. DoCmd.RunSQL "UPDATE" & myvar & "SET" & myvar & ".LOB = 'MOTOR'" & _ "WHERE (((" & myvar & ".LOB) Like '*mot*'));"
  3. I

    String

    I have a string that looks like $D$42. I need to identify the data after the second $ i.e 42. Can anyone advise.. Thanks in advance
  4. I

    Copy Column Data

    I have a column of data where the first record has a value, then the next records will not for so many records, then there is a value, this continues. How can I take the first value copy it into the blank fields until a value is found then that value is copied until the next value is found etc...
  5. I

    Docmd.RunSQL

    Hi Trying to use this code but it errors on the "Settled", I assume the syntex is incorrect. Can anyone advise Thanks DoCmd.RunSQL "UPDATE tblCostProcessedData SET tblCostProcessedData.[Settled?] = "Settled" " & _ "WHERE (((tblCostProcessedData.[Date Costs Agreed]) Is Not Null));"
  6. I

    Offset

    Hi I am using this formula to identify data for a pivot. It works fine but it does not identify the last row of the data. Can anyone help! =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),COUNTA(Data!$1:$1))
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  7. I

    Like "*"

    Hi I am using If IsNull(Forms![Summary form]!Combo0.Value) Then strSystem = " Like ""*"" " Else strSystem = "='" & [Forms]![Summary form]![Combo0].Value & "' " End If The code is part of a module to create an SQL statement which updates the criteria in a query. The above...
  8. I

    Parameters

    Hi I am using 'Like "*" & [Forms]![Template]![Combo433] & "*"' in a query to a combo box on a form so if I have nothing selected in the combo all data is shown, except this does not show any null values! Can any advise on how I can adapt this to allow for null values! Thanks in advance...
  9. I

    DoCmd.TransferSpreadsheet acExport

    Hi I am using this code to transfer data to a excel sheet: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ "if - Property MLT Actual Recovery", "T:\Shared\Claims Supply\Management Information\CIU\CIU Mark\New\Property Claims Fraud Report.xls" The code names the worksheet 'if...
  10. I

    Iserror

    IsError Hi I am having trouble with the syntex in a query, it is divivding two fields.
  11. I

    Iserror

    Hi In excel you can use ISERROR to account for errors, for example 0 / 0. Is there an alternative in Access! Thanks in advance.........
  12. I

    Export to text file

    Hi I want to export data from a query to a text file using code, I am assuming it would be the docmd but not sure after that. Can anyone help! Thanks.......
  13. I

    Validation

    Hi I have a row of data: 409 432 333 477 355 314 What I want to do is highlight the figure/cell if it goes above 500 or below 300. Is there a way of doing this. Ta
    • IanT
    • Thread
    • Replies: 2
    • Forum: Excel
  14. I

    Windows 2000 & XP

    Hi I have inherited a Access db, with windows 2000 as the operating system the vba code works fine importing data from an excel sheet but if you use xp as the operating system the code errors. Can anyone put any light on this!
  15. I

    Cell Reference

    Hi I have a range of cells which need there cell ref to increase by one ie K22 to K23 etc. Exmp below. Is there code which might complete this task! =Data!K22 to =Data!K22 =Data!L59 to =Data!K60 =Data!AA89 to =Data!AA89 Etc
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  16. I

    VBA If Isnull

    VBA If isnull Hi Yes... if there is a value in the cell it works fine.
  17. I

    VBA If Isnull

    Hi I am using this code: If IsNull((Range("ColA")(txtRow.Text).Value)) = False Then txtColA.Text = Range("ColA")(txtRow.Text).Value End If to pull data from a cell to a text box on a userform but it still errors if there is a null value in the cell. Has anyone any ideas why!
    • IanT
    • Thread
    • Replies: 3
    • Forum: Excel
  18. I

    User Form

    Hi I have a user form and I want to be able to have a memo type object on the form so data can be recorded into the box. The trouble is I cannot find such an object, can anyone help.
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  19. I

    Combo box

    Hi I have a form which has three combo boxs, which have 'Yes' 'No' 'N/A' as selection criteria, I need to be able to the count the number of 'Yes' selected in the boxs and the total number answered and place the total in text boxs. Can anyone point me in the right direction. Ta
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  20. I

    Textbox on form

    Hi I have a textbox on a form where a date will be input, I need code to validate that a date has been input into the textbox, can anyone help! Ta
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
Back
Top Bottom