ExcelBanter - Old form references in MSysQueries and MSysObjects

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Old form references in MSysQueries and MSysObjects (https://www.excelbanter.com/excel-discussion-misc-queries/192551-old-form-references-msysqueries-msysobjects.html)

Guus2005

Old form references in MSysQueries and MSysObjects

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?

Thomas [PBD]

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?

Guus2005

Old form references in MSysQueries and MSysObjects

Oops, sorry.

"Thomas [PBD]" wrote:

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?

All times are GMT +1. The time now is 10:03 AM.