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
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