Import Form or Report, and Autoatically Delete the old Form or Rep

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.

I have my database split into front end and backend, and the database is
used in another part of the country, so want to be able to email updates and
new forms or report as they arise with their requirements. Rather than send
a whold new front end which is an option of course, I want to be able to send
the new form or report in an otherwise empty database, and import it into the
working frontend. This needs to happen via code, by the press of a button,
select what to import (or import all forms, queries and reports etc), delete
existing forms, queries etc that has the same name, and then leave it good to
go.

Any ideas.
 
My recommendation is that you just replace the front ends. It'll be a lot
less hassle and is less error-prone.

Otherwise, if you want to pursue what you seek, check out TransferDatabase
in Help file to get you started on how the VBA code would be set up to do
such things.
 
Back
Top