Shared data in forms

[Guest]

Hi,

I am a relative beginner with Access and I am building what I think should
be a very simple shared database. The database is going to be a job tracking
tool spanning 3 teams, where each team is responsible for entering specific
data for their piece of the job.

I have built unique forms for each team where certain fileds are duplicated
but disabled on two of the three forms. Where I am having the struggle is
that the records generated by team 1 don't dispaly in the other teams forms.
Only one record displays. I have tried refresh and is it re-query? but it
doesn't change anything.

Sorry for the length, but I didn't know how to ask the question and
hopefully it makes sense to someone. Any assistance would be appreciated.

 

[Guest]

Hi David,

I think I'll need some more information to make sure I understand exactly
what you're trying to achieve.

Firstly, when you say "the records generated by team 1 don't dispaly in the
other teams forms" do you mean that:

(1) the records ARE displaying and you don't want them to; or
(2) the records AREN'T displaying but you do want them to?

I assume you have one table representing 'the job', with a key field (maybe
an autonumber), and that different teams are responsible for entering data
into those fields on the table that represent their part of the work - so by
showing (but disabling) certain fields everyone can see how the whole project
is going, but can only change the data that relates to their team's
responsibilities.

When you say you only ever see one record displayed, my guess is that it's
the first record on the table. So it seems to me that maybe you have no
method of moving to a new record (by default, when you open any Access form,
it will always show the first record in the table or query that - so to speak
- lies 'behind' the form).

The simplest way of providing a way of getting from record to record is by
going to the properties window for the form, going to the 'Format' page, and
making sure that the 'Navigation Buttons' property is set to 'Yes'. Then
you'll get a set of buttons at the bottom left of the window (from the
extreme left, you'll see the word 'Record', then a button to go to the first
record, then one to go to the record before the one you're looking at, then
the number of the record you're looking at [note: if it says - for example -
record '1' then it's the first record, not necessarily record number 1]; the
next button is 'go to next record', then 'go to last record', then 'go to new
record' and finally the number of records.

Once you have a large number of records you may want to add a search form so
you don't have to scroll through them all to find the one you want. Let's
leave that for later.

Does this help?

Good luck!