The following excel code opens an access query. but, myQry has criteria: select * from mytable where cily like [enter part of city name] & "*"
I have to wait for the input criteria to be entered, before the control is returned to excel.
Is there any way to prevent that, without changing myQry? (One way is to use Shell, but I prefer using automation.)
Dim oApp As Object
If oApp Is Nothing Then Call openoApp
lPath = "S:\.....mdb"
If oApp Is Nothing Then
Set oApp = CreateObject("Access.Application")
oApp.Visible = True