Forcing names of Queries

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

I have a multi-user database where I would like any
queries created by a specific person to be named with
that persons initials in the begining. What I would like
to do is have the name be

KMF - myquery

where "myquery" can be anything they choose, but the
initials are automatic.

I have the database set up so that the act of making a
new query is done through a button that runs the code

DoCmd.RunCommand acCmdNewObjectQuery

Does anyone know a way to force this naming convention?

I'm not adverse to changing the way I start a new query.

Thanks for the help.

Katrina
 
An addition to my previous post...

Can this be accomplished through a macro like auto keys?

For instance, I would be happy enough if I could make a
pop-up message for everytime some one saved something new
that said "Please be sure to save this with you initials
in the beginning"

I would, however be happier, if it were forced... i.e.
instead of letting them choose the name have a pop-up
that asks for thier initials and a pop-up that asks a
title, and then something that saves the name as

initials & " - " & title

Hopefully this will help in answering my question

Thanks, Katrina
 
Back
Top