| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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; |
|
#2
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; |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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; |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Hybrid Mode
