Recent content by ss8880

try this Alike "%"&[srchtxt]& "%" ALike "%" & ([Forms]![SearchICD10CM]![Icd10CM]) & "%") :banghead:

Microsoft Access Tip: Creating an AutoNumber Field Starting with a Number Greater than 1 In Microsoft Access tables, the AutoNumber field type allows you to assign a unique sequential number to each row in a table. AutoNumber fields are often used as the Primary Key, since they are unique and...

I have the same problem in access 2010 with now 15000 records that linked to the id in between as a tree ( i cannot make repairs) any help plz.....

DoCmd.GoToRecord , , acNext Dim rsClone As Recordset Dim intValue As Integer Set rsClone = Me.RecordsetClone With rsClone .Bookmark = Me.Bookmark .MovePrevious intValue = rsClone.Fields("D") End With Me.D = Me.A + Me.B + Me.C + intValue...