A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

subforms and relationships getting #Name? error



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 07:31 PM posted to microsoft.public.access.gettingstarted
mholt261
external usenet poster
 
Posts: 2
Default subforms and relationships getting #Name? error

I am pretty new at access and need help! I have several forms that I need
linked together. When I put them all together using tabs I get the #Name?
error. I have checked the "record source" and it appears to be correct.
(Unless I am not understanding it correctly). I use the field "CID" as my id
number for the relationships. Any help would be greatly appreciated.
  #2  
Old April 23rd, 2010, 08:42 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default subforms and relationships getting #Name? error

On Fri, 23 Apr 2010 11:31:01 -0700, mholt261
wrote:

I am pretty new at access and need help! I have several forms that I need
linked together. When I put them all together using tabs I get the #Name?
error. I have checked the "record source" and it appears to be correct.
(Unless I am not understanding it correctly). I use the field "CID" as my id
number for the relationships. Any help would be greatly appreciated.


We cannot see your screen. You have not posted any information about your
table structures, what "CID" might be, or what you mean by "id number for the
relationships". Tabs are completely irrelevant; they just manage how controls
are laid out sharing screen space.

Your tables are fundamental. What are your Tables? What real-life Entity
(thing, person, event) does each table model? How are the tables related?

Forms are very distinctly secondary. There are no "relationships" between
forms - a Form will be linked to a Subform using master/child link fields, but
these will normally follow from the table relationships, not direct them.

More info please!
--

John W. Vinson [MVP]
  #3  
Old April 23rd, 2010, 09:57 PM posted to microsoft.public.access.gettingstarted
mholt261
external usenet poster
 
Posts: 2
Default subforms and relationships getting #Name? error

I need to keep track of individuals (name, dob, address, employment...) I
have made tables for this information. Each individual is given a unique
number (CID). Instead of using a primary key number I use the CID #. (Do I
still have to use a primary key number in a table?) There is information that
changes with each individual that I need to track, such as address,
employment. I have been told to use the unique number (CID in my case) in the
relationships to keep the information connected to the individual. I want to
enter an individual's address, employment information,etc. in a separate
table or form (as this info changes periodically) and still keep track of the
previous entries. I hope this clarifies my issues.
Thanks

"John W. Vinson" wrote:

On Fri, 23 Apr 2010 11:31:01 -0700, mholt261
wrote:

I am pretty new at access and need help! I have several forms that I need
linked together. When I put them all together using tabs I get the #Name?
error. I have checked the "record source" and it appears to be correct.
(Unless I am not understanding it correctly). I use the field "CID" as my id
number for the relationships. Any help would be greatly appreciated.


We cannot see your screen. You have not posted any information about your
table structures, what "CID" might be, or what you mean by "id number for the
relationships". Tabs are completely irrelevant; they just manage how controls
are laid out sharing screen space.

Your tables are fundamental. What are your Tables? What real-life Entity
(thing, person, event) does each table model? How are the tables related?

Forms are very distinctly secondary. There are no "relationships" between
forms - a Form will be linked to a Subform using master/child link fields, but
these will normally follow from the table relationships, not direct them.

More info please!
--

John W. Vinson [MVP]
.

  #4  
Old April 23rd, 2010, 11:24 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default subforms and relationships getting #Name? error

On Fri, 23 Apr 2010 13:57:01 -0700, mholt261
wrote:

I need to keep track of individuals (name, dob, address, employment...) I
have made tables for this information. Each individual is given a unique
number (CID). Instead of using a primary key number I use the CID #. (Do I
still have to use a primary key number in a table?)


Sounds like the CID *is* (or should be) the primary key. Microsoft tries to
suggest that "Primary Key" is synonymous with "Autonumber" but that is not the
case; a primary key must be unique within the table, and should be stable and
short, but it can be a Number, Text, even a date. I'm guessing that yours
would be in a Text field.

There is information that
changes with each individual that I need to track, such as address,
employment. I have been told to use the unique number (CID in my case) in the
relationships to keep the information connected to the individual. I want to
enter an individual's address, employment information,etc. in a separate
table or form (as this info changes periodically) and still keep track of the
previous entries. I hope this clarifies my issues.
Thanks


In that case the CID would be a *foreign key* in these related tables (not the
primary key). Your table of (say) addresses would have an AddressID primary
key; this could very well be an autonumber. It would also have a CID field of
the same datatype and size as the CID of the table of individuals, to be used
as a foreign key.

For data entry you could use a form based on the table of individuals, with
one or more Subforms based on the related tables, using CID as the
Master/Child Link Field.

See the resources at:

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.