Exporting forms to update dbase

[JohnN2006]

I have written a couple of databases that are now being used by several different Offices all over the place.

Is there a way I can export forms, reports etc so that I can carry out updates without having to have all of the databases emailed to me and amended seperatly ?

 

[sphere_monk]

Highlight the form or report you want to export and select File:Export and select the database you want to export to.

 

[JohnN2006]

The people who are using the front end databases are how shall i say it - not very computer literate.

Is there a way I can run the export function using vba ?

 

[sphere_monk]

Well, in this situation, it would be transparent to your users. It would be you exporting the form, wouldn't it? I guess I'm assuming you have access to their versions of the database. Do you have to e-mail the forms or reports to the users and have them import them?

 

[JohnN2006]

I was thinking along the lines of sending them another database file which would have all of the new forms and reports.

They open up the update file and get a button saying "click here to update" this will then import the new items into their current database.

On the users current version of their databse there are no menu bars.

All I need is the code that will export the items rather than using the File-Export menu.

 

[sphere_monk]

OK, I understand now.

I haven't done this before, but if you create a new macro, one of the steps that you can perform is "TransferDatabase". If you select this option and read the description in the lower right corner it seems to perform exactly what you're looking to do. You can pick the object type you want to import. (form, report, etc.)

Keep in mind that you may need to run a "Delete Object" step prior to the "TransferDatabase" step. I have seen forms and reports come into a new database with a (1) or (2) suffix if the form or report already exists, which would be no good since the old form wouldn't be overwritten if that is the case.

Once you get the macro to work the way you want, you could run it from the click event of a button using vb.

Hope this helps,

Dan

 

[JohnN2006]

Dan,

Thanks very much for the advice - works a treat !!

For some reason when using the code, you are not prompted to overwrite the existing object it just does it automatically. But hey as the saying goes "If it a'int broken, dont try and fix it !!"

Thanks again for quick help on this.