MS Access 97; tab between open queries

[MrsMope]

Hello,
I am in MS Access 97 and I have three simple query windows open. I want to be able to ALT + TAB to each query, but that doesn't work. Any idea how to get that same functionality in 97? Thanks,

 

[Melagan]

I'm do not have Access 97 to test with at the moment, but the following code is what I use to set this open you're talking about in Access 2003 (I doubt it'll work in Access 97 / VBA5)
In startup form:

Private Sub Form_Load()
  Application.SetOption "ShowWindowsInTaskbar", False
End Sub

Ofcourse you would want to set the argument to True instead of False.



~Melagan
______
"It's never too late to become what you might have been.

 

[lameid]

I don't think that will work either... The option for showing windows in the taskbar was added after 97 and I don't know which version.

However, your open queries can be found on the windows menu.


You might also consider using subforms in datasheet view on an unboud mainform. Just put each sub form on its on page/tab of a tab control. Then you could easily click between them.

I wasn't sure if you were trying to navigate or provide a user experience. I hope one of those ideas is more or less what you are looking for.