Automatic Save as - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Automatic Save as

William Kennedy

2 years ago

Is there a way to embed in your code the Save as Feature. Instead of doing it manually it would be a great help during development to be able to do that. Is there TechHelp video that does that?

	Adam Schwanz @Reply 2 years ago
What kind of Save As feature? Do you mean to save the database itself or an object inside the database?

	Richard Rost @Reply 2 years ago
Or are you talking about saving a record? Like making a copy of a record that has a lot of similar info?

	William Kennedy OP @Reply 2 years ago
No I would like to save the database with a revised name. With a command button.

	Kevin Yip @Reply 2 years ago
"Save As" requires you close everything, or it gives you an error (see picture below). If everything is closed, you can't run any code. Therefore, "Save As" cannot be run with VBA code.

	Kevin Yip @Reply 2 years ago

	Kevin Yip @Reply 2 years ago
If you want to backup your .accdb file with VBA code, there are other ways. Richard may already have videos on it. You may create another database with VBA code that copies and backs up other database files.

	Sami Shamma @Reply 2 years ago
These are the videos Kevin is talking about: Spawn Copies Spawn Copies 2

	Dan Jackson @Reply 2 years ago
This has some info with regards to backing up databases. The member part covers automation. Backup Access Access Backup Template

	Dan Jackson @Reply 2 years ago
I'm guessing there isn't a macro that can be used?

	Richard Rost @Reply 2 years ago
You could launch a batch file, PowerShell script, or another database, do whatever you need, then relaunch the DB. That's what Access Updater does.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View