Group:  Microsoft Access ยป microsoft.public.access.modulescoding
Thread: How do I programmatically reference and manipulate the properties of "CurrentProject" from another database?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How do I programmatically reference and manipulate the properties of "CurrentProject" from another database?
"Kan D." <nobody[ at ]nowhere.com> 14.08.2006 16:39:09
How do I programmatically reference and manipulate the properties of
"CurrentProject" from another database?

The below example references "CurrentProject" within the current database,

but I want to connect to another database and use the "CurrentProject"
feature of THAT database

I added line 3 "dim accApp As Access.Application", as I'm pretty sure this
line is neccessary, but the rest of my code here obviously does not refer to
another database:

==================================

dim accObj as AccessObject
dim myDate as string
accApp As Access.Application (<<< line 3)


for each accObj in CurrentProject.AllForms

mydate = accObj.DateModified

next accObj

==================================


Re: How do I programmatically reference and manipulate the properties of "CurrentProject" from another database?
<david[ at ]epsomdotcomdotau> 20.08.2006 10:39:03
Each Access application will have a current project
(if one is loaded)

AccApp.LoadCurrentProject

AccApp.CurrentProject

Not sure about the name of LoadCurrentProject -
you will have to check that one.

(david)


"Kan D." <nobody[ at ]nowhere.com> wrote in message
news:ezc$rA8vGHA.2436[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text]
> How do I programmatically reference and manipulate the properties of
> "CurrentProject" from another database?
>
> The below example references "CurrentProject" within the current database,
>
> but I want to connect to another database and use the "CurrentProject"
> feature of THAT database
>
> I added line 3 "dim accApp As Access.Application", as I'm pretty sure this
> line is neccessary, but the rest of my code here obviously does not refer
to
> another database:
>
> ==================================
>
> dim accObj as AccessObject
> dim myDate as string
> accApp As Access.Application (<<< line 3)
>
>
> for each accObj in CurrentProject.AllForms
>
> mydate = accObj.DateModified
>
> next accObj
>
> ==================================
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net