Set Focus after Navigate

"Zadok @ Port of Seattle"
wrote in message

well that is good news for you and bad for me, eh. thanks again for
the trouble shooting Dirk. guess i'm out of luck. i'm using XP,
Access 2003, Acrobat Pro 6.0.

Not necessarily. I'll bet you I can figure out a way to make it work
for you. Give me a day or so to tinker with it.

Do you really need to open your drawings in the web browser control?
Would it work to just open them in Acrobat, in an external window?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

i had it opening in an external window, the problem was that i couldnt see
both my database and the pdf. i need to see the pdf to type in the
information on the blueprint for the database.

Dirk, I've also noticed that if I ever switch to view the VIEWER form and
come back to the PROJECTS form, focus is lost, even outside of running the
code. It looks like the VIEWER/WEB BROWSER element just always grabs focus no
matter what.

"Zadok @ Port of Seattle" wrote:

i had it opening in an external window, the problem was that i couldnt see
both my database and the pdf. i need to see the pdf to type in the
information on the blueprint for the database.

"Zadok @ Port of Seattle"
wrote in message
news
Dirk, I've also noticed that if I ever switch to view the VIEWER form
and come back to the PROJECTS form, focus is lost, even outside of
running the code. It looks like the VIEWER/WEB BROWSER element just
always grabs focus no matter what.

I don't kinow what's going on there or why. But let's see if I can get
you closer to where you want to go. In the Declarations section of the
code module of the PROJECTS form, put this function declaration:

Private Declare Function Putfocus Lib "user32" _
Alias "SetFocus" (ByVal hwnd As Long) _
As Long

Then, in the code for the command button, after the lines

Me.SetFocus
Me.Sheet_No.SetFocus

add the following line:

Putfocus Me.hWnd

I can't make a meaningful test of this here, since the original code
works for me. But let me know if that makes a difference for you.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)