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

Quote:

Originally Posted by 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.

Expand|Select|Wrap|Line Numbers

 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.

Expand|Select|Wrap|Line Numbers

 '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 :)

Quote:

Originally Posted by Help

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

Quote:

Originally Posted by 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 :)

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 :)

IsLoaded

re: IsLoaded

re: IsLoaded

re: IsLoaded

re: IsLoaded

re: IsLoaded

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about