+ Reply to Thread
Results 1 to 9 of 9

Export Modules & Form, Report, etc. Configuration

  1. #1
    Forum Contributor
    Join Date
    12-28-2015
    Location
    US
    MS-Off Ver
    365
    Posts
    133

    Export Modules & Form, Report, etc. Configuration

    I am looking for a way to export a few key things from my application:

    1. both module code as well Form level code
    2. some type of Report, Form, Table configuration file that would allow for the database/program to effectively be rebuilt.

    Attempts to export XML or XLS files have been unsuccessful when using the built in Access feature (https://www.techrepublic.com/article...ema-using-xml/). So first things first would be to at minimum export the module and form code. I have the below that I use for Excel and Word for module export, but it's not working for Access and doesn't deal with the Form(s) code.

    Please Login or Register  to view this content.

    Secondly, I am hoping to be build a macro(s) that I can run that exports "everything else". The equivalent of a file or series of files that can be imported (once exported) to a new database and be as if I manually exported them from it's original database.

    Thanks in advance!
    Last edited by Excel4444; 06-13-2021 at 12:40 PM.

  2. #2
    Forum Contributor
    Join Date
    12-28-2015
    Location
    US
    MS-Off Ver
    365
    Posts
    133

    Re: Export Modules & Form, Report, etc. Configuration

    Solved #1 through a little more digging.

    Please Login or Register  to view this content.
    #2
    some type of Report, Form, Table configuration file that would allow for the database/program to effectively be rebuilt. still unsolved.
    Last edited by alansidman; 06-14-2021 at 05:17 PM.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Modules & Form, Report, etc. Configuration

    If you have an excel table that has been normalized, you can link it directly with Access and then create your queries and reports directly in Access as if the table was resident in Access. I am trying to understand what you are wanting and this is my best guess. If I am off target then you will have to explain in more explicit detail (even with sample data) what you hope to achieve.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Contributor
    Join Date
    12-28-2015
    Location
    US
    MS-Off Ver
    365
    Posts
    133

    Re: Export Modules & Form, Report, etc. Configuration

    Hi,

    thanks for the reply.

    For #2, I am trying to see if there's a way of exporting a type of configuration file. So when a form, query, report or table are exported from one database to another, is there like a back-end type of file that tells the new database how to setup and assemble what is being imported.

    For example, new database is being given instructions:
    1. form name = "frm_example"
    2. ComboBox_1
    height =
    width =
    left =
    top =
    rowsource =
    Events....
    code....


    so that all these "files" can be importing and effectively rebuilt a corrupt database.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Modules & Form, Report, etc. Configuration

    In a blank db, you can import existing tables, forms, queries etc.
    Attached Images Attached Images

  6. #6
    Forum Contributor
    Join Date
    12-28-2015
    Location
    US
    MS-Off Ver
    365
    Posts
    133

    Re: Export Modules & Form, Report, etc. Configuration

    I am familiar with that feature, but I was hoping there would be more of a file what could be exported that carried all of these instructions.

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Modules & Form, Report, etc. Configuration

    Are you familiar with Import Specification? That may be one way to do what you want. Here is a link for one example of this feature. Otherwise, I am out of ideas for you.

    https://www.datawright.com.au/access...text_files.htm

  8. #8
    Forum Contributor
    Join Date
    12-28-2015
    Location
    US
    MS-Off Ver
    365
    Posts
    133

    Re: Export Modules & Form, Report, etc. Configuration

    I would say more so the xml, xsl and xsd files that you can export from a database. Can those simply be loaded into a brand new database and effectively "re-build" the database/application (all forms, queries, etc.)?

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Modules & Form, Report, etc. Configuration

    What happens when you try to import those files. I have never worked with those file types. Often times, experimentation is the answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Export all modules dynamically to folder
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-06-2021, 11:54 AM
  2. Replies: 1
    Last Post: 04-01-2020, 04:56 PM
  3. [SOLVED] How to export all the vb modules in an excel file at one shot
    By invendis in forum Excel General
    Replies: 2
    Last Post: 02-21-2017, 03:39 AM
  4. Configuring a pivot from an unknown configuration to desired configuration
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2015, 11:14 AM
  5. [SOLVED] Export modules from protected projects
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2006, 05:10 PM
  6. Export modules from protected projects
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 01:10 PM
  7. [SOLVED] auto-export VBA modules
    By Christopher Merrill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1