S
Squibbly
how do i get data from a previous field
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Camp
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 (')
Insert the value from the same field in the previous record =
CTRL+APOSTROPHE (')
S
Squibbly
thats for access 97 and it wont open saying that i dont have permission for
converting or enabling the databases
--
live long and prosper
converting or enabling the databases
--
live long and prosper
Al Camp said: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 (')
A
Al Camp
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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Squibbly said:thats for access 97 and it wont open saying that i dont have permission
for converting or enabling the databases
S
Squibbly
yea but i want it done automatically, and the file is still not opening up
A
Al Camp
Squibbly,
Sorry for the delay, but my original response "bounced" for some
reason...
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
Sorry for the delay, but my original response "bounced" for some
reason...
When you enter data into that particular field, use the AfterUpdateyea but i want it done automatically
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
S
Squibbly
i was talking about the .mdb files that are on your website sorry about the
confusion
confusion
A
Al Camp
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.
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.