reuse data create new entry

[Ruth]

Hi there

I am trying to set up some forms to enter data and I don't know the best way
to set it up. There are several vessel that will be entering data at least
once a day. The trip may go on for several days. I want to avoid having
them reenter data that they inputed about the trip, but I don't want to loose
the data they entered, because some things may change, but we want to keep
the information already entered. So when they enter a trip number I want the
data that they previous inputted come up, but they can change the data and it
will not over-ride the data previously inputted and have it saved as a
seperate entry with the same trip number.
How is this possible?

Also, in the end I want to be able to pull up all the data with the same
trip number.

 

[Amy Blankenship]

Hi there

I am trying to set up some forms to enter data and I don't know the best
way
to set it up. There are several vessel that will be entering data at
least
once a day. The trip may go on for several days. I want to avoid having
them reenter data that they inputed about the trip, but I don't want to
loose
the data they entered, because some things may change, but we want to keep
the information already entered. So when they enter a trip number I want
the
data that they previous inputted come up, but they can change the data and
it
will not over-ride the data previously inputted and have it saved as a
seperate entry with the same trip number.
How is this possible?

Set the default values for the fields in the new record based on the last
record.

 

[Ruth]

I don't know so much about Access....

What are the steps to do this?

Do they have to be on different forms - one for the original input and
another one to update?

 

[Amy Blankenship]

I don't know so much about Access....

What are the steps to do this?

Do they have to be on different forms - one for the original input and
another one to update?

Open the form in design view and open its property sheet. Click the
"Events" tab and find the "Current" event. Click the white box next to it,
and you should see the words [Event procedure] below it. Click them, then
click the ... button next to it.

You should find yourself in the code window in a new Sub that Access has
made for you. Now, type in:

Me.Control1.DefaultValue = Me.Control1.Value
Me.Control2.DefaultValue = Me.Control2.value

etc.

Use the actual names of your controls rather than Control1 and Control2.

HTH;

Amy

 

[Ruth]

I can't get this to work. I am using the Trip number field as the control--
but it isn't pulling up information for the trip, and it is overriding
information when I try to save it rather than creating a new entry.

I was also thinking that the unique identifier would be the trip number and
the date and time of the entry which is another field, that way when they
pull it up, they get the most recent entry to modify. Could drop down boxes
be created to pull the information up-- first by trip then by date and time?
--
Thank-you!
Ruth

I don't know so much about Access....

What are the steps to do this?

Do they have to be on different forms - one for the original input and
another one to update?

Open the form in design view and open its property sheet. Click the
"Events" tab and find the "Current" event. Click the white box next to it,
and you should see the words [Event procedure] below it. Click them, then
click the ... button next to it.

You should find yourself in the code window in a new Sub that Access has
made for you. Now, type in:

Me.Control1.DefaultValue = Me.Control1.Value
Me.Control2.DefaultValue = Me.Control2.value

etc.

Use the actual names of your controls rather than Control1 and Control2.

HTH;

Amy

 

[Amy Blankenship]

I can't get this to work. I am using the Trip number field as the
control--
but it isn't pulling up information for the trip, and it is overriding
information when I try to save it rather than creating a new entry.

You need to actually _create_ a new record ( i.e. hit the right arrow
button in the form or the little asterisk button). If you type over the
information in the current record, _of course_ you will be editing the
record you're in.

I was also thinking that the unique identifier would be the trip number
and
the date and time of the entry which is another field, that way when they
pull it up, they get the most recent entry to modify. Could drop down
boxes
be created to pull the information up-- first by trip then by date and
time?

I'd suggest you do a Google search on "relational database normalization".
Better yet, if you can find a local continuing ed class on Access, you
should see if you can take it.

HTH;

Amy