Recent content by SteveH2508

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

I'm a Londoner, me old china!

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.

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

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

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

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

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

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.

Which one is set as the Primary Key?

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

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

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

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.

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.