|
Posted to microsoft.public.excel.misc
|
|
|
Old form references in MSysQueries and MSysObjects
Guus,
Might suggest posting this in the Access Communities board, as this is the
Excel Board.
Sorry mate.
--
--Thomas [PBD]
Working hard to make working easy.
"Guus2005" wrote:
This query show me forms i once had in my Access 2003 database.
Code:
SELECT
IIf(Left$([Name],1)="~",Mid$(GetPart([Name],"~",2),5),[Name]) AS Form,
MSysObjects.Owner, MSysObjects.Name, MSysQueries.Attribute,
MSysQueries.Expression, MSysQueries.Flag, MSysQueries.LvExtra,
MSysQueries.Name1, MSysQueries.Name2, MSysQueries.ObjectId, MSysQueries.Order
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id;
How do i get rid of them?
|