Results 1 to 5 of 5
  1. #1
    DBenz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    76

    Make a form open a form and records from another access dbase ?

    Access2013.


    I open a dbase and checking through the forms, one of them says it cannot find the .mdb file.


    Its showing and older form when in design view. I need to have it open the current form for that dbase.


    As I am in the process of altering the .mdb to .accdb I need also to point that form to the .accdb file.


    However for the moment I cannot even see how one makes a form then has it bring in the form from another dbase.

    If one wants to create a form name in Forms, and bring in the form from another access dbase file, how is that done ?


    I open the form in design view and click on the black square top left corner but don’t see anywhere in properties an address to the form in the other .mdb file.
    i.e I cant see how it knows its supposed to look for another .mdb file and display a certain form from it.


    Maybe one creates the entire form all over again then points it to a table in another dbase. or maybe one can copy paste the form into this dbase from the other one to save all that redrawing. then how to have it pull in data from the source forms table ?


    DBenz

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Not really understanding issue. What does "makes a form then has it bring in the form from another dbase" mean?

    How does form "say" it can't find mdb? What code is run?

    Objects can be imported from another db.

    An MDB can be opened and saved as ACCDB.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You CAN open data in another db using linked tables and NOT have to actually open the other db.
    Would this work?

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If you want forms/reports from another db to show in the current db, pretty sure you have to set the db that contains the needed form(s) as a reference in the vb editor. Been a long time since I've ever referenced another db, so not sure.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If I open database A, I can selected External Data, then New Data Source, then from Database Access, then select the database B that contains the form you want, then select the form (and any other object(s) you want, then import to database A.

    You could describe your specific set up and requirement in more detail --- there appears to be some confusion in your post.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 12-01-2014, 09:48 AM
  2. Replies: 5
    Last Post: 11-30-2014, 12:46 PM
  3. Replies: 2
    Last Post: 03-11-2013, 08:04 PM
  4. Make Run Query to open a Form instead of a list
    By damiendellon in forum Queries
    Replies: 3
    Last Post: 01-17-2013, 10:48 PM
  5. How to make a Database Form open
    By rovman in forum Access
    Replies: 25
    Last Post: 10-31-2011, 06:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums