Question Pop up for query a2010 (1 Viewer)

ypma

Registered User.
Local time
Today, 06:15
Joined
Apr 13, 2012
Messages
643
Having taken the plunge and obtain a copy of accees 2010 , I successuly transfered a small database from ac2003 to ac2010 . The problme i am struggling with, is the fact that a query opened from a form using a command button opens under the form that called it . In ac2003 the query would always appear on top.
My options appear to be limited to creating a form for my query
or even a report .
The following code did not work either .

# Dim stDocName As String
stDocName = "MarcDailyBooked"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Call DoCmd.SelectObject(ObjectType:=acQuery, _
ObjectName:="MarcDailyBooked", _
InDatabaseWindow:=False)#
Any suggestions would be appreciated
Regards Ypma
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 22:15
Joined
Aug 30, 2003
Messages
36,125
Personally I never expose queries or tables to the user (and most developers don't). I'd create a form or report, as appropriate. If you want to keep the query, I'd guess that the form was opened with acDialog or has its Popup and Modal properties set. You could hide it while the query is open, but of course you'd have trouble knowing when the query was closed, because there are no events associated with queries.
 

ypma

Registered User.
Local time
Today, 06:15
Joined
Apr 13, 2012
Messages
643
Pbaldy Thanks for getting back to me so quick. You are correct i am using pop up for the form concerned . I was resolved to, creating a form but could not help wondering why ac2003 appeared on top and ac2010 .

Regards Bob
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 22:15
Joined
Aug 30, 2003
Messages
36,125
Who knows Bob. Sometimes I think they change things just for the heck of it.
 

Users who are viewing this thread

Top Bottom