When I built the form, I recall a lot of cut-n-paste, then going back and changing the formula in each one.
As for your new question, I do not remember ever seeing that.
A little more detail on version setup and the specific problem would be helpful in diagnosing, and perhaps someone else here will have more experience with this problem.
Gary
At 11:43 AM 7/31/2014, you wrote:
Gary,
That does help. It will take some time to build the form but I will get started.
Also, one more question. When the database does a compact and repair I seem to loose primary keys and relationships in about 5 tables, always the same tables. I have to go in and fix them and then it all works well again. Any Idea why that would happen?
Bill
MN
From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, July 30, 2014 1:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] corrupted database
I had a similar issue on a multi-table database, where I need to verify
before/after maintenance or backup work.
I built a form where I have a field for each table I want to review.
Inside that field, I built an event using this code:
=DCount("[indexfield]","[tablename]")
An index field is used as there is always a value in every row. I believe
that
it only counts rows where that field is occupied.
I monitor about 40 different tables this way, and print out the form before
and
after. I added a field that di
--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com __._,_.___
Posted by: "Gary D. Schwartz" <gary.schwartz@pobox.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Yahoo Groups
New Feature! Add Polls to Conversations
You can now include a poll directly within your message. Members can view, vote and add poll options either via email or on the group. Try it today!
.
__,_._,___
Tidak ada komentar:
Posting Komentar