By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

Form??

P: n/a
Hello, I created a form with 3 fields. The objective is to input all
my CD Albums that I have. The 3 fields are, Artist Name; Album Title;
Song Title;...

What I want to avoid is inputing the name of the artist and the album
title more than once. Example: I open the form type the artist name
then the album title, the first song, then go to the next record, and
the artist name and album title are already there, so that I would
only worry about typing in the names of the songs and not re-typing
the artist name and album title. Then when I'm done with that album,
close the form, re-open it and all the fieds would be blank, but once
I type the artist name and album title of a different CD, the process
will repeat itself, and I would only worry about inputing each song.

Thanks for taking the time to help me.

Mike
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
One way would be to create two global variables and assign the value
of each field to the variable on the Lost Focus event, then have a New
Record button that assigns the value of the variables to the fields,
or you could write the values to a table.
Patrick

On 15 Oct 2003 09:50:18 -0700, mi************@aig.com (Mike) wrote:
Hello, I created a form with 3 fields. The objective is to input all
my CD Albums that I have. The 3 fields are, Artist Name; Album Title;
Song Title;...

What I want to avoid is inputing the name of the artist and the album
title more than once. Example: I open the form type the artist name
then the album title, the first song, then go to the next record, and
the artist name and album title are already there, so that I would
only worry about typing in the names of the songs and not re-typing
the artist name and album title. Then when I'm done with that album,
close the form, re-open it and all the fieds would be blank, but once
I type the artist name and album title of a different CD, the process
will repeat itself, and I would only worry about inputing each song.

Thanks for taking the time to help me.

Mike


Nov 12 '05 #2

P: n/a
mi************@aig.com (Mike) wrote in
news:8d**************************@posting.google.c om:
Hello, I created a form with 3 fields. The objective is to
input all my CD Albums that I have. The 3 fields are, Artist
Name; Album Title; Song Title;...

What I want to avoid is inputing the name of the artist and
the album title more than once. Example: I open the form type
the artist name then the album title, the first song, then go
to the next record, and the artist name and album title are
already there, so that I would only worry about typing in the
names of the songs and not re-typing the artist name and album
title. Then when I'm done with that album, close the form,
re-open it and all the fieds would be blank, but once I type
the artist name and album title of a different CD, the process
will repeat itself, and I would only worry about inputing each
song.

Thanks for taking the time to help me.

Mike


Mike,

Access has some very simple methods of doing what you propose.
However, Access is a relational database system and you need to set
it up properly to do that.

First I assume that your form is based on a single table. You need
to split it out to two separate tables.

The first table, Albums has the following structure:
AlbumID , type autonumber
AlbumName, text
ArtistName, text.

The second table, Songs has two fields
AlbumID, number (long Integer)
SongTitle, text

Once you have built your tables, you set a relationship between
them. The relationship in your case is between Albums.REcordID and
Songs.RecordID, type 1 to many.
You set relationships from Tools->Relationships,

Now you can modify your form to show an album. Remove the song
textbox from the form, and replace it with a subform based on
Songs.

To use the form, navigate to the NewRow Add the Album title and
Performer, then start adding songs.

Access will do the maintenance for you.

Even better, if you notice after entering twenty songs on an album,
you misspelled the Artist's name, you only need to change it once.

Bob Q
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.