Re: Feed values from a text box to a table
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/24/05
- Next message: WiFiMAX: "Linked Child Fields"
- Previous message: tina: "Re: Check for previous entry."
- In reply to: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Next in thread: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Reply: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 Jan 2005 17:39:09 -0700
On Sun, 23 Jan 2005 23:20:19 GMT, "Dan Hovden via AccessMonster.com"
<forum@AccessMonster.com> wrote:
>First of all. I've learned more about access the last 24h than at the one-week course I took.
<g> That's not uncommon. Working on a real-life problem beats any
course hands down, every time!
>And second....When you're talking about "resolver." Do you mean relationships between different columns in different tables?? In that case I have made direct relationships between the "HealthIssueIDs" from the AnimalCondition- and the HealthIssues tables, and the "AnimalIDs" from the AnimalCondition- and the Animals tables.
A Many to Many relationship requires THREE tables: in your case,
Recordings, Genres, and a table to list which recordings are in which
genre. This third table is often called a "Resolver" table. It is
related one-to-many to the Recordings table, and also related
one-to-many to the Genres table.
>Do these relationships imply that whatever is fed into one column also is fed into the relationship-column?
No, certainly not!
You add a new record to the resolver table to establish a
relationship. For instance, if you have a recording of Vivaldi's
Concerto for Two Flutes, you would create a record in the resolver
table with that recording's ID and "Baroque", and then a second record
for the same ID and "Chamber Music".
>And I assume that all the different HealthIssues (or in my case Genres) are to be listed in the HealthIssueID as the only column. I used this column as the row source for the lstHealthIssues listbox.
You'll have a table of Genres with each genre listed once. The
resolver table will have each genre repeated as many times as you have
recordings in that genre. That is, if you have 37 chamber music
recordings, there will be 37 records (all with different
RecordingID's) in the table.
>Here comes the problem. When I hit the button I get this error message:
>"Microsoft Access. Error 2465 in cmdProcess_Click: Microsoft Access can't find the field 'lstHealthIssues' referred to in your expression.
>
>I don't understand this. The listbox is most definitely named lstHealthIssues and is in the same form as the button.
Then I don't understand it either! You're not using a Subform are you?
The code assumes that there is a Listbox control with a Name property
of lstHealthIssues; doublecheck that this listbox in fact has this
Name (not its caption or its control source, but the name of the
control).
John W. Vinson[MVP]
- Next message: WiFiMAX: "Linked Child Fields"
- Previous message: tina: "Re: Check for previous entry."
- In reply to: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Next in thread: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Reply: Dan Hovden via AccessMonster.com: "Re: Feed values from a text box to a table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
