J
Jim Pockmire
What is the easiest way to do this? Can I use MSysObjects or do I need VBA
code on TableDefs or something else?
code on TableDefs or something else?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
Include type 6 if you want linked tables as well, and type 4 for ODBC linked
table
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
Include type 6 if you want linked tables as well, and type 4 for ODBC linked
table
J
Jim Pockmire
Out of curiosity, why are macros, forms, reports and modules a minus sign
followed by a 5 digit number, rather than a simple integer like the tables?
followed by a 5 digit number, rather than a simple integer like the tables?
Allen Browne said:SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
Include type 6 if you want linked tables as well, and type 4 for ODBC
linked table
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Jim Pockmire said:What is the easiest way to do this? Can I use MSysObjects or do I need
VBA code on TableDefs or something else?
A
Allen Browne
Access is written in C, and presumably these are unsigned rather than
negative numbers as we see them in Access.
The choice of values makes more sense in hexadecimal also.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
negative numbers as we see them in Access.
The choice of values makes more sense in hexadecimal also.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Jim Pockmire said:Out of curiosity, why are macros, forms, reports and modules a minus sign
followed by a 5 digit number, rather than a simple integer like the
tables?
Allen Browne said:SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
Include type 6 if you want linked tables as well, and type 4 for ODBC
linked table
Jim Pockmire said:What is the easiest way to do this? Can I use MSysObjects or do I need
VBA code on TableDefs or something else?