tabs, relationships and records in forms

Yeah I worked that out. Lucky I work in a lot of copy and paste so I worked
it out and worked around it. Ken do you think this is the best/easiest
option to combine these types of data as I can see the need to do this for a
number of my reports.

Cathy

"KenSheridan via AccessMonster.com" wrote:

I see that I somehow managed to put "Pending" instead of "ANP", along with an
extra quotes character in the last part of the UNION ALL operation. I hope
it didn't confuse you too much.

Ken Sheridan
Stafford, England

Cathydal wrote:
Yay, thanks Ken, after a bit of shuffling, it worked! It's all taking shape.

Cathy (Sorry I haven't responded to your email yet, have had my head down.)

C :-)

Cathy:

[quoted text clipped - 77 lines]

I wish you luck, but this Wednesday is just too soon.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200906/1

Cathy:

With the tables structured in this way its probably the only option. What
the UNION ALL operation does in essence is to produce a virtual result table
in which the 'status' data is represented as values at column positions in
rows, which is what the Information Principle requires, the data in this case
being the constants. The best solution of course would be to have one table
to start with rather than encoding the status data as the table names, but
that would mean a substantial reengineering of your current model. Whether
you want to go down that road is for you to decide. You may feel that you're
in too deep to contemplate that, and I can understand why you might think
that, but recasting the model is almost certainly not as big a task as you
might think, provided you know how to use the tools available, which
basically means writing 'action queries' along the lines of those in the demo
file I mailed to you. From your perspective as a relative novice that might
seem a big job; from mine as an old hand it doesn't look so scary.

Ken Sheridan
Stafford, England

Cathydal wrote:
Yeah I worked that out. Lucky I work in a lot of copy and paste so I worked
it out and worked around it. Ken do you think this is the best/easiest
option to combine these types of data as I can see the need to do this for a
number of my reports.

Cathy

I see that I somehow managed to put "Pending" instead of "ANP", along with an
extra quotes character in the last part of the UNION ALL operation. I hope
[quoted text clipped - 14 lines]

I wish you luck, but this Wednesday is just too soon.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200906/1

Ken, I seem to have gotten into further strife! It seems that I cannot
update or edit my data, either through the form view or using tables - well I
can add to the tables but none of the reports or queries are being modifed.
From my research it seems to be the fault of union queries.

If that is the case then this becomes a static database. A - is this
correct? and B have you any suggestions on how to resolve this?

Thanks ... desperately ... Cathy

Cathydal,

Union queries are uneditable. They are great for reports but for forms,
unless you are just displaying the data, they do not work for forms OR
trying to edit the data in the query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Cathydal" wrote in message
...
Ken, I seem to have gotten into further strife! It seems that I cannot
update or edit my data, either through the form view or using tables -
well I
can add to the tables but none of the reports or queries are being
modifed.
From my research it seems to be the fault of union queries.

If that is the case then this becomes a static database. A - is this
correct? and B have you any suggestions on how to resolve this?

Thanks ... desperately ... Cathy

Cathydal,

I am going to restate what we have been saying along. You really need to
consider 'redoing' your tables. An example of what happens when a database
is not properly normalized is what you are experiencing now. As Ken said,
we all know this may seem overwhelming but in the long run writing queries,
creating forms for data entry and creating reports will be far easier and
well worth the time.

Access is unlike Excel or Word, it's not a learn as you go program. It has
a steep learning curve which starts with understanding relational design.
Here are some resources...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Think of it like building a house. You can't go hang dry wall if the
foundation hasn't been laid; you can't hang light fixtures until the wiring
has been put in... You are attempting to hang light fixtures the foundation
is a bit wobbly! You need to go back to the tables (your foundation) and
get them stable.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Cathydal" wrote in message
...
Ken, I seem to have gotten into further strife! It seems that I cannot
update or edit my data, either through the form view or using tables -
well I
can add to the tables but none of the reports or queries are being
modifed.
From my research it seems to be the fault of union queries.

If that is the case then this becomes a static database. A - is this
correct? and B have you any suggestions on how to resolve this?

Thanks ... desperately ... Cathy

Cathy:

As you see, Gina has reinforced the advice I gave you in my reply to your
email. Coming from such a highly respected regular contributor to the
newsgroup you really would do best following her advice. Mine you can
happily treat with contempt and derision of course G.

Ken Sheridan
Stafford, England

Cathydal wrote:
Ken, I seem to have gotten into further strife! It seems that I cannot
update or edit my data, either through the form view or using tables - well I
can add to the tables but none of the reports or queries are being modifed.
From my research it seems to be the fault of union queries.

If that is the case then this becomes a static database. A - is this
correct? and B have you any suggestions on how to resolve this?

Thanks ... desperately ... Cathy

--
Message posted via http://www.accessmonster.com

Ken,

Now that I finished laughing! Thank you...

I only reinforced what you AND John have already said... sometimes, the
third time is a charm!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"KenSheridan via AccessMonster.com" u51882@uwe wrote in message
news:986e6c977b3df@uwe...
Cathy:

As you see, Gina has reinforced the advice I gave you in my reply to your
email. Coming from such a highly respected regular contributor to the
newsgroup you really would do best following her advice. Mine you can
happily treat with contempt and derision of course G.

Ken Sheridan
Stafford, England

Cathydal wrote:
Ken, I seem to have gotten into further strife! It seems that I cannot
update or edit my data, either through the form view or using tables -
well I
can add to the tables but none of the reports or queries are being
modifed.
From my research it seems to be the fault of union queries.

If that is the case then this becomes a static database. A - is this
correct? and B have you any suggestions on how to resolve this?

Thanks ... desperately ... Cathy

--
Message posted via http://www.accessmonster.com