I need VBA code to find and delete duplicate records in a table. If the field named "Sales Record Number" has duplicate values (it is a text field), delete all but the first record so only one is left. The table name is "tblAllCleanedRecords".
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…