Copy database / Make changes to query/form names

[rob]

All,

I created a database for my work section that tracks employee evaluations.

I customized all of my queries/forms/reports to fit my office. The problem
I have is people outside of my section were given a demo of how it works and
want thier own copy. (excuse me a sec while I pat myself on the back ;-) )

I don't mind sharing my work, but I really don't want to spend hours
customizing the application to another office... To save time, is there a
way you can use a FIND/REPLACE option within access that will change the
name of a sub- procedure/function/query, etc to save me a TONof time?

For example, I would like to change a query named qryTraining, to
qryQuality_Assurance (along with references in my VBA). Is this possible?

BTW -- thanks to all the folks who assisted me by answering my VBA/Access
design questions. Where were you guys when I needed you back in college
(too many years ago)!

Rob

 

[Duane Hookom]

There is a sample employee evaluation database at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
Everything is fairly normalized so there would be little or no reason to
change much other than data.

 

[rob]

Thanks Duane,

My database is used to manage the entire evaluation process for 100's of
people (not individual reports).

 

[John Vinson]

All,

I created a database for my work section that tracks employee evaluations.

I customized all of my queries/forms/reports to fit my office. The problem
I have is people outside of my section were given a demo of how it works and
want thier own copy. (excuse me a sec while I pat myself on the back ;-) )

I don't mind sharing my work, but I really don't want to spend hours
customizing the application to another office... To save time, is there a
way you can use a FIND/REPLACE option within access that will change the
name of a sub- procedure/function/query, etc to save me a TONof time?

For example, I would like to change a query named qryTraining, to
qryQuality_Assurance (along with references in my VBA). Is this possible?

Ummm...

WHY?

How do qryTraining and qryQuality_Assurance differ? If only by a
criterion selecting members of one department or the other, I'd
instead just use ONE parameter query; you could have a startup form
with a combo box allowing the user to select the department (or you
could give each department a separate frontend all linked to the same
backend), and have your (single) query reference that combo box as a
criterion.

Am I misunderstanding?


To directly answer the question, there are some third-party tools to
do this:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]

 

[rob]

Ummm...

WHY?

John,

As I said, I customized it to fit the needs of my section. I created a lot
of queries (linking to menus/command buttons, etc) for the "technically
challenged" folks out there who do not like computers and have difficulty
logging in correctly twice in a row.

I was considering doing a rewrite that would allow me to make the desired
changes that I talked about, but time is a serious consideration (I don't
have much free time).

Problem is I love programming (I have a CS / Math degree), but I've never
worked in the field. My responsibilities keep me busy leaving little time
for "fun" stuff... That's why I'm looking for timesavers.

 

[tina]

does the end user *see* the names of your application's VBA procedures,
queries, etc? if not, why change them? just change inappropriate word-age
that the *user sees*, in the forms and reports.

hth

 

[mnature]

Speed Ferret
www.moshannon.com
About $200, but well worth it if you consider how long it takes to do this
stuff by hand.