Search results

  1. S

    Object Not Set Error

    Set cdb as CurrentDb needs to be added before the line in red - you are not initialising the database object.
  2. S

    Lost: a field with 3,200 entries!

    I'm a Londoner, me old china!
  3. S

    Lost: a field with 3,200 entries!

    Basically, it sounds like you are on the right track. ALWAYS take a copy somewhere else before you start a work session. Then, if you break it (or the computer does), or you make a mistake, you will only lose 1 session of work. When you are done for the day, put a copy on another media.
  4. S

    Saving Excel files through Access

    Setting the DisplayAlerts property of the Application object to False seems to disable the compatibility checker.
  5. S

    Lost: a field with 3,200 entries!

    Please make sure that one of your chores is to back up your file regularly.
  6. S

    Conditional formatting in continuous forms

    Would enabling/disabling the textbox be acceptable? You could then use conditional formatting without the need for VBA.
  7. S

    Strange error after changing regional settings...

    Sheer SWAG here - could Jobid be a reserved word in Turkish? More likely that this was the problem http://msdn.microsoft.com/en-us/library/office/microsoft.office.translationservices.translationjob.jobid.aspx
  8. S

    Forms printing blank second page

    Forms are not designed for printing - use a report - you will have much more control over the printed output.
  9. S

    Closing Excel from Access

    Somewhere in your automation code for Excel you have a reference which is not fully qualified, meaning it does not start with your Excel object - then your next object and so on. This starts a new instance of Excel which hangs around afterwards. These can be a PITA to find.
  10. S

    Access form

    Which one is set as the Primary Key?
  11. S

    A 2013 naming table fields

    A complete SWAG here- could this be Name Autocorrect or somesuch spawn of the devil kicking in?
  12. S

    VBA Insert New Row Below Active Cell Error 1004

    .Range("AB").Select is an invalid command. (besides AB is a column - you want to insert a row).
  13. S

    Run-time error '1004' while populating over 256 excel columns

    Which version of Excel? < Excel 2007 = 255 columns max.
  14. S

    VBA function in module corrupted

    Another cause of this type of behaviour is to have a timer running on a form - this can cause jumping around such as you describe.
  15. S

    UK postcode imput mask

    Just to add - there are also characters which are not allowed in the second part of the UK post code. I do not think you can input mask it properly - I think VBA is probably the only way to go.
  16. S

    What could be the reason

    Is calculation set to manual or automatic?
  17. S

    my code has a error !!!!

    This is the current UK OCR exam board AS level ICT Structured Task - an examination question (which I happen to be teaching) (It is a b*gg*r of a task BTW). You do not need VBA code to accomplish this task. It can be achieved using an append query with a parameter. Your code seems to be...
  18. S

    British Tax Laws - taxing global earnings of non-citizens

    National Insurance can be about 12% so 20% + 12% ain't far off 35%
  19. S

    Just getting started - but stuck alerady

    Because your IF block is wrong You can either have an 'in-line' IF block with no Else condition (generally regarded as bad practice BTW) If blah blah Then do something or you can have a 'block IF' construct. If blah blah Then do something Else do something else End If
  20. S

    Just getting started - but stuck alerady

    Lose the underscores at the ends of the lines. Sub GuessName() Msg = "Is Your Name " & Application.UserName & "?" Ans = MsgBox(Msg, vbYesNo) If Ans = vbNo Then MsgBox "Oh, Never Mind." Else MsgBox "I must be psychic!" End If End Sub
Top Bottom