Rod-
I don't know of any comprehensive and well-organized reference for all the
constants you find in Access. Just FYI, constants beginning with db are for
objects in the DAO object model. vb constants are specifically for VBA. ac
constants are unique to Access. (Really old versions of Access used A_ as
the prefix.) You can discover many of them as you wander around online
Help. One way to find them all is to open any database that has some VBA
code and the Access, DAO, and Visual Basic libraries defined. Go to the
Object Browser and select the library you want to explore in the top
drop-down box. All the constants for each library are shown under <globals>
in the Classes list. Select any constant of interest, and press F1 to open
up help on that constant. In some cases, you'll get the help page for *all*
the constants in the library.
HTH...
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
Sent: Saturday, July 06, 2013 1:15 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Where to find definitions of internal constants
Hi all,
I am trying to expand my understanding of Access 2010. I have been looking
at some code that uses internally defined constants (I believe). One such
constant is dbAttachedTable. I believe I understand it but was wondering if
there is any documentation on other constants that would be helpful. I am
sure they would be useful and helpful in coding.
This constant appears very helpful in determining the status of linked
tables. Hopefully other would help in checking status of other properties.
Thanks for any info.
Rod
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar