Lost VBA code - how to import?

[Yuly17]

Hi, i have a failure in my computer and all vba code is lost in my access file and back up. All the new tables and forms are there.

I have an older back up file but i don't know how to pull the full code from one file to the other?

Can someone explain to me how to do it? I did try to export each component individually but when trying to import to the file (with the missing code) it gives me an error the module.name form_api is invalid.

Not sure what else to do.

Thanks in advance

 

[theDBguy]

You should be able to import standard and class modules, but form class modules probably require that you import the form or report objects instead.

 

[Ranman256]

docmd.transferspreadsheet...
or
docmd.transfertext....

 

[MarkK]

The Access.Application object exposes two hidden methods you might use in this case, SaveAsText() and LoadFromText(). Using SaveAsText() you can save the complete definition of any Query, Form, Report, Macro, or Module. Using LoadFromText() you can then load any saved definition back into an Access.Application object.

Here's a simple loop that copies access objects from an application called src, to an application called dst...

Sub CopyAccessObjects(SrcAllItems As Object, ObjectType As AcObjectType)
    Dim tmp As AccessObject
    Dim spec As String
    
    spec = CurrentProject.Path & "\accobj1.txt"
    
    For Each tmp In SrcAllItems
        Me.src.SaveAsText ObjectType, tmp.Name, spec
        Me.dst.LoadFromText ObjectType, tmp.Name, spec
    Next
End Sub

 

[Pat Hartman]

You can't import the total code in one go. It has to happen object by object so forms and reports are going to be a pain. You can import/export to text as suggested but that won't work in this case if you want to keep the layouts for the forms/reports and only import the old code. I think I would just bite the bullet and open two databases and go object by object and copy the text of the code from one database and paste it into the empty code module of the other. This probably does not connect the form/control event to the code module. I think you still have to click on each event procedure to connect them.

 

[arnelgp]

if it is lost, then it is lost forever.
adding more Code to it will just Overwrite your old code.

 

[amorosik]

Hi Yuly17, we use this tools for export entire Access project on text files
Basically every form, report, query, macro is exported as a single text file
For forms the initial part (of the text file) describes the user interface and the final part contains the code of the individual sub/functions
You could test this on the actual corrupted file, and try replacing the tail of each file describing a form with the code you have from the backup files And then try rebuilding the project by doing the reverse operation, and then rebuilding the project