Old form references in MSysQueries and MSysObjects

G

Guus2005

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?
 
T

Thomas [PBD]

Guus,

Might suggest posting this in the Access Communities board, as this is the
Excel Board.
Sorry mate.
 
G

Guus2005

Oops, sorry.

Thomas said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top