Pulling out Forms and table from another DB

Posted on 2014-11-04
Last Modified: 2014-11-04
If I pull a form and relating tables from one DB to another..will the code follow?
Question by:Jass Saini
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
LVL 24

Expert Comment

ID: 40422353
You will have to copy all relevant code separately

Expert Comment

ID: 40422355
Code that is embedded on the form - yes (assuming you use import/export and not copy/paste)

Author Comment

by:Jass Saini
ID: 40422364
Which one is it..Yes or no.  If I import or export, will it be a permanent form?
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.


Accepted Solution

ReneD100 earned 500 total points
ID: 40422378
It is definitely a yes. The article posted is also about copy/paste and then you do lose the code. If you export the form to a different access file the code will go along.

If your source uses code located in modules or classes you may need to export/import that as well.

It doesn't matter if you export TO a destination Access file, or open the destination and then import FROM the source.

Author Closing Comment

by:Jass Saini
ID: 40422425
Thank You..

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question