Is it possible to open the query design app right from a switchboard?

K

Ken

I'm trying to do this.

I know about adding codes to the switchboard code, but I have no clue
how to apply this to getting the query desing app to open. I know you
can click on on of two buttons (Database wibdow or the one that has
"New Object: Query".

Thanks in advance for any ideas.

Ken Halpern
Margate FL
 
J

John W. Vinson

I know about adding codes to the switchboard code, but I have no clue
how to apply this to getting the query desing app to open. I know you
can click on on of two buttons (Database wibdow or the one that has
"New Object: Query".
Click to expand...

Why?

Just for your convenience as a developer? Or will you be (unwisely, IMHO)
throwing the query design window open to end users? What are you trying to
accomplish?


John W. Vinson [MVP]
 
K

Ken

Why?

Just for your convenience as a developer? Or will you be (unwisely, IMHO)
throwing the query design window open to end users? What are you trying to
accomplish?

John W. Vinson [MVP]
Click to expand...

John:

It's for the client. It's a two person shop with moderate Access
experience creating queries.

I don't disagree with you sentiments, but they've asked for this
function and they're paying for a application that will do what they
want. I've explained the down side, and they know that it'll cost them
for me to fix it if they foul it up.

Ken
 
J

John W. Vinson

John:

It's for the client. It's a two person shop with moderate Access
experience creating queries.

I don't disagree with you sentiments, but they've asked for this
function and they're paying for a application that will do what they
want. I've explained the down side, and they know that it'll cost them
for me to fix it if they foul it up.

Ken
Click to expand...

well... the closest I've found so far is

docmd.RunCommand acCmdNewObjectQuery

There may be some other acCmd constants (in the huge heap of them) that I
haven't found that would put you into a more specific window.

John W. Vinson [MVP]
 
K

Ken

well... the closest I've found so far is

docmd.RunCommand acCmdNewObjectQuery

There may be some other acCmd constants (in the huge heap of them) that I
haven't found that would put you into a more specific window.

John W. Vinson [MVP]
Click to expand...

I will try that and let you know the results.

TIA.

Ken
 
M

missinglinq via AccessMonster.com

"they know that it'll cost them for me to fix it if they foul it up."

Sounds like what they call, in the "work from home" ads, recurring income!
Queries being one of the most complicated parts of an Access database, you
have to wonder why "two person... with moderate Access experience creating
queries" have someone else developing the app for them!

Good Luck! You're probably going to need it!
 
J

John W. Vinson

Sounds like what they call, in the "work from home" ads, recurring income!
Queries being one of the most complicated parts of an Access database, you
have to wonder why "two person... with moderate Access experience creating
queries" have someone else developing the app for them!
Click to expand...

Perhaps the same logic that persuades some people to serve as their own
attorneys in court cases... and you know what they say about them!

John W. Vinson [MVP]
 
Top