Hello

I know I can undo a certain number of design changes I make, but how
do I return to the last saved state of my app? I have almost gotten
accustomed to closing Access without saving changes and then re-
opening, but i guess there must be a more elegant way....

Anyone?

"Joost" <joostsluis (AT) gmail (DOT) com> wrote

Two words: backup & restore

Get into the habit of backing up before making any changes. That way you
can't lose.

(also you'll thank yourself for doing this further down the road)

"Stuart McCall" <smccall (AT) myunrealbox (DOT) com> wrote

When I am "heavily in development", I may save my development copy of the
database several times a day. My criteria is not "X number of changes" or
"every Y minutes", but how much of what I've done since the last backup
would I be willing to re-create? After all, disk is 'cheap', so cheap that
I keep a 1TB external drive attached to my notebook PC when at my home base
(I use the notebook PC both at home and away) just for backing up "important
stuff" -- and an hour of concentrated database development work, in my mind,
qualifies as "important stuff". When I'm on the road, I carry along a USB
flash drive for the same purpose.

Amen to _that_! If you don't, one day you'll lose enough changes that
you'll be mentally kicking yourself.

On Fri, 17 Dec 2010 12:27:39 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote:

Same here. I do this by going to Windows Explorer, highlighting the
FE file, which it probably is anyhow, doing Ctrl+C and Ctrl+V and
done.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On 17 dec, 21:52, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:
Thanks for all the answers.

I do make backups of my work regularly (1) to secure the progress I
made and (2) at specific moments before I make fundamental changes to
code and/or table design of which I am not sure whether - in the end -
they do turn out to be the improvements I intended them to be.
In between these backups, and especially when designing forms, I
regularly hit the Save button when I 'm OK with the state of the
design at a certain point. That's one click vs a whole bunch of
actions requiered to make a backup or taking the Ctrl+C and Ctrl+V
approach. I know that doesn't protect me against a crash.
After a lot of resizing / changing colors / aligning adding and
deleting controls etc I sometimes come to the comclusion that the
changes I made since last hitting the Save button were no improvements
after al, and I want to go back to the state of my design when I hit
that Save button.
Then I can undo a certain amount of changes but what if that undo-
arrow disables itself ??
As I said, I have gotten into the habit of closing without saving and
re-opening the db file, but there must be a better way..

Anyone?

Joost wrote:

I don't know if it's better, but between FE backups, I
usually rename a form/report/whatever, use Copy/Paste, give
the copy the original name and then make my experimental
changes.

--
Marsh