Recover deleted access form

[Dausa67]

Hi,
I have been working on a access data base for the last couple of days. I don't know how I did it but I managed to delete my most important form. Does anyone know how I can recover the form with out installing software. This is my work PC so I am blocked from installing software.

Clay

 

[MajP]

Any chance it is not really deleted? Maybe hidden? That is kind of hard to do on accident.

Create a blank database and import all the forms from your current db. Maybe it will show in the list. Or you could run something like this just to double check:

Public Sub showForms()
Dim frm As Access.AccessObject
Dim strFrms As String
For Each frm In CurrentProject.AllForms
strFrms = strFrms & vbCrLf & frm.Name
Next frm
MsgBox strFrms
End Sub

 

[MajP]

That is because AFAIK you are out of luck. However, I think you will find it a lot easier to build the second time.

 

[lameid]

If you really deleted it, the best answer would be to import the object from a backed up copy of the file containing the form... Or if you did not make the application, likely there is a central copy of the application you are using and all you have to do is get a fresh one (back up your file to be safe first).

 

[Hap007]

Possibly you accidently renamed the form instead of actually deleting the form.

I would sort all the forms by date modified and see if it shows up.

Otherwise, you have learned an important lesson, backup!

When I am doing development work, I exit the Access mdb every hour or 2 and use explorer to make a copy of the database(App). Then, at the end of the day or at a milestone point, I make a copy and copy it to another area on the network or a different hard drive.

Now, if I ever delete or corrupt a Db, I only need to go back one hour.

Hope This helps you now or sometime in the future,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121