Results 1 to 3 of 3
  1. #1
    bbxrider is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    69

    opendatabase

    how can I do the same functionality as below only when I open a db different from the one I have
    open with opendatabase, I want dump to forms, macros, everything


    Code:
    For i = 0 To (Application.CurrentProject.AllModules.Count) - 1    modName = Application.CurrentProject.AllModules(i).Name
        DoCmd.OpenModule modName
        Set moduleObj = Modules(modName)
        If moduleObj.CountOfLines > 0 Then
           f.WriteLine (" ")
           f.WriteLine ("+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++")
           f.WriteLine ("Start of Module " & modName)
           f.Write moduleObj.Lines(1, moduleObj.CountOfLines) & " "
        End If
        DoCmd.Close acModule, modName
        Set moduleObj = Nothing
    Next

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    No code needed.
    menu bar, export, access.

  3. #3
    bbxrider is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    69
    thanks, but I was looking for a custom tool, the db is designed for non-tech users and the tool bars are turned
    off, I would like to set up a db as an utility like app that I can use to access perhaps 50+ db apps throughout the
    company domain to get internals

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

Similar Threads

  1. The DAO OpenDatabase Method
    By tagteam in forum Access
    Replies: 7
    Last Post: 10-25-2013, 03:56 PM
  2. OpenDatabase/Table as shared
    By Puebles in forum Programming
    Replies: 5
    Last Post: 10-17-2013, 06:16 AM
  3. OpenDatabase()
    By LegBone in forum Programming
    Replies: 3
    Last Post: 11-18-2012, 11:10 AM

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