IsLoaded

[JustJim]

I'm not, though I wish I was!

The un-help files tell me that I can use Isloaded to determine if an object is loaded (duh), but it doesn't tell me what loaded actually means.

I'm trying to determine if a table has been deleted so I think Isloaded is not what I want - is there something like

If Tablename Exists Then....


Thanks in advance

Jim

[JustJim]

I'm not, though I wish I was!

The un-help files tell me that I can use Isloaded to determine if an object is loaded (duh), but it doesn't tell me what loaded actually means.

I'm trying to determine if a table has been deleted so I think Isloaded is not what I want - is there something like

If Tablename Exists Then....


Thanks in advance

Jim

Apparently there isn't so I modified this from elsewhere.

Function CheckExistsAndRename(strCurrentName As String, strNewName As String)
' check to see if the table exists, if it does then rename it
Dim dbNA As Database
Dim tdf As TableDef
Set dbNA = CurrentDb()
 
For Each tdf In dbNA.TableDefs
    If tdf.Name = strCurrentName Then
        DoCmd.Rename strNewName, acTable, strCurrentName
        Exit Function
    End If  '   tdf.Name = strCurrentName
Next
 
End Function

Jim

[NeoPa]

Try this Jim.

'TableExists returns true if strName table exists.
Public Function TableExists(strName As String) As Boolean
  TableExists = False
  On Error Resume Next
  TableExists = (CurrentDb.TableDefs(strName).Name = strName)
  On Error GoTo 0
End Function

[NeoPa]

BTW If you look up the OnOpen event in the Help system it will describe how objects are loaded - opened - closed - unloaded etc. It has the correct sequence all explained in there. I enclose a short excerpt :)

When you first open a form, the following events occur in this order:

Open ==> Load ==> Resize ==> Activate ==> Current

The Close event occurs after the Unload event, which is triggered after the form is closed but before it is removed from the screen.

When you close a form, the following events occur in this order:

Unload ==> Deactivate ==> Close

[JustJim]

BTW If you look up the OnOpen event in the Help system it will describe how objects are loaded - opened - closed - unloaded etc. It has the correct sequence all explained in there. I enclose a short excerpt :)

Thank you again NeoPa, I suspected very strongly that Loaded was not what I was after. I was quite happy with the solution I nutted out although yours is, as usual, more elegant.

Thanks
Jim

[NeoPa]

No worries Jim. Just throwing in some different ideas to chew over :)