Recent content by john843

Here's what I came up with: Private Sub Form_Open(Cancel As Integer) On Error Resume Next DoCmd.OpenForm "frm1" DoCmd.OpenForm "frm2" DoCmd.OpenForm "frm3" . . . DoEvents DoCmd.OpenForm "frm1" End Sub I created a startup form which is launched when the app is...

Using search term "Access – VBA – Set Focus On Specific Document Tab" I found this: Public Function MDIClient_SwitchObject(sObjectName As String, sClass As String) As Boolean On Error GoTo Error_Handler Dim oUIA As UIAutomationClient.CUIAutomation Dim oAccess...

RE: File > Options > Current Database > Application Options > Tabbed Documents + Display Document tabs We have an Access application that can have have several Document Tabs open at a time. How do I hide, set focus, reorder, and otherwise control these Document Tabs? Thinking it's a...

Outstanding! thanks for the reply. it worked perfectly.

Trying to identify duplicates in an array of numbers. I found some variations of this on the Internet - seems like a practical option. The value of i and j in line 8 is 0 and 1 respectively - this makes sense with a zero-based array. Unsure what's out of range. Public Function GetDuplicate()...