chuck gregory
Last Activity: Jul 30 '09, 08:02 PM
Joined: Dec 31 '06
Location:
-
yup! It only took two hours to figure it out. there must be an easier way... -
Never mind; I found the problem... Tonight I go to bed smarter than when I woke up............. ............... ..Leave a comment:
-
re-opening form does not produce previously entered data
I'm using the 2002 (10.6771.6845) SP3 Access program.
I have a form that will not show previously entered data. It has about 45 fields. I will call it the "parent" form. The "parent" form was at one time linked to another form, but I deleted the link since it is not needed.
To troubleshoot it, I saved it with a new name, the "child" form. Then I created a table with two fields. I entered... -
Thanks for helping clear up the no-print problem, ChipR. As for the multiplicity of records, I'm going to try re-establish the link between the tables, and if that doesn't work, find out about doing a union.Leave a comment:
-
form detail will not print
I am using a microsoft access 2002 (10.6771.6845) SP3 program and recently linked new table to one I have been using a long time, with a one (new table) to many (old table) relationship, which worked fine when I created 22 forms linked to the original table and form.
However, I wanted to have the pirmary key numbers posted in both tables at the same time. So, I opened the original table's query, linked the two tables in it, and... -
Thanks, NeoPa. May it be a long time before you hear from me again.....Leave a comment:
-
IT WORKS!!
There's the "1" at the Table A end of the line and the infinity sign at the Table B end. It's like walking into the living room on Christmas morning! Tonight I go to sleep smarter than when I woke up. And the data is all there. Thank you!
Now, can you steer me to someplace that will explain SQL to a caveman? After I've messed around with that for a few months, I'm sure you'll hear from me again....Leave a comment:
-
Ah! Then I did it right the first time by creating the relationship before entering data and then screwed it up by experimenting with the relationship afterward! THAT I can wrap my mind around.
So now, it seems, to restore the proper relationship between the tables, I could:
1. Delete the data in tables A & B, and delete the relationship.
2. Copy the tables.
...Leave a comment:
-
NeoPa,
I wnet into Relationships, deleted the existing one, then re-recreated it and got that box. When I tried to "enforce relational integrity, I got a message saying it couldn't be done, "for example, there may be records relating to an employee in the related table, but no record for the employee in the primary table."
Right now, the only link between them occurs when data is entered in two adjoining...Leave a comment:
-
NeoPa, when you say you "added" the 1-to-1 link, is that when you drag the field from Table A to Table B? And does something special have to be done to get cascading updates and deletes?
Next, where did these lists come from? I've never seen anything printed out like this in my work:
Table Name=[tblTestA]
Table Name=[tbl...Code:[I]Field Type IndexInfo[/I] AID AutoNumber PK AData String
Leave a comment:
-
Woosh! A lot of stuff to digest, there! Thanks for going through all the trouble. I won't be able to touch it until Monday. Have a good weekend!
cgLeave a comment:
-
NeoPa, since you said "the wizard allows for that," and I didn't use the wizard, rather than risk expecting the wizard to take care of something it had nothing to do with, I have now created in the second table a long integer field called AutoID link, to which I dragged the AutoID field from the first table.
I don't use it for any input, just as the FK field for the first table.
It seems to work. I looked...Leave a comment:
-
Ah! At last, I think I can provide you with a comprehensible answer:
the primary key in both tables is the AutoID. When I dragged the AutoID in the first table into the long integer field in the second table, I made that long integer field the Foreign key. Or am I wrong? It sounds as though I am, when you talk about dragging in the other direction.
The bit about limiting data in that long integer field is this--...Leave a comment:
-
NeoPa, what I understood from that was this: You link an autoID field in one table to another long integer field in the other table, and it should work. Only the outa id field has to be the primary key. It doesn't look as though the long integer field even has to have a number in it.
Fish, I knew nothing about Access when aa acquaintance asked me if it might be useful in streamlining some paper flow. Everything I know about it I...Leave a comment:
-
So, if I understand this correctly, here';s what I should do:
1. Go into relationships.
2. Delete the auto-id to auto-id link.
3. Drag the auto-id link in the "page 1" (first document half) table to the ID number (which is a long integer) field in "page 2",
OR drag the auto-link id in "page 2" table into the ID field in "page 1, even though the ID field in "page...Leave a comment:
-
Oooh! Thanks for the warning! I'm more than ready to do it a different way.
How should I do it instead?
chuck gregoryLeave a comment:
-
NeoPa!!!
Eureka!
I figured out a fix, although it probably doesn't mean jack as far as understanding relatiionships!
Your comment about the auotnumbers needing to match caused me to look at the autonumbers in the two tables-- and they didn't match. When I generated a few entries to bring them up to par, suddenly all the data appeared in all the previously entered forms.
So I fixed it...Leave a comment:
-
Well, NeoPa, I am a slow learner, but you're getting through to me!
How do I create a field in the second table which will match the Auto Number in the first table? I don't see how it can be done, aside from reading that number in the first table, and I don't know that first number could be read.
chuck gregoryLeave a comment:
-
Hello, NeoPa,
The form is designed as 7 1/2" x 20" in Access. When it gets printed, it comes out of the printer as a piece of paper with printing on both sides. Table I is the top half of the form (the front of the page), and Table II is the bottom half (the back).
chuck gregoryLeave a comment:
-
Thank you, Stewart.
I have a question: If Table I is page one of my form and Table II is page two, what sort of a relationship do I need between them? In Relationships view, how would I create that relationship once the tables are displayed?
I do not do this for a living, so I do not understand how to apply the material in the How To section-- there is nothing in there that corresponds to my page one-page two situation...Leave a comment:
No activity results to display
Leave a comment: