Search results

  1. K

    Problem with Right function

    Hello all, I have a problem with the RIGHT function. It all seems very simple to me, but I can't get it to work the way I want. I have a set of fields: RETURNED BACS - ET1685311TA they all start with "Returned Bacs - " bit. I thought it would be easy using the RIGHT function to just pick the...
  2. K

    Problems compacting

    Hi, I have a problem compacting a database. i used to do this all the time at my old job, yet here at my new company, all I get is the usual blank Access screen, the sandtimer mouse icon, and if I select any other program in Windows and the switch back to Access, it crashes "MS Access (not...
  3. K

    problem with IIF function

    hello again, have written the following IIF function, which works IIf([G/L acct]=54201,"y","") so, if the general ledger account is equal to 54201, then put a "y" in the field, otherwise leave blank. The problem arises because I need 2 more accounts flagged with a "y" I have written the...
  4. K

    Importing Excel sheet into access, phantom lines

    Hi, I have been importing excel spreadsheets succesfully for a long time now and this new problem I have never seen before. I don't know how to deal with it. I have had a look on here but could find nothing similar, I have not really had a any luck searching google, mainly because I am at wits...
  5. K

    Text query

    Hi, I am fairly new to VBA. I am trying to split policy numbers from a field in an access table containing more text than just the policy number. This is the VBA we use in Excel, it looks at all the different types and isolates them: FindText(1) = "*[A-Z][A-Z]#######[A-Z][A-Z][A-Z]*"...
  6. K

    Text query

    Hi guys, I have a table with a rather unfriendly field. This is legacy data so it is not possible to alter the way data was input. The file contains text in the following way. Word1 Word2 Word3 Word4 etc... The number of words is not constant throughout the column. What I would like to do is...
  7. K

    Problems with Data

    Hi, I am new to this forum, and hope I can get the help with Access here that I need. The problem I am facing is some of the data I am using. Let me explain: I work with for an insurance company. When claims are made, customer support enter the following into their system: AA1111111111AA...
Back
Top Bottom