Access 2007 Previous Record

[HotRodSue]

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[MikeJohnB]

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.

 

[HotRodSue]

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[MikeJohnB]

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[HotRodSue]

In looking at your first post again, I now see that the EndMeter Control will
NOT always be the greater value. The fuel pump meter runs from 0 thru 100
gallons, it rolls over after 100.

We can have a Start Meter value be 80, and when 30 gallons are pumped, the
EndMeter would read 10.

Any other ideas would be appreciated?

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[MikeJohnB]

Try DLast instead of DMax, see how you get on. I didn't recommed Dlast
because it doesn't return the maximum value but the last record.

However, in your case it appears that is what you require, What I was
thinking when suggesting the method, I was thiking this was a Milage
indication not a Fuel Meter Readings?

Hope this continues to help.

Kindest regards

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

In looking at your first post again, I now see that the EndMeter Control will
NOT always be the greater value. The fuel pump meter runs from 0 thru 100
gallons, it rolls over after 100.

We can have a Start Meter value be 80, and when 30 gallons are pumped, the
EndMeter would read 10.

Any other ideas would be appreciated?

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.


:

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[HotRodSue]

DLast did it. You know, it's great to have folks with experience sharing
their knowledge here. I make it a point to use tutorials and help, being
self taught on most applications. It sure is nice to have a helping hand.
The time I've invested has been great, and your help has made an
immeasureable difference. Thank You.

Kind Regards.

Try DLast instead of DMax, see how you get on. I didn't recommed Dlast
because it doesn't return the maximum value but the last record.

However, in your case it appears that is what you require, What I was
thinking when suggesting the method, I was thiking this was a Milage
indication not a Fuel Meter Readings?

Hope this continues to help.

Kindest regards

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

In looking at your first post again, I now see that the EndMeter Control will
NOT always be the greater value. The fuel pump meter runs from 0 thru 100
gallons, it rolls over after 100.

We can have a Start Meter value be 80, and when 30 gallons are pumped, the
EndMeter would read 10.

Any other ideas would be appreciated?

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.


:

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[MikeJohnB]

No Problem Sue, like you I'm self taught ove a few years but I get pleasure
in passing on help when i can providing I think I know something about the
subject. Sometimes I fall over though and end up with the proverbal egg on
face. I have written quite a few databases and also Excell applications where
everything was performed in visual basic, no calcs presnt on the spread sheet
at all, fully protected and fully user friendly. Access VB is different but
like you, I'm getting there. I have something like 350 posts of which I would
think about 40 are my questions to the News Groups, the rest on responses.

Glad to be of some help.

Merry Christmas if I can say that these days.

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

DLast did it. You know, it's great to have folks with experience sharing
their knowledge here. I make it a point to use tutorials and help, being
self taught on most applications. It sure is nice to have a helping hand.
The time I've invested has been great, and your help has made an
immeasureable difference. Thank You.

Kind Regards.

Try DLast instead of DMax, see how you get on. I didn't recommed Dlast
because it doesn't return the maximum value but the last record.

However, in your case it appears that is what you require, What I was
thinking when suggesting the method, I was thiking this was a Milage
indication not a Fuel Meter Readings?

Hope this continues to help.

Kindest regards

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

In looking at your first post again, I now see that the EndMeter Control will
NOT always be the greater value. The fuel pump meter runs from 0 thru 100
gallons, it rolls over after 100.

We can have a Start Meter value be 80, and when 30 gallons are pumped, the
EndMeter would read 10.

Any other ideas would be appreciated?

:

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.


:

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.

 

[HotRodSue]

Merry Christmas to you too.

Thanks for sharing your background experience with me. It sure is a great
sense of accomplishment when you get something after working so hard. Sure
do understand how you feel good passing on help to others. Had to laugh
about the proverbal egg on face, we all do that, right? Hope I find you next
time I run into a road block. It was nice to have the discussion until I got
it right.

Hope you have a safe and happy holiday.

No Problem Sue, like you I'm self taught ove a few years but I get pleasure
in passing on help when i can providing I think I know something about the
subject. Sometimes I fall over though and end up with the proverbal egg on
face. I have written quite a few databases and also Excell applications where
everything was performed in visual basic, no calcs presnt on the spread sheet
at all, fully protected and fully user friendly. Access VB is different but
like you, I'm getting there. I have something like 350 posts of which I would
think about 40 are my questions to the News Groups, the rest on responses.

Glad to be of some help.

Merry Christmas if I can say that these days.

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

DLast did it. You know, it's great to have folks with experience sharing
their knowledge here. I make it a point to use tutorials and help, being
self taught on most applications. It sure is nice to have a helping hand.
The time I've invested has been great, and your help has made an
immeasureable difference. Thank You.

Kind Regards.

Try DLast instead of DMax, see how you get on. I didn't recommed Dlast
because it doesn't return the maximum value but the last record.

However, in your case it appears that is what you require, What I was
thinking when suggesting the method, I was thiking this was a Milage
indication not a Fuel Meter Readings?

Hope this continues to help.

Kindest regards

Mike
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

In looking at your first post again, I now see that the EndMeter Control will
NOT always be the greater value. The fuel pump meter runs from 0 thru 100
gallons, it rolls over after 100.

We can have a Start Meter value be 80, and when 30 gallons are pumped, the
EndMeter would read 10.

Any other ideas would be appreciated?

:

As previous post, you have only set the default value of StartMeter, if you
wish to put some other value in the Control, just type it in the Control
StartMeter, it will take the new value and record that value in your table.

Hope this helps?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, it worked using the default value method, I can’t thank you enough. The
StartMeter did indeed by default show the previous record EndMeter.

Is there be an option to input an alternate value in StartMeter if needed?
If so, will it still create the correct StartMeter value in the next record?

In theory the StartMeter should always be the previous record EndMeter.
However, there’s a possibility that the handwritten log could vary and would
require an alternate value.

Again, thank you, thank you, thank you.


:

One of many ways to do what you want.

Set the default value of the Control StartMeter to the max value of Endmeter

Select properties of StartMeter

In the Row Default Value type

=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

When you navigate to a new record, the start value default will be the
EndMeter Value. This has not actually set the value but this allows you to
make adjustments for errors to the EndMeter Value.

To Accept the default value, you just have to press return in the control
when it has focus. Or Change the value as you like.

Another way is to have an unbound text box on your form with the same code
as the control source for the Text Box
=DMAX("[EndMeter]","[TheNameOfYourTableHere]")

you can then set Me.StartMeter = Me.EndMeter.Value in the on got focus event
of the StartMeter Control

I would opt for the default value though.

Only thing to note, is the fact that this assumes that the last entry in
EndMeter Control will always be the greater value. (Hence DMAX)

You can also use a query to do the same job.

I Hope this helps?

Does this answer your question???

Kindest Regards

Mike B

PS you say field, the above relates to Controls on a form, you cannot
perform calcs on fields in tables.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

I'm new to Access 2007 and have completed some tutorials. I'm creating a
database to track fuel useage.

I have found info on using field in previous or next record - using the same
field.

Question: I need to use Value from Field in Previous Record, and Insert in
DIFFERENT Field in NEW Record.

What I have now:

StartMeter
EndMeter
Total Gallons

What I'd like is the EndMeter reading to be the StartMeter reading of the
next record.

So I could possibly have:

PreviousEnd
StartMeter
EndMeter
Total Gallons

It seems like I'm close, I just can't figure out how to use info from
previous record in a new (different) field in the next record.

Many thanks.