Re: List of all table names beginning with "ABCDE"
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Fri, 30 Jun 2006 22:47:30 +0800
I understand that 4 is used for ODBC linked tables.
5 = queries.
-32768 = forms
-32764 = reports
-32761 = modules.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Thelma Lubkin" <thelma@xxxxxxxxxxxxxxxxxx> wrote in message
news:e837kr$jj1$1@xxxxxxxxxx
Allen Browne <AllenBrowne@xxxxxxxxxxxxxx> wrote:
: Set the RowSource of the combo to this query statement:
: SELECT MsysObjects.[Name] FROM MsysObjects
: WHERE ((MsysObjects.[Type] IN (1, 4, 6))
: AND ([Name] Like "ABCDE*"))
: ORDER BY MsysObjects.[Name];
I've been able to find that Types 1 and 6 refer to tables and
attached tables respectively, but I haven't seen any mention of a
Type
4. What is it and where can I find a complete definition of the
MsysObjects table?
thanks, --thelma
: --
: Allen Browne - Microsoft MVP. Perth, Western Australia.
.
- References:
- List of all table names beginning with "ABCDE"
- From: MLH
- Re: List of all table names beginning with "ABCDE"
- From: Allen Browne
- Re: List of all table names beginning with "ABCDE"
- From: Thelma Lubkin
- List of all table names beginning with "ABCDE"
- Prev by Date: Re: Where Clause in OpenForm statement
- Next by Date: Sending a Pivot Table by Mail
- Previous by thread: Re: List of all table names beginning with "ABCDE"
- Next by thread: US/UK dates problem
- Index(es):
Relevant Pages
|
