Thanks John, that should keep me busy but will help in learning more about the internals of Access. Great Help thanks again.
Rod
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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 (3) |
Tidak ada komentar:
Posting Komentar