Recent content by Alan White

Khalid, I posted a Quick Reply but don't know what happend to it? To stop Autonumber field corrupting with MsAcces 2010 compact ensure the Autonumber field is the Primary Key Index with Acending order with not other indexes on the field. It will corrupt allowing duplicated key even if the...

Myrna, Thank you for you reply. I have shared in your frustrations trying to provide a good user interface. Persistance has its own reward. I am not sure if you have solved your problem yet. Private Sub Notes_Enter() 'Notes is the only control on the 2nd tab, i.e. Page 1 With Me.Notes...

In Ms Access 2003 Ctrl Break would stop the code on the line after and action query had completed.:) In Ms Access 2010 Ctrl Break stops the code on the line that runs the action query interupting the query.:( This seems to leave to database data in an unkown status.:confused: What is the...

The global Client setting for "Behavior Entering Field", may not always be maintained. I use the following function where I need to in the form code. Public Sub SelField(p0All2End) 'p0All2End: 0 = Entrire Field, 1 = Start of Field, 2 = End Of field Application.SetOption "Behavior Entering...

My name is Alan from Australia. I have be using Ms Access from the beginning with v1.1 and have just taken the step to upgrade from 2003 to 2010 for a number of clients. I have always enjoyed using Ms Access. It is amazing what can be achieved. Looking forward to discovering more ideas from...