previous data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Squibbly - 17 Dec 2005 14:31 GMT

how do i get data from a previous field

Signature

live long and prosper

Reply to this Message

Al Camp - 17 Dec 2005 14:58 GMT

From my free Access Shortcut Keys document on my website (URL below).

Insert the value from the same field in the previous record =
CTRL+APOSTROPHE (')

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> how do i get data from a previous field

Reply to this Message

Squibbly - 17 Dec 2005 18:10 GMT

thats for access 97 and it wont open saying that i dont have permission for
converting or enabling the databases

Signature

live long and prosper

> From my free Access Shortcut Keys document on my website (URL below).
>
> Insert the value from the same field in the previous record =
> CTRL+APOSTROPHE (')
>> how do i get data from a previous field

Reply to this Message

Al Camp - 18 Dec 2005 03:51 GMT

The zipped file is a Word .doc file, not an .mdb. You should be able to
open it with Word.

I think no matter what version your using, Ctrl-Apostrophe should copy
the contents from the previous records field into the new record.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> thats for access 97 and it wont open saying that i dont have permission
> for converting or enabling the databases
[quoted text clipped - 4 lines]
>> CTRL+APOSTROPHE (')
>>> how do i get data from a previous field

Reply to this Message

Squibbly - 18 Dec 2005 10:56 GMT

yea but i want it done automatically, and the file is still not opening up

Signature

live long and prosper

> The zipped file is a Word .doc file, not an .mdb. You should be able to
> open it with Word.
[quoted text clipped - 9 lines]
>>> CTRL+APOSTROPHE (')
>>>> how do i get data from a previous field

Reply to this Message

Al Camp - 20 Dec 2005 12:55 GMT

Squibbly,
Sorry for the delay, but my original response "bounced" for some
reason...

> yea but i want it done automatically

When you enter data into that particular field, use the AfterUpdate
event to set that field's Default Value to what you just entered. The
next time you create a new record, that value will be automatically
entered in your field... by default.
Later on, if you change the value, the default will also change.

As far as the Access Keys document... it's saved as an older version of
Word, so that even if you don't have the latest version of Word, it should
open. I downloaded it, unzipped it, and opend it with no problems.

Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> yea but i want it done automatically, and the file is still not opening up
>
[quoted text clipped - 11 lines]
>>>> CTRL+APOSTROPHE (')
>>>>> how do i get data from a previous field

Reply to this Message

Squibbly - 20 Dec 2005 21:38 GMT

i was talking about the .mdb files that are on your website sorry about the
confusion

Signature

live long and prosper

> Squibbly,
> Sorry for the delay, but my original response "bounced" for some
[quoted text clipped - 31 lines]
>>>>> CTRL+APOSTROPHE (')
>>>>>> how do i get data from a previous field

Reply to this Message

Al Camp - 21 Dec 2005 02:46 GMT

Squibbly,
Try opening a blank 2003 mdb, and just import the objects from my 97 .mdb
into it. That should do it...
Let me know how you make out.
If folks are having trouble, I'll add 2003 versions.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>i was talking about the .mdb files that are on your website sorry about the
>confusion
[quoted text clipped - 35 lines]
>>>>>> CTRL+APOSTROPHE (')
>>>>>>> how do i get data from a previous field

Reply to this Message