Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2008

Tip: Looking for answers? Try searching our database.

Is there any way to make global update on forms and report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frank Situmorang - 31 Jul 2008 03:24 GMT
Hello,

I have finished developping the church membership database for our
denomination SDA church. From the one I made I have to adapt to each
individual church the name of the church manually.

My question is instead of goid to each report to edit the caption and label
of the reports and forms, is there any quick way to revise the name of the
church on the capiton and heder label of the reports and Forms?.

Do you think we need a table for this and can direct it to any forms &
reports for it;s caption and header?

Thanks in advance for any help.

Frank,
Jakarta, Indonesia
Signature

H. Frank Situmorang

Larry Linson - 31 Jul 2008 05:09 GMT
It is common for people who are using the same application, or the same
front end Database, for multiple organizations, to include a Table with
"customization" information.  The information from that Table can be read
and either saved in Public Variables, as Properties of a Class, or in a Form
that has its Visible property set to No. Or, the data can be retrieved where
needed using the DLookup domain aggregate function.

Or, you could obtain one of the third-party Find and Replace applicatons
which will make a global change... you essentially tell it "wherever you
find 'Nazareth Church' replace it with 'Abundant Life Church'" and it
(giving you the option to skip the replace in each instance, unless you
direct otherwise) will change every occurrence.  One that I have used and
been pleased with for Access 2003 is "Find & Replace" shareware from
http://www.rickworld.com; another I've used and liked in the past, but that
won't work with Access 2003 (you have to have an earlier version of Access
installe) is "Speed Ferret" commercial software from
http://www.moshannon.com.

As you can guess, those can be very useful for other purposes, too, when you
are developing.

Larry Linson
Microsoft Office Access MVP

> Hello,
>
[quoted text clipped - 14 lines]
> Frank,
> Jakarta, Indonesia
Frank Situmorang - 31 Jul 2008 05:52 GMT
Thanks Larry, this is good info for me.

Rgrds,

Signature

H. Frank Situmorang

> It is common for people who are using the same application, or the same
> front end Database, for multiple organizations, to include a Table with
[quoted text clipped - 38 lines]
> > Frank,
> > Jakarta, Indonesia
Frank Situmorang - 31 Jul 2008 06:28 GMT
Larry:

Can we use it if we will only replace the caption and label/header in Form
and report?. I am affraid that it will replace the words in VBA will
jeopardize everything.

Thanks for your further help.

Signature

H. Frank Situmorang

> It is common for people who are using the same application, or the same
> front end Database, for multiple organizations, to include a Table with
[quoted text clipped - 38 lines]
> > Frank,
> > Jakarta, Indonesia
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.