Search results

Hi You can have 2 methods to keep archive info: 1) keep achive in a table within your database or 2) in other database table linked to your database. How: 1)Create query "ArchiveYear" which contain all fields for archivation(current year) 2) Create table "ArchiveAll" with all the same fields...

I have deal with SQL Server tables linked to MS Access using DSN and ODBC driver(SQL Server). When I manually link tables in Access ,I never define PK because they are defined already in SQL Server. Prompt could be result of : 1) table does not have PK 2) when link view Hope this help you. Igor.

Lets pretend that your combobox has name cboSettingID which contains obviously your SettingID field value. Private Sub cboSettingID_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SettingID] = " & Str(Me![cboSettingID]) Me.Bookmark = rs.Bookmark End Sub