previous data

  • Thread starter Thread starter Squibbly
  • Start date Start date
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 (')
 
thats for access 97 and it wont open saying that i dont have permission for
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 (')
Click to expand...
 
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


Squibbly said:
thats for access 97 and it wont open saying that i dont have permission
for converting or enabling the databases
Click to expand...
 
yea but i want it done automatically, and the file is still not opening up
 
Squibbly,
Sorry for the delay, but my original response "bounced" for some
reason...
yea but i want it done automatically
Click to expand...
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
 
i was talking about the .mdb files that are on your website sorry about the
confusion
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Default values from previous records in datagrid subforms 3
Lock Previous Record Help! 1
Access Skip address field if previous field is blank 2
Record changed value of field (previous value) 5
Copying data from another record 4
Secure Erase Samsung Galaxy S7 8
Previous Record 1

Back
Top